Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: mysql password problem

    hello friends,

    iam using mysql 3-23 version

    and conncetion to mysql as mysql -p

    and it asks for the password

    when i press enter

    then it connects to the database

    so it s not taking any password

    now i want to give password

    i tried to directly insert into the user table of mysql database

    so i tried to insert statement as follows

    "inster into user (Password) values('admin') where User='root';

    but its giveing error

    so how to proceed from here

    with mysqladmin utility can we set the password to some word from empty space

    with regards
    rama kanth

  2. #2
    Join Date
    Nov 2003
    Sussex, England

    mySQL Password

    "inster into user (Password) values('admin') where User='root';

    Two things:

    "inster" should be "insert"


    It should'nt be an insert statement but an update:

    "UPDATE user SET Password = 'admin' WHERE user = 'root'"

    or something similar to that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts