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,
When you’re running a business that relies on website traffic and sales to succeed. Then you need to keep it…
Migration! Yes, this word is very big in the web hosting industry and it has its importance. Especially for businesses…
The server is the backbone of the web hosting industry and it acts like a HERO in the web hosting…
Imagine you are on holiday having a cup of tea and browsing your website or blog.Then, what next?You will get…
The web hosting industry is growing every minute, day, and year. It has many terminologies that are important to understand…