I've got a 3 servers & 1 Windows machine running in a LAN
HTTP server (Apache2, PHP5 & phpmyadmin) - 10.0.0.10 DNS - 10.0.0.1 MySQL - 10.0.0.40 Windows - 10.0.0.157
I've just installed a fresh copy of mysql on the mysql server. I've commented the bind-address out first off. I've given privileges by doing the following.
CREATE USER 'https'@'localuser' IDENTIFIED BY 'password'; CREATE USER 'https'@'10.0.0.10' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'https'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'https'@'10.0.0.10';
However every time I try to connect to mysql via the http server the following happens
mysql -u https -p enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'var/run/mysqld/mysqld.sock'(2)
When I try
mysql -h 10.0.0.40 -P 3306 -u https -p
I get a different error
ERROR 1045 (28000): Access denied for user 'https'@'10.0.0.10' (Using password: Yes)`
I'm not sure why this is happening as far as I'm aware, I've done everything I need to configure? :(
In my mysql table for users I have the following
user | host https % https 10.0.0.10 sqlserver 127.0.0.1 sqlserver ::1 debian-sys-maint localhost https localhost sqlserver localhost sqlserver raspberrypi
Can someone point me in the right direction please? I've searched around and everything I see just points towards commenting the bind address line out.
Edit I can't even log in using locally using any user apart from
sqlserver which was the root account that has been renamed. I've tried adding new accounts and logging in as them locally, still the same issue!