Hi Wybo,
On 8/20/2014 3:47 PM, Wybo wrote:
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27 --password=***** --user=wybo
I get:
ERROR 1045 (28000): Access denied for user 'wybo'@'wybo.fritz.box'
(using password: YES)
What am I doing wrong?
Access is granted only if three parts are correct:
1) the login you are using (wybo)
2) the password for the login
3) the host you are connecting from (wybo.fritz.box) is allows to use
that account.
It's #3 that most people forget about. Run this query
SELECT host FROM mysql.user WHERE user='wybo';
If you see a pattern in the results that would match your host's name,
then you need to compare your password hashes. If you don't know if you
have a matching host pattern, post the list of host patterns you got
from the query to the list. We can tell you.
Regards,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
