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. At the DOS command prompt, execute this command: C:\> C:\mysql\bin\mysqld-nt --skip-grant-tables mysql\bin is

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 th

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

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

2004-03-29 Thread Jim Richardson
On Mon, Mar 29, 2004 at 08:44:28PM -0800, Gene H. Dreher wrote: I seem to have locked myself out of my database. RH8/4.0.18-standard ... the key user does not have file/reload/etc access. and no access at all to database mysql.. Is there some way to break this down as system root or is the only

Locked myself out

2004-03-29 Thread Gene H. Dreher
I seem to have locked myself out of my database. RH8/4.0.18-standard ... the key user does not have file/reload/etc access. and no access at all to database mysql.. Is there some way to break this down as system root or is the only solution to delete the whole thing and re-install it

Re: I blew it big time... locked myself out of mysql

2001-08-15 Thread oltra jean-michel
> simrad_4# safe_mysqld --skip-grant-tables & > [1] 57953 > simrad_4# Starting mysqld daemon with databases from /var/db/mysql > simrad_4# mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1 to server version: 3.23.38 > Type 'help;' or '\h' for help.

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread Butch Evans
On Tue, 14 Aug 2001 [EMAIL PROTECTED] wrote: >I used mysqladmin to create a database and set the grant properties to >root@localhost with the password, but now am unable to use mysql at all. >How can I rectify this problem? When I try to access mysql I get >'Access denied for user root@localhost'

RE: I blew it big time... locked myself out of mysql

2001-08-14 Thread Carsten H. Pedersen
> >>Thanks for all the replies, I have followed the instructions in the > manual > >>and am still getting > >>an error, here is the message: > >>--- > >>simrad_4# safe_mysqld --skip-grant-tables & > >>[1] 57953 > >>simrad_4# Starting mysqld daemon with datab

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread chip . wiegand
Werner Stuerenburg <[EMAIL PROTECTED]> on 08/14/2001 11:55:37 PM Internet mail from: Please respond to Werner Stuerenburg <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: I blew it big time... locked myself out of mysql I think it is grant all on *.* to '

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread chip . wiegand
[EMAIL PROTECTED]@bellsouth.net on 08/14/2001 10:03:13 PM Internet mail from: Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: I blew it big time... locked myself out of mysql On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread mickalo
On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PROTECTED] wrote: >>Thanks for all the replies, I have followed the instructions in the manual >>and am still getting >>an error, here is the message: >>--- >>simrad_4# safe_mysqld --skip-grant-tables & >>[1] 579

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread chip . wiegand
ernet mail from: To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: I blew it big time... locked myself out of mysql This link, http://www.mysql.com/doc/P/r/Problems.html is a life-saver. Check out A.9 for your specific problem. Hans [EMAIL PROTECTED] wrote: > I used mysqladmin to

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread Jeremy Zawodny
On Tue, Aug 14, 2001 at 10:14:58AM -0700, [EMAIL PROTECTED] wrote: > > I used mysqladmin to create a database and set the grant properties > to root@localhost with the password, but now am unable to use mysql > at all. How can I rectify this problem? When I try to access mysql > I get 'Access den

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread Hans Zaunere
This link, http://www.mysql.com/doc/P/r/Problems.html is a life-saver. Check out A.9 for your specific problem. Hans [EMAIL PROTECTED] wrote: > I used mysqladmin to create a database and set the grant properties to > root@localhost with the password, but now am unable to use mysql at all. >

I blew it big time... locked myself out of mysql

2001-08-14 Thread chip . wiegand
I used mysqladmin to create a database and set the grant properties to root@localhost with the password, but now am unable to use mysql at all. How can I rectify this problem? When I try to access mysql I get 'Access denied for user root@localhost'. I have tried, from the command line, with -uroot