SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member robert2504's Avatar
    Join Date
    Aug 2001
    Location
    McAllen
    Posts
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQLAdmin will not pick up the database

    Hi,
    I am brand new to MYSQL and I need to use this database. I installed MySQL and when I run the Server, it does not detect the database that I need to use on MySQLAdmin. It only shows the test and mysql database. How do I go about adding the database that I need. I have downloaded myodbc but I do not know if I needed. Thanks for any help.

    Robert Hernandez

    Robert Hernandez
    Webmaster
    Valley Programmers

  2. #2
    Former Staff Member silver trophy Adam P.'s Avatar
    Join Date
    Apr 2001
    Location
    San Francisco
    Posts
    3,288
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    When you first install MySQL, the only databases you'll have are test and MySQL. I don't understand what you're lookin for then. Check out this quote from Kevin Yanks' tutorial on PHP and MySQL:
    Code:
    Type the following command (don't forget the semicolon!), then ENTER.
    
    mysql> SHOW DATABASES;
    
    MySQL will show you a list of the databases on the server.
    If this is a brand new server (i.e. if you installed this server
    yourself in Part I), the list should look like this:
    
    
    +----------+
    | Database |
    +----------+
    | mysql |
    | test |
    +----------+
    2 rows in set (0.11 sec)
    So what isn't working?
    SPF Mentor/Advisor 2001-2003
    SPF Designer of the Year 2002
    SPF Graphic Designer of the Year 2003
    AdamPolselli.com

  3. #3
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Robert, I am not familiar with MySQLadmin - you don't mean phpMyAdmin do you?

    In anycase, whether you use the console to access the mysql server (as in swim5001's example) or you use phpMyAdmin, or some other interface, you need to execute a SQL query to create a database that you wish to use.

    CREATE DATABASE MyDatabaseTable;

    Then you need to populate that database with the required tables:

    first select the database to work on:

    USE MyDatabaseTable;

    then create the tables in that database:

    CREATE TABLE tableFoo (
    myIntFoo INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    myStringFoo text);

    You will pick it up - but you will need to read the manual (www.mysql.com) and to start off with a interface to the mysql server such as phpMyAdmin can be helpful - if a little slow and clumsy to use.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •