Need help with Mysql without cpanel?

Discussion in 'MySQL' started by kingofbigmac, Sep 15, 2007.

0
  1. #1
    My friend who is hosting me just canceled his server and for some reason its halfway through the month and my sites are still up and everything. I can access ftp but now I can't login to cpanel. I need add some tables and what not to mysql. What should I do about this? Perhaps go to a new host and use there cpanel. I would like to see how long I can be on a server without paying for it you know. Thanks

    King
     
    kingofbigmac, Sep 15, 2007 IP
  2. krt

    krt Well-Known Member

    Messages:
    829
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    120
    #2
    You can download a copy of phpMyAdmin and install that on your site if your host supports PHP.
     
    krt, Sep 16, 2007 IP
  3. kingofbigmac

    kingofbigmac Banned

    Messages:
    446
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #3
    can I install without inputing a database username and pass
     
    kingofbigmac, Sep 16, 2007 IP
  4. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #4
    You will have to input:

    1) database name
    2) username
    3) password

    in a file config.inc.php
     
    Kuldeep1952, Sep 16, 2007 IP
  5. tandac

    tandac Active Member

    Messages:
    337
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    #5
    You probably want to back up your database and site before anything bad happens. :)

    If you can SSH, then the following command would of value:
    mysqldump -u username databaseName -p > dump.sql

    To create tables or anything else sql related you want to use the mysql command:
    mysql -u username database -p
    From the mysql prompt you can create a table:
    create table...
     
    tandac, Sep 16, 2007 IP