I found what I needed. I am pretty sure this happened because I failed
to set the password initially.
For others to reference, courtesy of Tom Krouper
A safer way to do this would be to add the "init-file=/tmp/grant.sql" to
the [mysqld] section of your my.cnf file. In /tmp/grant.sql you would
have...
SET PASSWORD FOR r...@localhost = PASSWORD('xxxx');
or whatever SQL that would fix the root user.
Restart MySQL and the password is reset. You can then remove
/tmp/grant.sql and remove the init-file line from your configuration.
Using the skip-grant-tables exposed your entire database to anyone or
any service that has access to your mysql instance. If you make sure
that the grant.sql file only is readable by the mysql daemon user, you
will have less exposure.
One more thing... instead of going to the mysql db to change the
password for a user, you can just type the following at the mysql prompt:
SET PASSWORD FOR n...@host = PASSWORD('xxxx');
I believe FLUSH PRIVILEGES is optional here, but I always run it out of
habit.
Maxwell Smart wrote:
> I have searched, but just can't seem to find what I'm looking for.
>
> Fresh install QMTISO 5.1.1 trying to login to mysql database with no
> success. Is there a default password? It shows password set NO, but I
> still cannot login.
>
> [r...@localhost ~]# mysql -u root
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
> [r...@localhost ~]#
>
> I know it's obvious can someone point it out.
>
> Thanks
>
>
--
Cecil Yother, Jr. "cj"
cj's
2318 Clement Ave
Alameda, CA 94501
tel 1.510.865.2787 | fax 1.510.864.7300
http://yother.com
---------------------------------------------------------------------------------
Qmailtoaster is sponsored by Vickers Consulting Group
(www.vickersconsulting.com)
Vickers Consulting Group offers Qmailtoaster support and installations.
If you need professional help with your setup, contact them today!
---------------------------------------------------------------------------------
Please visit qmailtoaster.com for the latest news, updates, and packages.
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
