I am unable to access Mysql from PHP

Question

I have the following problem, I use Ubunto and installed mariadb, and when I try to access mysql with:

mysql -u root

The following error appears:

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

And then I can access it using:

sudo mysql -u root

And now, when I try to do:

$conexao = mysqli_connect('localhost', 'root', '', 'php_alura');

Nothing happens, and my page doesn’t even render.

Can someone help me?

Updating:

One observing important is that I can only access mysql by Bach using the permission sudo, that is to say with:

sudo mysql -u root

I can get access.

Answer 1

Are you just connecting or are running a query as well ?

The code below executes the connection and makes the check if there was error, in case of error will show the error message and finish, in case of success in the connection will show the success message and then close the connection with the database.

<?php
$link = mysqli_connect("HOST", "USUARIO", "SENHA", "BASE");
if (!$link) {
    echo "Error: Falha ao conectar-se com o banco de dados MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}
echo "Sucesso: Sucesso ao conectar-se com a base de dados MySQL." . PHP_EOL;
mysqli_close($link);

Updating

Follow the steps in the order: 1 - finish mysql:

sudo /usr/local/mysql/support-files/mysql.server stop

2 - Start it in safe mode:

sudo mysqld_safe --skip-grant-tables

3 - This will be a continuous command until the process is over, so open another shell/ terminal window and log in without a password as root:

mysql -u root
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NOVASENHA';

Change NOVAPASSWORD for a desired password and start Mysql

sudo /usr/local/mysql/support-files/mysql.server start