Friday, November 05, 2010

Remote MySQL Access

GRANT ALL ON *.* TO root@192.168.1.1   IDENTIFIED BY 'palavra-pass'   WITH GRANT OPTION;
FLUSH PRIVILEGES;
We just have to tell Mysql to allow remote logins.
sudo vi /etc/mysql/my.cnf
Out-of-the-box, MySQL only allows connections from the localhost identified by the IP Address of 127.0.0.1.
We need to remove that restriction, so find the line that says
bind-address = 127.0.0.1


netstat -tupan | grep mysql

No comments:

Post a Comment

xfce4-screenshooter keyboard shortcut

sh -c 'xfce4-screenshooter --fullscreen --save "$HOME/Pictures/Screenshots/Screenshot_$(date +%Y-%m-%d_%H:%M:%S).png"' s...