Re: How to change root password?
None, of these suggestions worked... Tried the following ways to reset the password: (1) Shut down MySQL via System Preferences pane (2) Placed the following in a text file: UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root'; FLUSH PRIVILEGES; (3 Invoked the following command from the command line in Bash: mysqld_safe --init-file=/Users/raven/mysql-init [1] 2236 Received these errors: mysqld_safe Logging to '/usr/local/mysql/data/Valkyrie.local.err'. touch: /usr/local/mysql/data/Valkyrie.local.err: Permission denied chown: /usr/local/mysql/data/Valkyrie.local.err: Permission denied mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data /usr/local/mysql/bin/mysqld_safe: line 105: /usr/local/mysql/data/Valkyrie.local.err: Permission denied rm: /usr/local/mysql/data/Valkyrie.local.pid: Permission denied /usr/local/mysql/bin/mysqld_safe: line 142: /usr/local/mysql/data/Valkyrie.local.err: Permission denied mysqld_safe mysqld from pid file /usr/local/mysql/data/Valkyrie.local.pid ended /usr/local/mysql/bin/mysqld_safe: line 105: /usr/local/mysql/data/Valkyrie.local.err: Permission denied On Nov 15, 2009, at 11:37 PM, Alexey Mykhailov wrote: On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson michaelwilso...@gmail.com wrote: I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for root user and wish to either change it back to blank or a new specific password. What should I type from the command line? When I tried: mysqladmin -uroot -p The Bash shell listed out all the possible arguments which the mysqladmin could utilize: mysqladmin Ver 8.42 Distrib 5.4.3-beta, for apple-darwin9.5.0 on i386 Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Administration program for the mysqld daemon. Usage: mysqladmin [OPTIONS] command command -c, --count=# Number of iterations to make. This works with -i (--sleep) only. --debug-check Check memory and open file usage at exit . // etc Would appreciate if someone could help... -Michael http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to change root password?
Make sure your mysql server is not accessible to anyone else, its a good idea to disconnect all network connections because the server will be totally insecure for a short period of time! Start your MySQL server with the --SKIP-GRANT-TABLES option. At a shell prompt type mysql -uroot (you may have to add -h and -p options to the command above if you are using a non-standard host or port). You should get a mysql prompt, at the mysql prompt type USE mysql; Followed by FLUSH PRIVILEGES; Then type UPDATE user set password = password('new_pass') where user='root'; Replacing new_pass with your desired password. Now type FLUSH PRIVILEGES; EXIT; and restart the server without --SKIP-GRANT-TABLES Regards On Mon, 2009-11-16 at 16:56 -0800, Michael Wilson wrote: None, of these suggestions worked... Tried the following ways to reset the password: (1) Shut down MySQL via System Preferences pane (2) Placed the following in a text file: UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root'; FLUSH PRIVILEGES; (3 Invoked the following command from the command line in Bash: mysqld_safe --init-file=/Users/raven/mysql-init [1] 2236 Received these errors: mysqld_safe Logging to '/usr/local/mysql/data/Valkyrie.local.err'. touch: /usr/local/mysql/data/Valkyrie.local.err: Permission denied chown: /usr/local/mysql/data/Valkyrie.local.err: Permission denied mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data /usr/local/mysql/bin/mysqld_safe: line 105: /usr/local/mysql/data/Valkyrie.local.err: Permission denied rm: /usr/local/mysql/data/Valkyrie.local.pid: Permission denied /usr/local/mysql/bin/mysqld_safe: line 142: /usr/local/mysql/data/Valkyrie.local.err: Permission denied mysqld_safe mysqld from pid file /usr/local/mysql/data/Valkyrie.local.pid ended /usr/local/mysql/bin/mysqld_safe: line 105: /usr/local/mysql/data/Valkyrie.local.err: Permission denied On Nov 15, 2009, at 11:37 PM, Alexey Mykhailov wrote: On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson michaelwilso...@gmail.com wrote: I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for root user and wish to either change it back to blank or a new specific password. What should I type from the command line? When I tried: mysqladmin -uroot -p The Bash shell listed out all the possible arguments which the mysqladmin could utilize: mysqladmin Ver 8.42 Distrib 5.4.3-beta, for apple-darwin9.5.0 on i386 Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Administration program for the mysqld daemon. Usage: mysqladmin [OPTIONS] command command -c, --count=# Number of iterations to make. This works with -i (--sleep) only. --debug-check Check memory and open file usage at exit . // etc Would appreciate if someone could help... -Michael http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to change root password?
Okay, that worked, thank you! -Mike On Nov 16, 2009, at 6:49 PM, Hassan Schroeder wrote: On Mon, Nov 16, 2009 at 6:15 PM, Michael Wilson michaelwilso...@gmail.com wrote: I don't know what the password is for the Unix mysql user... You mean sign in as mysql in the OS X Login Window? Just open a terminal window, type `sudo bash` and you'll be the root user. Then you can type `su - mysql` to become the mysql user. And of course, if mysql runs as a different user use that :-) Then you should be able to use that procedure, though frankly I've never seen it before; I've always used the --skip-grant-tables option. cheap 'n' cheerful, in the Canadian idiom :-) HTH, -- Hassan Schroeder hassan.schroe...@gmail.com twitter: @hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
How to change root password?
I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for root user and wish to either change it back to blank or a new specific password. What should I type from the command line? When I tried: mysqladmin -uroot -p The Bash shell listed out all the possible arguments which the mysqladmin could utilize: mysqladmin Ver 8.42 Distrib 5.4.3-beta, for apple-darwin9.5.0 on i386 Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Administration program for the mysqld daemon. Usage: mysqladmin [OPTIONS] command command -c, --count=# Number of iterations to make. This works with -i (--sleep) only. --debug-check Check memory and open file usage at exit . // etc Would appreciate if someone could help... -Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to change root password?
Michael Wilson írta: I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for root user and wish to either change it back to blank or a new specific password. What should I type from the command line? When I tried: http://lmgtfy.com/?q=mysql+reset+root+password t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to change root password?
On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson michaelwilso...@gmail.com wrote: I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for root user and wish to either change it back to blank or a new specific password. What should I type from the command line? When I tried: mysqladmin -uroot -p The Bash shell listed out all the possible arguments which the mysqladmin could utilize: mysqladmin Ver 8.42 Distrib 5.4.3-beta, for apple-darwin9.5.0 on i386 Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Administration program for the mysqld daemon. Usage: mysqladmin [OPTIONS] command command -c, --count=# Number of iterations to make. This works with -i (--sleep) only. --debug-check Check memory and open file usage at exit . // etc Would appreciate if someone could help... -Michael http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how to change root password
Hi everyone, I was installing drupal on my webserver with mysql after i followed instructions on how to configure and setup drupal i cant't access the root password of my mysql. my password won't work all. Any idea how to change my password of root? or is is passible that my mysql is currupted? Any help? Thank you. :' ' ' ' ': Arnel G. Pastrana ::' : [EMAIL PROTECTED] . ` '` `- Debian - when you have better things to do than fixing a system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to change root password
On 2/26/06, Arnel Pastrana [EMAIL PROTECTED] wrote: Hi everyone, I was installing drupal on my webserver with mysql after i followed instructions on how to configure and setup drupal i cant't access the root password of my mysql. my password won't work all. Any idea how to change my password of root? or is is passible that my mysql is currupted? Any help? http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to change root password - getting error
Hello. Worst case, do I just uninstall and reinstall mysql? Don't panic :) My opinion: this situation looks similar to the example described at: http://dev.mysql.com/doc/mysql/en/Connection_access.html May be you have several entries at user table. Can you login using your old password? If no, run mysqld_safe with --skip-grant-tables command line option (with this option everybody can connect to your server so be careful). What output does the following statement produce: use mysql; select user,host from user where user='root'; You can restore your root password using such statement: set password for user 'root'@'your_host'=password('great password'); Than restart server as usual (without --skip-grant-tables). I am trying to change my root password for mysql 4.1.7 running on Linux (as I forgot it) using the docs found at: HYPERLINK http://dev.mysql.com/doc/mysql/en/Resetting_permissions.htmlhttp://dev.mys ql.com/doc/mysql/en/Resetting_permissions.html When I get to the step: shell mysqladmin -u root flush-privileges password newpwd I get the error: mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' think my user table is screwed up but how can I get in to fix it??? Worst case, do I just uninstall and reinstall mysql? Thanks, Don Don [EMAIL PROTECTED] wrote: -- 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]
How to change root password - getting error
Hi, I am trying to change my root password for mysql 4.1.7 running on Linux (as I forgot it) using the docs found at: HYPERLINK http://dev.mysql.com/doc/mysql/en/Resetting_permissions.htmlhttp://dev.mys ql.com/doc/mysql/en/Resetting_permissions.html When I get to the step: shell mysqladmin -u root flush-privileges password newpwd I get the error: mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' I think my user table is screwed up but how can I get in to fix it??? Worst case, do I just uninstall and reinstall mysql? Thanks, Don --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.822 / Virus Database: 560 - Release Date: 12/22/2004
how to change root password
Hi i have a simple question. how can i change mysql root password? if i change it using winmysqladmin.exe, and changing it in my.ini, nothing happens. i can change passwords using phpmyadmin, but i would like to change it without it. thanx M. - 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: how to change root password
From: [EMAIL PROTECTED] i have a simple question. how can i change mysql root password? if i change it using winmysqladmin.exe, and changing it in my.ini, nothing happens. i can change passwords using phpmyadmin, but i would like to change it without it. Do you have access to the MySQL default client? If so, log in and use the following: SET PASSWORD FOR user@host = PASSWORD('newpassword'); -- Mike Johnson . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://65.96.177.11 According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'. - 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: how to change root password
pornost4r, Wednesday, July 17, 2002, 4:45:18 PM, you wrote: p i have a simple question. how can i change mysql root password? if i p change it using winmysqladmin.exe, and changing it in my.ini, nothing p happens. i can change passwords using phpmyadmin, but i would like to p change it without it. Something like that: UPDATE TABLE user SET password=password('new_password') WHERE user='root' AND host='host'; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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