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
Post a Comment