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.


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