$ mysql -u root -p Enter password: mysql> use mysql mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password'; mysql> FLUSH PRIVILEGES;
if i want all ipaddress can access to DB Server
mysql> GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'your-root-password'