Jimmy's weblog

Since you are my readers, and I have not been much of a traveller, I will not talk about people a thousand miles off, but come as near home as I can. As the time is short, I will leave out all the flattery, and retain all the criticism. — Henry David Thoreau

Archive for May 18th, 2004

Resetting the MySQL root password

Tuesday May 18, 2004 07:24

To reset the MySQL root password under Red Hat Linux:
[root@host root]# service mysqld stop
[root@host root]# /usr/libexec/mysqld -Sg –user=root &
[root@host root]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 3.23.58

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.

mysql> USE mysql
Reading table [...]

Posted in Linux | 1 Comment »