changinh user name and password to mysql server

Discussion in 'PHP' started by progfrog, Dec 9, 2008.

  1. #1
    hi guys!
    I installed wampserver on my pc- includes php,mysql,apache . How do I change my username and password on the mysqlserver instead of the deafault's one?

    thanx a lot
    progfrog
     
    progfrog, Dec 9, 2008 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    If you have mysql command line access or a phpmyadmin sql prompt:

    USE mysql;
    UPDATE user SET Password = PASSWORD('newpassword') WHERE User = 'username';
     
    jestep, Dec 9, 2008 IP