How to Access CPanel MySql DB in other Host

Question

I have a Host enayam.in (linux) i have mysql db in this Host.

Actually i have to access it on my Localhost(With WAMP or MAMP)

if the Database in localhost(WAMP or MAMP) then i can connect my DB like this

mysql_connect('localhost', 'root', 'root');
mysql_select_db('testDB');

now i try to access my enayam.in DB in my localhost(WAMP or MAMP)

mysql_connect('enayam.in', 'enayamin_dbuser', 'enayamin_dbpassword');
mysql_select_db('enayamin_testDB');

but its giving error, i also try with my server IP as host (75.126.136.20)

mysql_connect('75.126.136.20', 'enayamin_dbuser', 'enayamin_dbpassword');
mysql_select_db('enayamin_testDB');

eventhough its giving error. please help me to solve this issue.

Thanks in advance

What is the error? Have you added your own IP address in trsuted IPs in cPanel of your host? ( IPs which can connect to your DB remotely ) — Sgn.
– Sgn., Commented Nov 27, 2011 at 12:30

Meisam Mulla · Accepted Answer · 2011-11-28 14:32:46Z

2

cPanel > Remote MySQL > Add your IP address. Use % as a wildcard ex. 64.65.54.%

answered Nov 28, 2011 at 14:32

Meisam Mulla

1,8713 gold badges23 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

I am using MAMP on Mac OS X. What would be my I.P? Sorry for late Reply!

Use the ip address of the machine you are trying to connect from. To find out what your ip address is go to www.whatismyip.com.

Manigandan Arjunan · Accepted Answer · 2011-12-08 13:29:25Z

1

To access a database from the local system, the remote access for your db has to be enabled in your server.

answered Dec 8, 2011 at 13:29

2,2651 gold badge25 silver badges43 bronze badges