Jun 8, 2001 #1 simanek Programmer Jan 19, 2001 137 US Does anyone know how to reset the root password for the mysql database without actually knowing it? Thanks. Mike
Does anyone know how to reset the root password for the mysql database without actually knowing it? Thanks. Mike
Jun 11, 2001 1 #2 Broccoli2 MIS Mar 26, 2001 161 GB Try restarting the server with the Code: --skip-grant-tables option, then connect and update the Code: user table in the Code: mysql database manually (or use Code: GRANT . Then Code: FLUSH PRIVELEGES . Voila. Documentation about this process is available at http://www.mysql.com/doc/R/e/Resetting_permissions.html Upvote 0 Downvote
Try restarting the server with the Code: --skip-grant-tables option, then connect and update the Code: user table in the Code: mysql database manually (or use Code: GRANT . Then Code: FLUSH PRIVELEGES . Voila. Documentation about this process is available at http://www.mysql.com/doc/R/e/Resetting_permissions.html