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

    Join Date
    Oct 2000
    Posts
    4
    Rep Power
    0
    I need help with mySQL
    I just had my web host install the mySQL on the server I am planning to use.

    How do I create a new database and assign user name and password for it?

    This is what I do:
    ./mysql -u root -p

    Then enter password. Good, I am logged in

    Then when I do this:
    CREATE DATABASE somename;

    It says that database is created. I guess it's good. But how do assign a user name and password who can use it. I don't want to use root user for it.

    Does the user have to be added to the Linux users first or can user be added just to mySQL?

    I know that it's possible to add database and users and password in one shot using mysqladmin, but I don't know how to do this.

    Reading online help from mySQL.com has been the most frastrating experience I've had in years.

  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4476
    The manual shows how to do this easily. You use the GRANT command.
    http://www.mysql.com/documentation/m...ivilege_system

    ------------------
    *************************************************************
    * The manual can probably answer 90% of your questions... *
    * *
    * PHP Manual. www.php.net/manual *
    * MySQL Manual: www.mysql.com/documentation/mysql/bychapter *
    *************************************************************

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