Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hey,

I think MySQL is not configured to listen for remote connections follow the below steps :

1 .Configure MySQL to listen for remote connections:

sed -i "s/^bind-address/#bind-address/" /etc/mysql/my.cnf

  1. Configure MySQL to accept remote root connections (from any host ('%')):

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');"

  1. Restart MySQL for the changes to take effect:

/etc/init.d/mysql restart

hopefully this will solve your problem .

Hey,

I think MySQL is not configured to listen for remote connections follow the below steps :

1 .Configure Configure MySQL to listen for remote connections:

sed -i "s/^bind-address/#bind-address/" /etc/mysql/my.cnf

  1. 2 Configure MySQL to accept remote root connections (from any host ('%')):

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');"

  1. 3 Restart MySQL for the changes to take effect:

/etc/init.d/mysql restart

hopefully this will solve your problem .

Hey,

I think MySQL is not configured to listen for remote connections follow the below steps :

1 Configure MySQL to listen for remote connections:

 sed -i "s/^bind-address/#bind-address/" /etc/mysql/my.cnf

/etc/mysql/my.cnf

2 Configure MySQL to accept remote root connections (from any host ('%')):

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');"

'0');"

3 Restart MySQL for the changes to take effect:

/etc/init.d/mysql restart

restart

hopefully this will solve your problem .