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_
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
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
