Thread: mySQL

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    12
    Rep Power
    0
    Ugh, sorry for posting 2 posts in one day, i must be annoying you guys =P But, since im new to PHP and all, i'm having a bit of trouble with mySQL. The server my website is on is hosted on a unix machine that my friend owns, and it has mySQL already installed onto it - but he has no idea how to work with it. Could anyone tell me how to create a database with mySQL? I thought it was created by a code, but i don't think that is the case.

    I tried http://www.mysql.com but I'm not sure what to look under. installtion? creating? etc.

    Thanks,
    -Bryan
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    12
    Rep Power
    0
    Hmm nevermind...looks like he has something called pSQL on his server and not mySQL. Ah well...

    -Bryan

    [This message has been edited by jamnbryan (edited July 13, 2000).]
  4. #3
  5. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4492
    well, first tell him to download mysql, it's free and works great with php.

    the sql syntax for creating databases should be about the same, no matter what program your using. can you get command line access to the database? in mysql, you use

    create database database_name;

    ---John Holmes...
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Aalborg, Denmark
    Posts
    9
    Rep Power
    0
    Another way to get easy MySQL-management and SQL-feel is to use phpMyAdmin from phpwizards.net

    Just put the scripts in a seperate directory and edit the config.inc.php supplying your username and password and you should be in business.

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 06:02 PM
  2. Upgrade from access to mysql
    By karib1 in forum ASP Programming
    Replies: 7
    Last Post: December 16th, 2003, 12:35 PM
  3. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 12:27 AM
  4. problem: asp files, from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: November 26th, 2003, 03:16 AM

IMN logo majestic logo threadwatch logo seochat tools logo