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
