mysql, need to reset root pass

I forgot my root pass for mysql. I have a dedicated Linux server with CI HOST. I work with mysql alot on Win32 systems and know how to reset the password by shutting down the server and starting it up with --skip-grant-tables, however, i am having problems doing the same on the linux box.

the only way i can shut mysql down properly is to do

# service mysqld stop
then start it back up by doing

# safe_mysqld --skip-grant-tables &
which results in the following:

touch: creating `/usr/local/mysql/var/dunndeal.propagation.net.err': No such file or directory
chown: getting attributes of `/usr/local/mysql/var/dunndeal.propagation.net.err': No such file or directory
Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/bin/safe_mysqld: /usr/local/mysql/var/dunndeal.propagation.net.err: No such file or directory
/usr/local/mysql/bin/safe_mysqld: /usr/local/mysql/var/dunndeal.propagation.net.err: No such file or directory
tee: /usr/local/mysql/var/dunndeal.propagation.net.err: No such file or directory
040401 09:40:05 mysqld ended
tee: /usr/local/mysql/var/dunndeal.propagation.net.err: No such file or directory
I tried following the documentation on mysql.com for bringing down the mysql server and resetting the password but that doesnt work.

I am going to cry.... mysql, need to reset root pass

Help a *nix n00b?

 

 

 

 

Top