The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL data

Discussion in 'Database Discussions' started by canivan, Aug 31, 2009.

  1. canivan

    canivan Registered

    Joined:
    Aug 31, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    How is a MySQL data file set up on cpanel?
    What is a localhost?
    Thank you
    John
     
  2. Janak

    Janak Well-Known Member

    Joined:
    Jul 18, 2009
    Messages:
    71
    Likes Received:
    1
    Trophy Points:
    6
    If the mySQL server is on the same server as your domain, you need to use localhost (server application running on your own computer)to connect mysql database.

    If you wish to restore mysql backup file (.sql) then you can restore it via phpmyadmin (cPanel option) directly. Before restoring, you should created MySQL database from cPanel -> MySQL Databases.
     
  3. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    You can create database and database users from Cpanel

    Managing your databases can be done from phpMyAdmin which should
    also be listed on your Cpanel control panel.

    Localhost is a special name that basically means "THIS COMPUTER"

    The same goes for the numeric IP address "127.0.0.1"

    Those are special loopback names that refer to the computer where
    you are running the program being executed.

    Thus if you configure a program to connect to MySQL at 'localhost' then
    you are telling the program that you want to connect to the MySQL database
    server that is running on the same server machine as the program running.
     
Loading...

Share This Page