April 2nd, 2013, 05:29 PM
Access denied for user created database
I created a database using phpmyadmin on localhost. I then tried to use the commandline interface, "mysql.exe" to access the database. when I typed use producer; I got an ERROR 1044 (42000) Access denied msg. The same when I tried "use mysql". When I type use test everything is ok. I can understand "mysql DB because I guess it's a system DB. I can access any database using phpmyadmin including producer. Can someone help me please?
April 2nd, 2013, 06:00 PM
OK I found the problem. I should opened the mysql monitor like this: mysqk -u root Now everything works