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

    Join Date
    Mar 2000
    Location
    Fitzgerald Ga USA
    Posts
    8
    Rep Power
    0
    I have hit a brick wall with this one:
    when I use the command

    ./bin/mysqladmin -u (user) -p (password)

    I get this:
    ./bin/mysqladmin: unable to change password; error: 'You are using MySQL as an anonymous users
    and anonymous users are not allowed to change passwords'

    I'm assuming that it is looking for this user to already exist, but I am unsure as to HOW to add new users. I'm new to MySQL, so please be patient. I do, however, have over two year's expierence on Linux administration, so server talk is easy for me to comprehend!

    Any help is welcome, will even accept urls to tutorials!!

    Regards,
    Brant
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Location
    Chicago IL, USA
    Posts
    16
    Rep Power
    0
    Are you trying to log in to MySQL or trying to change the password?

    If you are trying to change the password, try this syntax:
    ./bin/mysqladmin -u root -p 'mynewpassword'

    For logging into MySQL, I use this command:
    mysql -h localhost -u root -p

    This will then prompt me for a password. The -h is for Hostname, which can be myhost.com or localhost.

    Also, check out www.mysql.com for the MySQL documentation, as well as http://www.devshed.com/Server_Side/PHP/DB_Basics/ here at devshed, and finally WebMonkey (www.webmonkey.com) has some great MySQL info at http://hotwired.lycos.com/webmonkey/...tw=programming

    Hope this helps!

    michael
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Location
    Fitzgerald Ga USA
    Posts
    8
    Rep Power
    0
    Thank YOU!! I finally got a web based program to help me add new users and hosts.
    I fiddled for a few hours trying to add them via mysql directly (with no luck) then went to the contrib page on MySQL and took their suggestion....works VERY WELL!
    Once Again, thank you!!

    Regards,
    Brant
  6. #4
  7. 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
    19
    I use the GRANT statements myself. A bit more difficult to learn, but much more control over access. Of course, if you don't need that type of control...

Similar Threads

  1. Adding new users?
    By tyroneclark in forum MySQL Help
    Replies: 1
    Last Post: December 20th, 2003, 10:38 AM
  2. Adding an array in a mysql database
    By s200 in forum PHP Development
    Replies: 0
    Last Post: November 5th, 2002, 03:02 PM
  3. Randome users ID in mysql database
    By Pupeno in forum PHP Development
    Replies: 4
    Last Post: July 14th, 2002, 09:04 AM
  4. Adding to mySQL field without removing what is there
    By mediaworks in forum PHP Development
    Replies: 8
    Last Post: August 7th, 2001, 09:41 AM
  5. Setting USER & PWD for *tables*??
    By Nightspirit in forum MySQL Help
    Replies: 3
    Last Post: September 26th, 2000, 06:04 AM

IMN logo majestic logo threadwatch logo seochat tools logo