MySQL Forums
Forum List  »  MySQL Administrator

Re: ERROR 1045 (28000): Access denied for user 'root'@'::ffff:' (using password: YES)
Posted by: Barry Galbraith
Date: August 20, 2009 09:54PM

Here's what I get on my server. Notice both ip address, and host name.

mysql> select user,host from user;
| user | host |
| root | |
| root | localhost |
2 rows in set (0.06 sec)

Can you add your user to mysql using the hostname, as well as the ip address?

The reference manual shows adding users using the host.domain rather than ip address.

Good Luck.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.