Why Does My Web App Get 'Access denied for user 'root'@'localhost'' Even Though `mysql -u root -p` Works?

Troubleshooting "Access denied for user 'root'@'localhost'... (Mysql::Error)"

When attempting to deploy a web application on a server, users may encounter the "Access denied..." error while accessing the MySQL database. Despite being able to execute database operations using the "mysql -u root -p" command, the exception persists within the web application.

Solution:

To resolve this issue, you must grant access to the 'root' user from 'localhost' within the MySQL database. Follow the Ubuntu help documentation for instructions on how to grant access. Here are the general steps:

1. Log in to MySQL as the root user:

mysql -u root -p

2. Grant access to the root user:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'your_password';

3. Flush the privileges table to apply the changes:

FLUSH PRIVILEGES;

Once you have granted access, you should be able to successfully connect to the MySQL database from your web application without encountering the "Access denied..." error.

The above is the detailed content of Why Does My Web App Get 'Access denied for user 'root'@'localhost'' Even Though `mysql -u root -p` Works?. For more information, please follow other related articles on the PHP Chinese website!