Having Trouble Connecting to MySQL Database

Question

The following code successfully connects me to my mySQL database.

$conn = mysql_connect("localhost", "root", "") or die("Failed to Connect!");
$db = mysql_select_db("MyDB");

I have been experimenting on localhost using XAMPP and phpmyadmin, and everything works correctly. However, today I uploaded my website to my domain (I have bought a domain and web hosting through GoDaddy) and I keep getting "Failed to Connect!" whenever this code runs. The HTML/CSS work correctly, but I cannot connect to mySQL. How can I connect to my database on the server?

Are you using the correct authentication information? If you don't know, this question would be better vetted through GoDaddy's technical support staff. — SomeShinyObject, Jan 08 '14 at 02:30
It seems you better ask Godaddy support as it seems the problem comes from database server. — , Jan 08 '14 at 07:35

score 1 · Accepted Answer · answered Jan 08 '14 at 02:30

1

You'll need to change your connection information here:

mysql_connect("localhost", "root", "")

to include your GoDaddy database details instead. Contact GoDaddy for more information on what to use for your account.

answered Jan 08 '14 at 02:30

jakab

26
1

score 0 · Answer 2 · answered Jan 08 '14 at 02:37

0

You have not mentioned anything about MySQL database hosting. If you are hosting the database also in godaddy, you should be able to get the connection string and host name from information mentioned here

answered Jan 08 '14 at 02:37

raj

819
5
9

score 0 · Answer 3 · answered Jan 08 '14 at 03:08

First, You need to create database in your hosting server (phpmyadmin cpanel) and supply details in your database connect file.

**Looking at your database credentials I can say that you haven't created one yet since
the username is definitely not 'root' and password will be required.**

Sample db_connect file:

    <?php
    $hostname = 'e.g: internal-ra.db-server-123';
    $username = 'e.g: serverone1234d4';
    $password = 'e.g: your_own_password';

    try {
        $pdo = new PDO("mysql:host=$hostname;dbname=database_name_here", $username, $password);
        /*** echo a message saying we have connected ***/
        }
    catch(PDOException $e){
        echo 'Exception -> ';
        var_dump($e->getMessage());
        }
    ?>

score 0 · Answer 4 · answered Jan 08 '14 at 03:52

0

And try to use so less as possible the key DIE()

answered Jan 08 '14 at 03:52

Donny van V

921
1
10
22

Having Trouble Connecting to MySQL Database

4 Answers4