Re: Locked myself out of the mysql database!

2005-02-10 Thread f f
hi, 1. i have same problem. SPEC : winxp sp2 + recent security bug patch. mysql 4.1.9. the docs : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html just doesnt't worked. snip At the DOS command prompt, execute this command: C:\ C:\mysql\bin\mysqld-nt --skip-grant-tables /snip

Locked myself out of the mysql database!

2005-01-12 Thread Jay Paulson
Like an idiot I locked myself out of the mysql database when I went to change the password for the root user. Is there any way I can get back into that database and restore my mistake? Thanks, jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: Locked myself out of the mysql database!

2005-01-12 Thread Tom Crimmins
[snip] Like an idiot I locked myself out of the mysql database when I went to change the password for the root user. Is there any way I can get back into that database and restore my mistake? [/snip] Stop the mysql serivce, then start it from a command line with the skip-grant-tables option. You

Re: Locked myself out of the mysql database!

2005-01-12 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html Jay Paulson [EMAIL PROTECTED] wrote: Like an idiot I locked myself out of the mysql database when I went to change the password for the root user. Is there any way I can get back into that database