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
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
[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
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
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
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
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. Type
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
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 denied
]
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 create a database and set the grant properties to
root@localhost
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] 57953
simrad_4#
[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
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 'root'@'localhost
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'. I
14 matches
Mail list logo