#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    11
    Rep Power
    0

    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?
    Thanks,
    Paul
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    11
    Rep Power
    0
    OK I found the problem. I should opened the mysql monitor like this: mysqk -u root Now everything works

IMN logo majestic logo threadwatch logo seochat tools logo