how to change mysql root password

[zybler]

i downloaded the phpdev423 bundle from
http://www.firepages.com.au/phpdev41.htm

after installed it, i understand that by default, MySQL has no security. I just want to know how to change the root password? What should i do to secure the server if it's connected to the internet, to prevent it being compromised by hackers?

can anyone give me a step-by-step guide on how to configure the settings to make it more secure?

Thanks in advanced.

[jaysun]

First of all you should remove the anonymous user from mySQL by logging into mySQL then running this sql:

mysql> DELETE FROM user WHERE host='localhost' AND user='';

Quit mySQL and from the command line run the following (make sure you are in the mysql\bin directory):

mysqladmin reload

This reloads all the table information and therefore removing the anonymous user.

Next, still in the command line:

mysqladmin -u root password <your new password>

This sets a password for the root user (admin) and your job is done

If you wan to see the priveleges set for user, db's and tables then simply view the tables in the mysql database with so sql:

e.g. select user,host from users;

Hope this helps you - JaYsuN