GRANT ALL PRIVILEGES ON *.* TO root@’hostname’
IDENTIFIED BY ‘root-password’

 

 

Also remember if u using Ubuntu then in /etc/mysql/my.cnf file remove or comment the bind_address property.

Advertisements