my favorite

2010/02/17

Enable Mysql Remote Access (ubuntu)

step 1 : Edit /etc/mysql/my.cnf to comment bind-address = 127.0.0.1
# bind-address - 127.0.0.1

step 2 : Create a new user for remote accessing
mysql> CREATE USER 'your_account'@'%' IDENTIFIED BY 'your_password'

step 3 :
mysql>GRANT ALL PRIVILEGES ON *.* TO 'your_account'@'%'  WITH GRANT OPTION;

step 4 : Restart mysql service

mysqladmin -u root -p shutdown
sudo mysqld_safe -u root



DONE

No comments:

BIO

Taipei, GuTing, Taiwan

huang47 | personal

huang47 | personal