Re: Using password: _No_
Hi,
After a couple helpful answers to my post, I realized I wasn't going
crazy, but that the root probably had a password and I just didn't know
it. Found this documentation which wasn't very clear except for the
comments at the bottom of the page.
http://www.mysql.com/doc/R/e/Resetting_permissions.html
1. /usr/local/mysql/bin/safe_mysqld --skip-grant-tables
2. /usr/local/mysql
3. use mysql;
4. update user set password = password('...') where user = 'root'
and host='localhost';
5. Stop and Start the MySQL server.
Thanks very much for the help.
Abdulhakeem wrote:
No you don't have to re-install.You should use this command to start the
mysql server;
etc/init.d/mysqld start
Then use this command to connect to the server
mysql
However if you are logged in as a different user other than root you must
specfy your user name,host name and password by using the following command
mysql -h localhost -u user -p mypass
I hope this helps,please let me know as i am new to mysql too(1 week)
--
Atoyebi Abdulhakeem (MCSE)
[EMAIL PROTECTED] www.artsinscience.com
-Original Message-
From: Cliff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 4:18 AM
To: [EMAIL PROTECTED]
Subject: Using password: _No_
Hello,
Can anyone help?
When trying to run mysql I get an ERROR 1045: Access denied for user:
'root@localhost' (Using password: No).
In the documentation it mentions 'Using password: YES'. Have tried
starting mysql with --skip-grant-tables and then mysqladmin
flush-privileges which doesn't seem to do anything.
What does the Password No mean? How do I correct it short of
reinstallation? Well, I don't know maybe I need to start over yet
again.
Thanks very much for any help,
Cliff
-
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: Using password: _No_
what command are you issuing. is it mysql? If so, what arguments are you sending it? It should look like this mysql -u user -p prompt: password -Original Message- From: Cliff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 9:18 PM To: [EMAIL PROTECTED] Subject: Using password: _No_ Hello, Can anyone help? When trying to run mysql I get an ERROR 1045: Access denied for user: 'root@localhost' (Using password: No). In the documentation it mentions 'Using password: YES'. Have tried starting mysql with --skip-grant-tables and then mysqladmin flush-privileges which doesn't seem to do anything. What does the Password No mean? How do I correct it short of reinstallation? Well, I don't know maybe I need to start over yet again. Thanks very much for any help, Cliff - 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: Using password: _No_
Thanks. This works when I use any other user besides root without a password. Guess the problem is that there is a password for root and I don't know what it is. Thanks again for getting me over the first mindless hurtle. Regards, Cliff Austin Brian P. Austin wrote: what command are you issuing. is it mysql? If so, what arguments are you sending it? It should look like this mysql -u user -p prompt: password -Original Message- From: Cliff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 9:18 PM To: [EMAIL PROTECTED] Subject: Using password: _No_ Hello, Can anyone help? When trying to run mysql I get an ERROR 1045: Access denied for user: 'root@localhost' (Using password: No). In the documentation it mentions 'Using password: YES'. Have tried starting mysql with --skip-grant-tables and then mysqladmin flush-privileges which doesn't seem to do anything. What does the Password No mean? How do I correct it short of reinstallation? Well, I don't know maybe I need to start over yet again. Thanks very much for any help, Cliff - 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
