India seo web development website designer freelance Creating a database connection

The final step of the setup process is to create a connection to the database.

To create a database connection in :

  1. Open any PHP page in and then open the Databases panel (Window > Databases).
  2. Click the Plus (+) button on the panel and select MySQL Connection from the pop-up menu.

    The MySQL Connection dialog box appears,

  3. Enter connTrio as the connection name.
  4. In the MySQL Server text box, specify the computer hosting MySQL.

    Enter an IP address or a server name. If MySQL is running on the same computer as , enter localhost .

  5. Enter your MySQL user name and password.

    If you didn't define a user name while configuring your MySQL installation, enter root in the Username text box. If you don't have a password, leave the Password text box blank.

  6. In the Database text box, enter TrioMotors , or click Select and select TrioMotors from the list of MySQL databases.

    TrioMotors is the name of the sample MySQL database you created

  7. Click Test.

    attempts to connect to the database. If the connection fails, do the following:

  8. Click OK.

    The new connection appears in the Databases panel.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100

India web developer website development India