MySQL Forums
Forum List  »  Install & Repo

Re: SQL server not protected
Posted by: anand sarda
Date: September 18, 2004 07:03PM

use the following command to set password for the root account
- update user set password = password('<your password>') where user = 'root'
Please Note: use the password() function to set the password other wise you may have problems.
Do the same for new user name
for e.g.
insert into user(host, user, password) values('<hostname>', '<username>', password('<yourpassword>'))

hope this helps


Options: ReplyQuote

Written By
September 14, 2004 01:10PM
Re: SQL server not protected
September 18, 2004 07:03PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.