SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Feb 2002
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mySQL question: How do I create a normal user account?

    Hello all:

    Looks like a good place to get some answers.

    I just installed the latest version of mySQL on my Windows 2000 server for the first time and it is working fine.

    I know how to set the 'root' password and know how to create a database.

    My question is:

    How do I create a normal user account since I don't want to share my 'root' account?

    I tried this:

    c:\mysql\bin:> mysqladmin -u user password "password here"

    What am I doing wrong?

    Thanks.

  2. #2
    SitePoint Wizard silver trophy redemption's Avatar
    Join Date
    Sep 2001
    Location
    Singapore
    Posts
    5,269
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: mySQL question: How do I create a normal user account?

    this
    Code:
    c:\mysql\bin:> mysqladmin -u user password "password here"
    only serves to try to login the mysqladmin using the user and password specified and doesn't create a new user...

    you need to use the GRANT command to create new users and specify their privileges...

    read
    here for more... it's all from the MySQL documentation btw...


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
  •