Knowledge for the World

How to create a mysql password for root

If you've just installed mysql, you will probably want to create a password for the root user.

1

Simply type: mysqladmin -u root password PASSWORD where PASSWORD is the password you'd like to use. Another example: mysqladmin -u root password 5a0ZI73SU8xk If you need to generate a password go to http://randompassword.info