DrNick
December 11th, 2006, 12:48 PM
Hi all
I've been having problems connecting to my newly installed ubuntu server box with MySQL. I have not changed the default firewall rules (i.e. none), and I can connect to the machine's FTP, www and ssh services with no problems, which makes me think it is not a firewall issue.
I have performed all the usual post-installation steps, i.e. ran 'mysql_install_db' to initialise the grant tables using the mysql user. I have checked the permissions of the files in /var/lib/mysql/ to verify they are owned by the mysql user. I have verified the server is running (ps aux | grep mysqld). Lastly, I have created the appropriate root user for the workstation I wish to admin MySQL from, and followed the creation of this user with a 'FLUSH PRIVILEGES', just to be sure.
Displaying the contents of the mysql.user table reveals that the new user has definitely been created. (I have checked this by displaying the 'Host' column to verify that both the local and remote root accounts are there). Also DNS resolves the hostname to the IP address fine, (it can ping the host fine and also other services work with no problems using the hostname.)
I am trying to connect to the SQL server with the MySQL GUI tools from a Windows client, on the default port (3306), with my newly created root user. On attempting to connect, a MySQL error number 2003 appears, stating it cannot connect to the MySQL instance. Reading the error page for error 2003 has given me no joy.
Apologies for the rather lengthy post, but I wanted to include as much relevant information as possible. In summary, its not a firewall issue, its not a DNS issue, its not a permissions issue, its not because the server isn't running, and its not because the user accounts haven't been set up. So I've ran out of ideas... anything else anyone could suggest would be very much appreciated.
Cheers,
Tom Byrne
I've been having problems connecting to my newly installed ubuntu server box with MySQL. I have not changed the default firewall rules (i.e. none), and I can connect to the machine's FTP, www and ssh services with no problems, which makes me think it is not a firewall issue.
I have performed all the usual post-installation steps, i.e. ran 'mysql_install_db' to initialise the grant tables using the mysql user. I have checked the permissions of the files in /var/lib/mysql/ to verify they are owned by the mysql user. I have verified the server is running (ps aux | grep mysqld). Lastly, I have created the appropriate root user for the workstation I wish to admin MySQL from, and followed the creation of this user with a 'FLUSH PRIVILEGES', just to be sure.
Displaying the contents of the mysql.user table reveals that the new user has definitely been created. (I have checked this by displaying the 'Host' column to verify that both the local and remote root accounts are there). Also DNS resolves the hostname to the IP address fine, (it can ping the host fine and also other services work with no problems using the hostname.)
I am trying to connect to the SQL server with the MySQL GUI tools from a Windows client, on the default port (3306), with my newly created root user. On attempting to connect, a MySQL error number 2003 appears, stating it cannot connect to the MySQL instance. Reading the error page for error 2003 has given me no joy.
Apologies for the rather lengthy post, but I wanted to include as much relevant information as possible. In summary, its not a firewall issue, its not a DNS issue, its not a permissions issue, its not because the server isn't running, and its not because the user accounts haven't been set up. So I've ran out of ideas... anything else anyone could suggest would be very much appreciated.
Cheers,
Tom Byrne