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 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 '\c' to clear the buffer mysql> grant all privileges on *.* to root@localhost identified by 'xxxxxx'; ERROR 1047: Unknown command -------------------------------------------- I have tried a number of variations on the grant statement above but they all fail with the same message. More suggestions? -- Chip Hans Zaunere <[EMAIL PROTECTED]> on 08/14/2001 07:37:55 PM Internet 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 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 -ppassword and get the same results. Please help ASAP. > I have always been able to connect as root with just 'mysql' at the prompt. > > -- > Chip Wiegand > Computer Services > www.simradusa.com > [EMAIL PROTECTED] > Simrad, Inc > Lynnwood, WA > 425-712-1138 > > "There is no reason anyone would want a computer in their home." > --Ken Olson, president, chairman and founder of Digital Equipment Corp., > 1977 > (-- Then why do I have nine? Somebody help me!) > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php (See attached file: hz11.vcf)
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php