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

    Join Date
    Sep 2000
    Location
    Montreal, Québec, Canada
    Posts
    3
    Rep Power
    0
    I wanna change the root password, add users and change their password.

    For the root part, I looked in the manual, and the described command line ( mysqladmin -u root -p password )doesn't work.
    I tried many things, but I have no idea.
    Any info for the 2 other things is good to know, though I can find it in the manual.
    I'm using 3.23.24-beta.

    Thanks for any help,

    Pete
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    OK, just to be sure:

    Let's say your existing password is 'mydata' and you want a new password 'ourdata'.

    The syntax is

    mysqladmin -u root -p password ourdata

    MySQL will prompt you for the old password with

    Enter password:

    And then it will update to the new password specified when calling mysqladmin.

    If this didn't work, then either something is wrong with your mysql install or you somehow have the wrong existing password. When you say mysqladmin "doesn't work" its best to be specific. What error message or response did you get?
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Location
    Montreal, Québec, Canada
    Posts
    3
    Rep Power
    0
    But I have no actual password, and when I press enter at the password prompt, i get told that access is denied. But still, I can connect to the databases without any password.

Similar Threads

  1. Can user A read user B's session?
    By Stupid Khor in forum PHP Development
    Replies: 9
    Last Post: May 11th, 2004, 05:19 AM
  2. php user levels
    By dynasty in forum PHP Development
    Replies: 1
    Last Post: January 20th, 2004, 02:01 PM
  3. How to get multiple sessions for one user working?
    By jkoerber in forum PHP Development
    Replies: 1
    Last Post: January 16th, 2004, 01:23 PM
  4. Is there a drop-in user control module?
    By Kent Wang in forum PHP Development
    Replies: 3
    Last Post: December 20th, 2003, 05:20 AM
  5. WHM account creation error messages on RH
    By borisbaloney in forum Linux Help
    Replies: 0
    Last Post: December 16th, 2003, 06:54 PM

IMN logo majestic logo threadwatch logo seochat tools logo