Configuring MySQL to allow remote access

[wildmanmatt]

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

 

[wildmanmatt]

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