By default all users are only allowed to connect from localhost, i.e. the same computer where mysql is installed. A soultion could be to log in through localhost and change the user to be allowed to login from all/specific domains
if you want to allow a user called 'myuser' to connect from any host with the password 'mypassword' :
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
if you want to allow a user called 'myuser' to connect from your computer with the password 'mypassword' :
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'MyComputerIPAddress' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
|