MySQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tiffany Roxxx
    Registered User
    • Aug 2003
    • 87

    #1

    MySQL

    I'm trying to install a MySQL db, its there, shows as being installed...but I cant get to it lol.
    it says "You can use phpMyAdmin to administrate your MySQL databases in a web based environment. "
    when I click the link "phpMyAdmin" it tells me "You are logged in with the root, or reseller's password" (Im logged into the control pannel...Im not sure what it means by resellers password...maybe I dont have the proper password to access the db? but it let me install the db...)

    Im a bit lost...never used this and needed to install it for a script
    any Ideas?
  • NaughtyRob
    Two fresh affiliate progs
    • Nov 2004
    • 29602

    #2
    You need to ask your host.
    [email protected]
    Skype: 17026955414
    Vacares Web Hosting - Protect Your Ass with Included Daily Backups

    Comment

    • ytcracker
      stc is the greatest
      • Dec 2002
      • 12403

      #3
      im sorry but youre pretty
      www.ytcracker.com | www.digitalgangster.com
      i love you

      Comment

      • Tiffany Roxxx
        Registered User
        • Aug 2003
        • 87

        #4
        Thanks, I kinda figure'd its not soemthing I could change, tried a few things with no luck, I'll ask my host in the morning

        ty ytcracker

        Comment

        • calmlikeabomb
          Confirmed User
          • May 2004
          • 1323

          #5
          Login to your server via ssh. Change directories to where mysql is installed and login to the mysql server.

          Will be something like this:

          [calmlikeabomb@reviews]# cd /usr/bin/
          [calmlikeabomb@reviews]# mysql -u root -p -h your.server

          Where -u is the user logging in (root in this example), -p just specifys we will be using a password, -h is the server were logging in to. Then you will be promted for the mysql password that is associated with the user.

          After logging in Select a database to work with:

          mysql> use databasename;

          If you don't know what databases are in the system:

          mysql> show databases;

          Show the tables in a database once you've selected one:

          mysql> show tables;

          Learn more about the fields/columns that the table consists of:

          mysql> describe sometable;

          Hope this gets you headed in the right direction ; )
          Last edited by calmlikeabomb; 01-23-2005, 10:37 PM.
          subarus.

          Comment

          • fris
            I have to go potty
            • Aug 2002
            • 55734

            #6
            Originally posted by calmlikeabomb
            Login to your server via ssh. Change directories to where mysql is installed and login to the mysql server.

            Will be something like this:

            [calmlikeabomb@reviews]# cd /usr/bin/
            [calmlikeabomb@reviews]# mysql -u root -p -h your.server

            Where -u is the user logging in (root in this example), -p just specifys we will be using a password, -h is the server were logging in to. Then you will be promted for the mysql password that is associated with the user.

            After logging in Select a database to work with:

            mysql> use databasename;

            If you don't know what databases are in the system:

            mysql> show databases;

            Show the tables in a database once you've selected one:

            mysql> show tables;

            Learn more about the fields/columns that the table consists of:

            mysql> describe sometable;

            Hope this gets you headed in the right direction ; )
            please tell her in english

            she will need to use to database with the software.

            tiffany if the software you are using needs say "database1" and the user and pass thats what you put when you install the software, the actual software accesss it.

            phpmyadmin is web based software used to edit your database that your host will setup.

            what software are you trying to install?
            Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.

            My Latest Theme

            Comment

            Working...