cannot connect to Msql data base

Question

i cannot seem to create a connection to Mysql database from the following code. Can you please let me know if there is anything missing from this code. Since i have not used php code much i might have missed out something.

on submitting code im getting the following error Warning: mysql_connect() [function.mysql-connect]: Host '31.170.160.80' is not allowed to connect to this MySQL server in /home/a5847996/public_html/check_db.php on line 15

here is the code im using

<body>
    <?php
     $server   = "-";
     $database = "-";
     $username = "-";
     $password = "**************";

     $mysqlConnection = mysql_connect($server, $username, $password);
      if (!$mysqlConnection)
      {
       echo "Please try later.";
      }
      else
      {
       mysql_select_db($database, $mysqlConnection);
      }
   ?>
    </body>

the mysql server is configured to only be accessable from the server itself — Joel Harkes, May 01 '13 at 07:15
you should use `PDO` or `mysqli` instead of the `mysql_*` extensions, they're deprecated. — doublesharp, May 01 '13 at 07:21
The error basically tells you exactly what is wrong. Your webserver is not allowed to connect to the database server. You should contact your hoster. — nvanesch, May 01 '13 at 07:16
...and double check mysql server name so you're connecting to the correct server/host name. — Joachim Isaksson, May 01 '13 at 07:16

score 2 · Answer 1 · answered May 01 '13 at 07:19

2

Go to your MySQL Prompt and issue this command.

$ mysql -u root -p
Enter password:

mysql> use mysql

mysql> GRANT ALL ON *.* to root@'31.170.160.80' IDENTIFIED BY 'your-root-password'; 

mysql> FLUSH PRIVILEGES;

Don't forget to assign your parameters !

answered May 01 '13 at 07:19

Shankar Narayana Damodaran

68,075
43
96
126

im not sure if i understand the purpose of this code. might need a little explanantion. – user2271972 May 01 '13 at 07:29
you are just "granting the privileges to your host". Try it and let us know. – Shankar Narayana Damodaran May 01 '13 at 07:31
im getting "access denied" message when i try this – user2271972 May 01 '13 at 07:44
SQL query: USE mysql MySQL said: #1044 - Access denied for user 'a5847996_admin'@'localhost' to database 'mysql' – user2271972 May 01 '13 at 07:44
You need to execute the first statement in the terminal and the last 3 at mysql prompts. Check this link http://stackoverflow.com/questions/8838777/error-1044-42000-access-denied-for-user-localhost-to-database-db – Shankar Narayana Damodaran May 01 '13 at 08:13

cannot connect to Msql data base

here is the code im using

1 Answers1