I have tried everything that I know to set the root password but I keep
getting denied. I finally got the daemon running so now I need to set the
root password. I have not yet set a pw so I can not understand why I am
getting denied. I looked at the manual online and it gave the following
suggestions:
If you get an error like the following:
shell> mysqladmin -u root -pxxxx ver
Access denied for user: 'root@localhost' (Using password: YES)
It means that you are using a wrong password. See section 6.15 Setting Up
Passwords. If you have forgot the root password, you can restart mysqld
with --skip-grant-tables to change the password. You can find more about
this option later on in this manual section. If you get the above error
even if you haven't specified a password, this means that you a wrong
password in some my.ini file. See section 4.16.5 Option Files. You can
avoid using option files with the --no-defaults option, as follows:
shell> mysqladmin --no-defaults -u root ver
This is the exact error I am getting and I have searched for my.cnf,
my.conf, ~/.my.cnf , and $DATADIR/my.cnf file to no avail. I have tried
putting --no-defaults with the password reset statement as shown below:
/mysqladmin --no-defaults -u root -p password new-password
One question I have about that statement though, How can I put a password
if there is not one. Anyway, any help provided would be greatly
appreciated. Thanks in advance.
Mike
Matthew 4:18-20
(18) And walking by the Sea of Galilee, Jesus saw two brothers, Simon
called Peter, and Andrew his brother, casting a net into the sea. For they
were fishermen.
(19) And He said to them, Follow Me, and I will make you fishers of men.
(20) And they immediately left their nets and followed him.
---------------------------------------------------------------------
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
