Configuring MySQL to allow remote access

wildmanmatt

Verified User
Joined
Nov 2, 2009
Messages
23
Hi,

I'm having a bit of a problem setting MySQL to allow the da_admin user to access remotely (so that I can perform tasks using Navicat).

I login to MySQL through SSH and issue the following commands:

serv1:/usr/local/directadmin/conf# mysql -u da_admin -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.1.40-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> GRANT ALL ON *.* TO da_admin@'%' IDENTIFIED BY '(here I put my password that I used to login with the mysql -u da_admin -p command)';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 21
Current database: *** NONE ***

Query OK, 0 rows affected (0.00 sec)

mysql>

I'm not sure why I'm having this problem...Why would the connection being lost?

Help would be much appreciated.

Thanks,

Matt
 
I'm not sure why, but having stopped and started (not restarted) mysql it works now...

Thanks for the positive thoughts that (I'm sure) are the reason for that!

Matt
 
Back
Top