View Full Version : Starting and stopping MySQL
ScottInTexas
07-31-2007, 05:16 PM
I set up a user (me) to open the data base and extract info. I granted myself everything but I can't access the DB under my name and passwordc because I think I have to restart mysql to get the new user established. The problem is I don't have a clue how and the interface I am using installs or uninstalls as a service and that didn't seem to work.
guelphdad
07-31-2007, 06:23 PM
how did you create a new user? did you use GRANT? if so then no you don't need to restart the server.
if you just updated the user table within the mysql database that manages user privileges you need to issue:
FLUSH PRIVILEGES
for that new user/password to take effect.
can you also tell us what os you are running?
vBulletin® v3.8.2, Copyright ©2000-2009, Jelsoft Enterprises Ltd.