mysql> use mysql; but ... ERROR 1044 (42000): Access denied for user '' @ 'localhost' to database 'mysql' -


using mysql.exe enter command mysql> use mysql; there error:

error 1044 (42000): access denied user '' @ 'localhost' database 'mysql'

  • what mean?
  • how can access mysql database?
  • the important thing want reset password mysql database, error occurs when enter command: mysql> use mysql;

thanks all, found reset root password wrong mysql config… , works me :)

-go xampp\mysql\bin\ folder
-edit my.ini , insert skip-grant-tables below [mysqld]
-restart mysql
-set new password root user running update mysql.user set password=password('new_password') user='root' in phpmyadmin in mysql database (or leave if mysql cannot accessed remote hosts)

andrekr


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -