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-mysql/
-
Get Site Info
You can recover MySQL database server password with following five easy steps. Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt...
www.cyberciti.biz/tips/recover-mysql-root-password.html
-
Get Site Info
Get Site Info