Re: Root pass
On Wednesday, 3. July 2002 07:51, Page Works Web Solutions wrote:
Hi,
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql UPDATE user SET Password=PASSWORD(testpassword)
- WHERE User='root';
ERROR 1046: No Database Selected
mysql
1) select the database with use mysql before, or specify mysql.user as table
2) Quote testpassword: ... =password('testpassword')
Regards
Georg
-
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: Root pass
[admin admin]$ mysql mysql or once you have the mysql prompt type: use mysql then issue the command Curtis Page Works Web Solutions said: Hi, any ideas on this one [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql UPDATE user SET Password=PASSWORD(testpassword) - WHERE User='root'; ERROR 1046: No Database Selected mysql Shawn - 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 - 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
Root pass
Hi, any ideas on this one [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql UPDATE user SET Password=PASSWORD(testpassword) - WHERE User='root'; ERROR 1046: No Database Selected mysql Shawn - 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: Root pass
it's in the docs. use mysql; or update databasename.tablename ... - Original Message - From: Page Works Web Solutions [EMAIL PROTECTED] To: MySql mailing list (E-mail) [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 1:51 PM Subject: Root pass Hi, any ideas on this one [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql UPDATE user SET Password=PASSWORD(testpassword) - WHERE User='root'; ERROR 1046: No Database Selected mysql Shawn - 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 - 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
Root pass
Hi all, Yet another 3am night and I still can't get my MySql to work. I installed MySql on a cobalt Raq 4 server running Linux. I can telnet into the mysql directory, but can not seem to change the root pass. I've searched every place except the one that as the answer to my question. What am I doing wrong. Below is the session if you can help. [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 16 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql show databases - ; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.00 sec) mysql use test; Database changed mysql use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql bin/mysqld -Skip-grant - USE mysql; ERROR 1064: You have an error in your SQL syntax near 'bin/mysqld -Skip-grant USE mysql' at line 1 Thanks in advance for any help. :) Shawn - 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: Root pass
Hi Not sure here, but you have logged in as 'admin' on the system. Unless you su to root mysql will use the same user. try either [admin admin]$ su -l to log in to the system as root and then 'mysql -p' to log into mysql or stay as admin but log into mysql as root, under mysql [admin admin]$ mysql -u root -p The clue is in the line ERROR 1044: Access denied for user: '@localhost' to database 'mysql' which would read 'root@localhost' if you were logged in as root HTH, if not come back to me Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]] Sent: 30 June 2002 08:14 To: [EMAIL PROTECTED] Subject: Root pass Hi all, Yet another 3am night and I still can't get my MySql to work. I installed MySql on a cobalt Raq 4 server running Linux. I can telnet into the mysql directory, but can not seem to change the root pass. I've searched every place except the one that as the answer to my question. What am I doing wrong. Below is the session if you can help. [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 16 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql show databases - ; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.00 sec) mysql use test; Database changed mysql use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql bin/mysqld -Skip-grant - USE mysql; ERROR 1064: You have an error in your SQL syntax near 'bin/mysqld -Skip-grant USE mysql' at line 1 Thanks in advance for any help. :) Shawn - 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 - 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: Root pass
Hi shawn, You have probably have % in the user and host of the user table, so mysql client let you in without a username. To be able to use mysql database, you have to login as the root user. Just type, mysql -u root -p and see if you can login in that way. Besides, you have to restart mysqld from your unix shell prompt, you can't do it inside the mysql client .. I hope this helps, Gurhan - Original Message - From: Page Works Web Solutions [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 3:14 AM Subject: Root pass Hi all, Yet another 3am night and I still can't get my MySql to work. I installed MySql on a cobalt Raq 4 server running Linux. I can telnet into the mysql directory, but can not seem to change the root pass. I've searched every place except the one that as the answer to my question. What am I doing wrong. Below is the session if you can help. [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 16 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql show databases - ; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.00 sec) mysql use test; Database changed mysql use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql bin/mysqld -Skip-grant - USE mysql; ERROR 1064: You have an error in your SQL syntax near 'bin/mysqld -Skip-grant USE mysql' at line 1 Thanks in advance for any help. :) Shawn - 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 - 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: having trouble killing mysqld to restart and change root pass word
Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql Anyone know why I can't get the monitor started? If you have to forcibly terminate mysql, you might want to run some integrity checks to make sure nothing's broken. This -might- be hanging your mysql client. Shut the server down, run myisamchk /var/lib/mysql/*.MYI and then restart it and try reconnecting. NOTE: The actual check command may vary depending on the MySQL version. If you need to, use the kill -9 pid -9 is a definite kill and it will work I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? -- Michael Bacarella | 545 Eighth Ave #401 | New York, NY 10018 Systems Analysis Support | [EMAIL PROTECTED] Managed Services | 212 946-1038 - 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 - 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: having trouble killing mysqld to restart and change root pass word
Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql Anyone know why I can't get the monitor started? JP At 03:20 PM 2/6/2002 -0600, you wrote: If you need to, use the kill -9 pid -9 is a definite kill and it will work -Original Message- From: JP Audette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: having trouble killing mysqld to restart and change root password Howdy, I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? Thanks, JP - 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 - 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 - 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: having trouble killing mysqld to restart and change root pass word
Amendment to that last post I don't think the daemon is starting properly, because I can't run a mysqladmin version - I just get a hung cursor. Does anyone know if there's something that would be stopping mysqld from loading with the --skip-grant-tables option? When I do a ps I can see that it's definitely been started, but the fact that I can't do anything with mysqladmin makes me think that it hasn't loaded the way it needs to. JP Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql Anyone know why I can't get the monitor started? JP At 03:20 PM 2/6/2002 -0600, you wrote: If you need to, use the kill -9 pid -9 is a definite kill and it will work -Original Message- From: JP Audette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: having trouble killing mysqld to restart and change root password Howdy, I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? Thanks, JP - 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 - 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 - 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: having trouble killing mysqld to restart and change root pass word
Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql Anyone know why I can't get the monitor started? If you have to forcibly terminate mysql, you might want to run some integrity checks to make sure nothing's broken. This -might- be hanging your mysql client. Shut the server down, run myisamchk /var/lib/mysql/*.MYI and then restart it and try reconnecting. NOTE: The actual check command may vary depending on the MySQL version. If you need to, use the kill -9 pid -9 is a definite kill and it will work I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? -- Michael Bacarella | 545 Eighth Ave #401 | New York, NY 10018 Systems Analysis Support | [EMAIL PROTECTED] Managed Services | 212 946-1038 - 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
