|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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.
|
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > Changing user passwords? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|