Just fired up the LAMP Stack - Web Stack (MySQL) provided by TurnKey Linux instance and can't connect to the MySQL database from my ofice using MySQLWorkbench. I want it open to all remote connections.

I opened up the port 3306 in the security group. Am i missing somethign>

Jeremy Davis's picture

So not only do you need to open the port in the security group you also need to configure MySQL to listen for external connections. Have a look here in the docs.

MYSQL_BATCH="mysql --user=root --password=$MYSQL_PASS --batch"
$MYSQL_BATCH --execute "INSERT INTO mysql.user ( Host , User , Password , Select_priv ,
    Insert_priv , Update_priv , Delete_priv , Create_priv , Drop_priv , Reload_priv , 
    Shutdown_priv , Process_priv , File_priv , Grant_priv , References_priv , 
    Index_priv , Alter_priv , Show_db_priv , Super_priv , Create_tmp_table_priv , 
    Lock_tables_priv , Execute_priv , Repl_slave_priv , Repl_client_priv , 
    Create_view_priv , Show_view_priv , Create_routine_priv , Alter_routine_priv , 
    Create_user_priv , ssl_type , max_questions , max_updates , max_connections , 
    max_user_connections) VALUES ( '%', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
    'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y','Y', 'Y', 'Y', 'Y', 'Y',
    'Y', 'Y', 'Y', 'Y', '', '0', '0', '0', '0');"




Geoff Chadwick's picture

Hi Guys,

I have set up mysql database on a spare pc and it is running just fine, but now and again we can't do a remote login so we reboot the machine all works fine again for a couple of days and the same thing happens.  Do we need to add the above code to our mysql, will this fix the problem, apart from this it works great no other problems.

Jeremy Davis's picture

Regardless, I suggest that you log in via SSH to check that MySQL is still running and listening for remote connections. It would also be worth checking the logs. OTTOMH they should be in /var/log/mysql or something similar.

FWIW, in my experience, the most common cause of a MySQL crash that is "resolved" temporarily by a reboot, is running out of RAM. Probably something worth investigating...

Add new comment