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

    Join Date
    May 2000
    Posts
    19
    Rep Power
    0
    i start mysql through
    ./mysql.server start
    and i starts successfully but now
    how can i get sql prompt to query and
    create database?
  2. #2
  3. No Profile Picture
    freebsd
    Guest
    Devshed Newbie (0 - 499 posts)
    Run this script:

    /usr/local/mysql/bin/mysql_install_db
  4. #3
  5. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    To get a mysql prompt at the command line you need to run:

    mysql -u user -ppassword

    If mysql is not in your path you will need to add that.

    If it's your first time connecting use root for user and no password but set a password as soon as possible!

IMN logo majestic logo threadwatch logo seochat tools logo