Table of Contents
Hello,
Error code :
Error: Connection to the database server has failed because the supplied account does not possess administrative privileges:
Access denied for user ‘admin’@’localhost’ to database
Solution :
root@server01[~]#mysql mysql>use mysql mysql>select * from user where user='admin' \G *************************** 1. row *************************** Host: localhost User: admin Password: kjh2170b0d299d60 Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 1 row in set (0.00 sec) mysql>GRANT ALL ON *.* to admin@localhost; mysql>GRANT ALL ON *.* to admin@'%'; mysql>update user SET Grant_priv='Y' WHERE User = 'admin'; Quit the mysql shell and you are done.
Also read,
If you’re new to web hosting, the idea of moving your website from one provider to another might sound intimidating.…
WooCommerce powers over 5 million online stores, and its true potential comes alive with plugins that enhance functionality. The right…
When you first launch a WordPress website, it comes with a theme that controls how your site looks and feels.…
Introduction Prime Minister Narendra Modi’s clarion call — “Make in India, Make for the World” — is not just a…
Customer support has always been the backbone of the web hosting industry. From helping users set up domains to troubleshooting…