MySQL Password Changes

by 4 replies
5
How do you change a password for an existing user via mysqladmin?
#programming #mysql #password
  • Go to your myPHPadmin
    Click on your database
    Click on Users table
    Edit the user your want to change
    Type in new password in the password field
    Change type to MD5
    Click OK
    • [1] reply
    • thanks that is neat is sh..i..t... I never knew that...
  • From the shell command prompt as root or with sudo:

    Code:
    mysqladmin -u USER -p password 'NEWPASSWORD'
    Substitute USER with the mysql user's ID and NEWPASSWORD with the new password you want it changed to.
  • Your Welcome
Join the discussion

Next Topics on Trending Feed