Cant connect to MYSQL database with root account

Posted August 8, 2019 3.3k views
NginxMySQLPHPUbuntu 18.04

Could this be a problem with the firewall? Because I also hosted a game server and its works fine with the localhost. In fact, for I use the same database for the web and game server.

I also tried to create a new user with all the permissions. But still not working and throw the same error message

Connection failed: Access denied for user ‘root’@'localhost’ (using password: YES)

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

mysql -u root -p
then it will ask for the root password