Create an Account   |    Log In
Questions (949) 771-0300

Set Mysql Root Password



MySQL is a Relational Database Management System (RDBMS) that runs as a server providing multi-user access to a number of databases. For more information on MySQL, you can visit their website at www.mysql.com.

How to configure MySQL
Log into MySQL
mysql -u root
Set the root user password for all local domains
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘new-password’);
SET PASSWORD FOR ‘root’@’localhost.localdomain’ = PASSWORD(‘new-password’);
SET PASSWORD FOR ‘root’@’127.0.0.1′ = PASSWORD(‘new-password’);
Drop the Any user
DROP USER ”@’localhost';
DROP USER ”@’localhost.localdomain';
Exit MySQL
exit