gamehead200 Posted October 3, 2003 Posted October 3, 2003 OK, so I installed MySQL 4.0.15, and whenever I try setting a password for it, for example:username: gameheadpassword: rocksIt keeps the default username and password:username: rootpassword: (no password)I deleted the "my.ini" file and then when I reopen MySQL, it asks me for a new username and password, so I put in the first one above, but it still stays as root...Does anyone know how to fix this problem?
xper Posted October 3, 2003 Posted October 3, 2003 mysqladmin -u root password newpassword (from console)You need first to insert (gamehead) new user into mysql database than make password for new user and grant privileges.user root is owner and must be there you can't change that
gamehead200 Posted October 4, 2003 Author Posted October 4, 2003 Oh yea, I forgot to mention that this is on a Windows server...
gamehead200 Posted October 4, 2003 Author Posted October 4, 2003 Oh yea, I forgot to mention that this is on a Windows server... *BUMP*Help?
xper Posted October 4, 2003 Posted October 4, 2003 Oh yea, I forgot to mention that this is on a Windows server... Same. Go to dos prompt and type cd mysql/bin if you installed it in C:\ then type command I wrote in post above.
gamehead200 Posted October 4, 2003 Author Posted October 4, 2003 Sorry, xper...But none of that is working for me...Is there a guide on how to do this? (Edit: Nevermind, I got it working!)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now