Here is a short and easy to use guide on how to enable MySQL access to your WHM / Cpanel hosting server.  Under WHM, you might have come across something called: "Setup Remote MySQL server".  Too bad that is not what you want.  You want to be able to access MySQL from your home desktop with something like SQLyog.  So lets get to it.

1. SSH to your box, login as root and type in your password.  (Don't know what to use?  google putty.exe)
2. Type: pico /etc/my.cnf
3. You will see a bunch of lines of code, but pay special attention to "skip-networking".
4. Change that to: #skip-networking
5. Press ctrl+x and save as the same filename and press Y to exit.
   
6. Log into WHM, and restart the MySQL service.
   

Now you have to enable your home IP for database access for a particular user.  Log into cpanel with the domain that contains the database you want to remotely connect to:

1. Jump down to "Databases" and select "Remote MySQL"
2. Now add your IP address, or IP range with a wildcard such as 24.50.%

Now load up SQLyog, fill out the connect details and click "Test Connection".  Success?  Now enjoy a life free of phpMyAdmin.
 

Similar Blogs:
Optimum Online Ultra Review
Benefits Of Gzip Compression
PHP: How To Fix "Class 'ZipArchive' Not Found"

blog comments powered by Disqus

OLD Comments (1)

Copyright 2010 Brant Tedeschi.