Error with mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

Alternatively, if you still haven’t run mysql_secure_installation:

You need to change the authentication parameters, to do so just run this command first.

$ sudo mysql

Then run This ALTER Query to change the authentication parameters.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'mynewpassword';

And now, you are able to run mysql_secure_installation command.

$ sudo mysql_secure_installation

Hope that solve your issue,

Hi @DavidLuceroSigcho,

If you’ve used the mysql_secure_installation then you’ll need to use a password when connecting to your root user.

mysql -u root -p

This will ask you for the root MySQL password. Once you give it, you’ll enter.

If you don’t want to use a password for MySQL when you are root, you can create a file in /root/.my.cnf and add the following:

[mysql]
user=root
password=RootPasswordHere

where RootPasswordHere is your actual password.