Login MYSQL Server computer by 'SSH Secure Shell Client'
ssh username@ip
   Example: ssh a@192.168.1.96
Enter pc password
Login MYSQL Server  mysql -u[username] -p[password]
   Example: mysql -uroot -pabcd ;
Set bind-address   = 0.0.0.0 on my.cnf for access any computerEdit mysql my.cnf
   $ nano /etc/mysql/my.cnf
   Set bind-address   = 0.0.0.0 
Save my.cnf file and exit.  
Check '%' Host and 'root' User on user table
    mysql>  SELECT * FROM mysql.user WHERE HOST='%' AND User='root';
If '%' Host and 'root' User do not exist on user table. Execute below sql query    Mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'mysql_password'  WITH GRANT OPTION
     Example: GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY ‘abcd’ WITH GRANT OPTION
Logout from mysql server
    
mysql> exit; 
Restart MySql server:
   $ sudo/etc/init.d/mysql restart
To Check remote to remote enable
   mysql -u[root] -p[password] -h[mysql_serverip]
   Example; mysql -uroot -pabcd -h192.168.1.96
 
No comments:
Post a Comment