Re: SQL server not protected

[anand sarda]

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

Regards,
Anand