This error occurs when I run the following command:
1 |
mysqlcheck -u root -p databasename |
Note that the command prompts for a password, and I input the correct password for the user root. Why does it still deny the access for root? If you ran the following command:
1 |
mysql -u root -p databasename |
There would not be a problem at all. In fact, you should run the following command to check/repair a database/table:
1 |
mysqlcheck -u root -p -r databasename |