I've seen this behavior before with MySQL. The issue is that MySQL
uses not only your login name but also the hostname it sees you
logging in from. For instance in the MySQL user table there will
be entries like this:
name host password
---------------------------
root localhost 123abc
bob * 123abc
tom vixen 123abc
Based on the above root can only login from the localhost, bob can
login from anywhere, but tom can only login from host vixen. Make
sense?
So your issue is that mysql stored a hostname for user root when
mysql was setup. Debian uses localhost.localdomain for 127.0.0.1,
but for some reason MySQL only stores localhost in the user table.
Try changing localhost.localdomain to just localhost in /etc/hosts,
then try relogging into MySQL. You may have to reboot to make this
work (to reset hostname setup), I forget if just editing /etc/hosts
will make it work.
Good luck,
-Jim P.
Xavier Elizalde wrote:
I've been trying to set up MySQL and the book I've been using had
me set a password for the root user. However, I can't seem to log
into MySQL using that password now. Perhaps there was a typo when
I was entering it, but I can't seem to do anything about it now.
I've been searching for documentation on what to do, but all I can
find is documentation about windows, or documentation that just
isn't clear. Can I just uninstall MySQL and re-install it, and
just reset everything so I can start up from scratch again?
--To UNSUBSCRIBE, email to debian-user-
REQUEST@lists.debian.orgwith a subject of "unsubscribe". Trouble?
Contact listmaster@lists.debian.org