Mysql "access denied for user" error?
I have just added a new database and imported alot of backed up data to it because of a malfunction in the previous database.
I 开发者_JAVA百科use php and have my own Ubuntu server.
I use phpmyadmin, and have set all privileges to the user.
I am positive the password, username and host are correct.
But I still get this "Access denied for user 'user'@'localhost' to database 'skuffen2'"
What should I do?
Do I need to set permissions somehow on the server?
Please guide me I am in deep need of help right now...
Thanks
login to mysql using root user, use mysql; select * from db where user where user_name=xxx;
and check other table as well, most of the privileges settings are there, or just simply flush privileges;
精彩评论