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,
As the demand for virtual private servers (VPS) continues to grow, businesses and individuals are faced with a crucial decision:…
Web hosting is a large industry, as many other factors help any web hosting provider to form a company. The…
Welcome to the complete guide to WordPress security best practices in 2024. As technology evolves rapidly, implementing strong security measures…
Hey, wanted to learn about web hosting? Or do you want to start a new website and need hosting? Questions…
In today's digital world, the threat of DDoS attacks has become increasingly prevalent. These types of attacks have the power…