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