Re: Locked myself out of the mysql database!
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 mysql\bin is on my PATH. so i use mysqld-nt --skip-grant-tables. it stops automatically. i go to mmc and to services panel. and open mysql41 services properties. in commands there is : mysqld-nt --default-files=path_to_ini_\mysql.ini MYSQL41 so i try mysqld-nt --default-files=path_to_ini_\mysql.ini --skip-grant-tables(without any service name). it runs. however when i execute mysqladmin -u root flush-privileges password newpwd mysql complains that it can't find any entry on user table. any idea ? thanks. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Locked myself out of the mysql database!
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:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Locked myself out of the mysql database!
[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 can then log in as root with no password and then reset the password. Then stop mysql and restart it normally. In linux: mysqld --skip-grant-tables In windows: mysqld-nt --skip-grant-tables --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Locked myself out of the mysql database!
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 and restore my mistake? Thanks, jay -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Locked myself out
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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Locked myself out
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 solution to delete the whole thing and re-install it? stop the mysql process, then restart it with the --skip-grant-tables option, reset the passwords, and then restart it as normal. -- Jim Richardson http://www.eskimo.com/~warlock Have you ever noticed that at trade shows Microsoft is always the one giving away stress balls? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I blew it big time... locked myself out of mysql
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 'xx';
ERROR 1047: Unknown command
bonjour,
I get this error once. My root was'nt really root so couldn't use
GRANT command. That is the same for a bash command you're not allowed to use
as normal user.
You need add a root password:
[shell]mysql -u root mysql
mysql update user set Password=password('x') wher User='root';
jean-michel
-
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
I blew it big time... locked myself out of mysql
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
Re: I blew it big time... locked myself out of mysql
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 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. Start mysqld with the --skip-grant-tables option, as described in the manual. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.29: up 59 days, processed 524,505,815 queries (102/sec. avg) - 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
Re: I blew it big time... locked myself out of mysql
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 'xx'; 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
Re: I blew it big time... locked myself out of mysql
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# 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 'xx'; ERROR 1047: Unknown command that should be: grant all on *.* to root@localhost identified by 'xx' with grant option; Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
Re: I blew it big time... locked myself out of mysql
[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 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# 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 'xx'; ERROR 1047: Unknown command that should be: grant all on *.* to root@localhost identified by 'xx' with grant option; Turns out I get the same error message when I try the command that way too. -- Chip Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
Re: I blew it big time... locked myself out of mysql
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' identified by 'xx' with grant - Here's what I tried - what could possibly be wrong with this? mysql grant all on *.* to 'root'@'localhost' - identified by 'xx' - with grant option; ERROR 1047: Unknown command mysql grant all on * to 'root'@'localhost' - identified by 'xx' - with grant option; ERROR 1047: Unknown command Still not working. -- chip -- [EMAIL PROTECTED] schrieb am Dienstag, 14. August 2001, 22:54:48: [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 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# 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 'xx'; ERROR 1047: Unknown command that should be: grant all on *.* to root@localhost identified by 'xx' with grant option; Turns out I get the same error message when I try the command that way too. -- Chip Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 ยท Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
Re: I blew it big time... locked myself out of mysql
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 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. http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Resetting_permissions -- Butch Evans http://www.ChristInVerse.com/ http://www.HeIsComingSoon.com/ (in the works) - 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
