mysql database cannot connect with cpanel

Question

i have mysql database over cpanel, i want to access through my localhost page..

<?php
$con1 = mysql_connect("mywebsiteip","mysql_username","mysql_user_password");
if(!$con1)
{
    die ("Could not connect " . mysql_error());
}
else
{
    echo "Good connection";
}
mysql_close($con1);
?>

When i run it, it cannot connect to mysql database over cpanel. and i even tried up

$con1 = mysql_connect("mywebsiteip:portnumber","mysql_username","mysql_user_password");

Can any let me know, which one is good way. Below is the image or error enter image description here

@Alfred Yes!, i tried with localhost, its not working.. If i use localhost then it will take users localhost database system — Rafee
– Rafee, Commented Nov 18, 2011 at 12:14
@Bjoern Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: No such host is known Warning: mysql_connect() [function.mysql-connect]: [2002] php_network_getaddresses: getaddrinfo failed: No such host is kn (trying to connect via tcp://mywebsiteip:myportnumber) Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: No such host is known Could not connect php_network_getaddresses: getaddrinfo failed: No such host is known and it only in the connection string line 2 error — Rafee
– Rafee, Commented Nov 18, 2011 at 12:16
In that case, don't localhost, but a proper ip address where your mysql server is accessable. — Bjoern
– Bjoern, Commented Nov 18, 2011 at 12:44

Adam Hopkinson · Accepted Answer · 2011-11-18 12:10:59Z

2

By default, cPanel-installed mysql databases only allow connections from the localhost (ie the server cpanel/mysql is installed on). To add other hosts, log in to cPanel and go to 'Remote Database Access Hosts' (this may be called something slightly different depending on version).

You can add your IP address, hostname or % to allow connections from any computer. However, specifying % is a big security risk, so use it with caution.

FYI, this question really belongs on webmasters.stackexchange.com, as it involves administration more than programming.

answered Nov 18, 2011 at 12:10

Adam Hopkinson

28.8k9 gold badges74 silver badges105 bronze badges

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

1 Comment

Rafee Over a year ago

if i add my ipaddress in there, can i able to access from other computers over internet.

Ryan Oscar · Accepted Answer · 2018-04-06 06:43:23Z

1

You should give the correct connection code!

$con1 = mysql_connect("localhost:/tmp/mysql.sock","mysql_username","mysql_user_password");

I hope this should / must work for you. Enjoy!

edited Apr 6, 2018 at 6:43

Ryan Oscar

2791 gold badge5 silver badges20 bronze badges

answered Nov 18, 2011 at 13:43

uzair

7761 gold badge13 silver badges25 bronze badges

Comments

Bjoern · Accepted Answer · 2011-11-18 12:48:05Z

1

Warning: mysql_connect() [function.mysql-connect]: 
php_network_getaddresses: getaddrinfo failed: No such host is known

This error messages suggests that localhost can't be resolved, therefore the "client" (your php script) doesn't know where to send the connect request to.

Either check your DNS settings or use an IP adress instead, where your MySQL server is accessible.

answered Nov 18, 2011 at 12:48

Bjoern

16.3k4 gold badges47 silver badges50 bronze badges

2 Comments

Rafee Over a year ago

where can we get the ip address of mysql server, is it same as cpanel Shared IP Address

Bjoern Over a year ago

usually your webspace provider gives you those details.

Utku Yıldırım · Accepted Answer · 2011-11-18 12:26:35Z

0

if your trying to connect remote ip

Mysql server need to accept remote connection
Mysql user need to have remote access previlage

if you dont have 1 of them it wont work.

answered Nov 18, 2011 at 12:26

Utku Yıldırım

2,27716 silver badges20 bronze badges

Collectives™ on Stack Overflow

mysql database cannot connect with cpanel

4 Answers 4

1 Comment

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related