September 25th, 2000, 07:43 PM
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,
September 25th, 2000, 09:40 PM
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
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?
September 25th, 2000, 11:07 PM
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.