By default, MySQL database server remote access disabled for security reasons. However, some time you need to provide the remote access to database server from home or from web server. Step # 1: Login over ssh if server is outside your IDC...More
By default, MySQL database server remote access disabled for security reasons. However, some time you need to provide the remote access to database server from home or from web server. Step # 1: Login over ssh if server is outside your IDC First, login over ssh to remote MySQL database server Step # 2: Enable networking Once connected you need edit the mysql configuration file my.cfg using text editor such as vi. If you are using Debian Linux file is located at /etc/mysql/my.cnf locationIf you are using Red Hat Linux/Fedora Linux file is located at /etc/my.cnf locationIf you are using ...
Very quickly, another thing that I typically like to do on my server boxes is allow root access to my Mysql database from remote computers. I don’t forward
www.benrobb.com/2007/01/15/howto-remote-root-access-to-m<br/>ysql/
-
Get Site Info
Q. How do I change MySQL root password under Linux, FreeBSD, OpenBSD and UNIX like operating system over ssh / telnet session? A. Setting up mysql password is one of the essential tasks. root user is MySQL admin account. Remember Linux / UN...
www.cyberciti.biz/faq/mysql-change-root-password/
-
Get Site Info
Get Site Info