Connecting to MySQL database hosted on remote server

Question

Recently i have purchased a domain "domain.com". The hosting company has the usual CPanel to handle databases.

Using the "MySQL Databases" I:

Created a database with the name "database1"
Created a user with the username "user1" and password "pass1"
Added user "user1" to the database "database1"

So far so good.

After that i clicked on PHPMyAdmin and redirected to the PHPMyAdmin webpage. There i see the "database1" that i have previously created. Clicking on that database, i used IMPORT to import a very simple table named "test" [columns (id,name,surname)]. Importing the table created table "test" below the database "database1", which is correct.

After that i have tried to connect to that database using the code below (connect_to_db.php):

// Create connection
$con=mysqli_connect("domain.com","user1","pass1","database1");

// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error() ."<br>";
}

I have uploaded the connect_to_db.php into the /home/domain/public_html/.

When i try to connect to the database1 i get the following error:

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'user1'@'xxx.xxx.xxx.xxx' (using password: YES) in /home/karkoona/public_html/connect_to_db.php on line 13

Where xxx.xxx.xxx.xxx is the public IP of domain.com (if i get it right).

Also on the right of landing page of PHPMyAdmin i see:

user: domain@localhost

Any idea why i cannot access the database with the current user? Is there any mistake in my code?

Thanks.

user1 does not have right to access that database.so use root user to give the privileges to user1 — krishna
– krishna, Commented Feb 18, 2014 at 10:01
your hosting provider may have document along with sample connection ... check it — user1844933
– user1844933, Commented Feb 18, 2014 at 10:03
When creating the users, you have to create them with the correct "Host" field: Start with username "user1", host "%", password "whatever" and work your way up — Eugen Rieck
– Eugen Rieck, Commented Feb 18, 2014 at 10:05
@christostsang check the 2nd part of my answer about cPanel. — Prix
– Prix, Commented Feb 18, 2014 at 10:09

Prix · Accepted Answer · 2014-02-18 10:05:02Z

1

You need to grant access to user1 using it's IP to access the remote server:

GRANT ALL PRIVILEGES ON database1.* to 'user1'@'xxx.xxx.xxx.xxx' IDENTIFIED BY 'pass1';

NOTE: replace the relevant info to the current info such as xxx.xxx.xxx.xxx to the current server IP that will access the remote MySQL.

Since you're using cPanel you can do this to allow the IP:

Login to your cPanel (if not already logged in).
Scroll down to the Databases section.
Click on the Remote MySQL icon.
Enter the IP address of the computer that will be making the remote connection.
Click the Add Host button.

answered Feb 18, 2014 at 10:05

Prix

19.6k16 gold badges79 silver badges136 bronze badges

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

1 Comment

christostsang Over a year ago

Adding the IP address into the Remote Database Access host did the trick! To be honest i have tried it before but i used the domain.com instead of the IP and it didnt saved it. Thanks a lot!

Prasanth Bendra · Accepted Answer · 2014-02-18 10:03:26Z

0

It may be beacuse :

1) User name or password you are using is wrong
2) User may not have privillage to access the database

answered Feb 18, 2014 at 10:03

Prasanth Bendra

33.1k9 gold badges56 silver badges74 bronze badges

Comments

wild · Accepted Answer · 2014-02-18 10:05:31Z

0

you are not pass $con in connection check

 if (mysqli_connect_errno())

replace it with

if (mysqli_connect_errno($con))

answered Feb 18, 2014 at 10:05

wild

3401 gold badge3 silver badges14 bronze badges

Comments

Tunaki · Accepted Answer · 2016-03-27 14:58:29Z

0

All you need to do is to add your server IP address to Remote Database Access Hosts in cpanel. It will allow access to your database and the same method is used to allow access when you are using localhost. But all you have to do is to add your computer IP address into remote database.

edited Mar 27, 2016 at 14:58

Tunaki

138k46 gold badges370 silver badges443 bronze badges

answered Mar 27, 2016 at 14:57

saoud panezai

1

Collectives™ on Stack Overflow

Connecting to MySQL database hosted on remote server

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related