mysql: root access denied ~ driving me nuts!

Discussion in 'Server Operation' started by domino, Jan 15, 2007.

  1. domino

    domino New Member

    everything was working well until i changed permissions on root (i'm stupid) and now mysql sees root as anon. user. root only has access to test db and nothing else. how can i give root back it's god status to all db's?
  2. martinfst

    martinfst ISPConfig Developer ISPConfig Developer

    Is there another user in your MySQL setup with root alike rights you can use to restore root?
  3. domino

    domino New Member


    Unfortunately, there isn't. I am open to any suggestions that can resolve this issue.

  4. martinfst

    martinfst ISPConfig Developer ISPConfig Developer

  5. domino

    domino New Member

    Thank you martinfst. That pointed me to the right direction. Though that post was old, i just had to use service mysqld stop, which allowed me to continue the rest of the way. I did have some problems with the other commands. Luckily, I had webmin installed and headed over to the MySQL Database Server section and changed the password there.


Share This Page