MySQL Priviliges - I'm dumbfounded
Posted 16 June 2003 - 02:59 PM
I\'m running Windows Server 2003 and set up a database for a simple website I\'m working on. I\'m using phpMyadmin. Over the weekend, the power went out in my office and the server was restarted. Now, when I load up phpMyadmin, or when my website tries to access the database, I get incorrect user/pass. I can still log into phpMyadmin as root, though I think thats only because anyuser@localhost will work. When i look in the privilige tables, even after flushing and reloading them, I can still see my usual username. I even created a new user with a password successfully, and then tried logging in to no avail.
For some reason, I have a feeling that some security setting changed with windows server 2003. Does anyone have any clue what I should do, I\'m so frustrated!?
Posted 16 June 2003 - 04:44 PM
In PHPMyAdmin, when you deal with users (from version 2.4.0 I think) the service is automatically restarted (tell me if I\'m wrong). I remember creating new users in MySQL in an older version of PHPMyAdmin and I had to restart the server each time I wanted the newly created user to be active. You can restart MySQL with PHPMyAdmin on the home page (Restart MySQL).
This should work. Also, if you set the users in your db but didn\'t restarted MySQL and your server crashed, this explains why you should really restart MySQL when you do modifications on users.
Posted 16 June 2003 - 05:07 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users