Search This Blog

Thursday, March 14, 2013

Basic setup for allowing remote login in mysql

1. check sudo mysqladmin variables | grep socket
2. check sudo mysqladmin variables | grep port
3. vi /etc/my.cnf ( make sure bind-address is local address)
4. sudo vi /etc/init.d/mysql restart

5. grant access to any host


No comments:

Post a Comment