phpMyAdmin default password for new installation centOS

If you recently were playing around with a dedicated server or a vps, I am sure you did install phpmyadmin along with mysql,php and apache. Most of the people new to centOS server management face issues figuring the default password which is asked when you login to phpmyadmin for the first time.

After some research I did find out that the default phpmyadmin username and password for first time login is as below:

Username : root
Password: your mySQL password [which you used at the time of installation].

If you have not set up any mysql root password yet, you can use following command in terminal to set one:

mysqladmin -u root password newpassword

Also, to make sure no one else can access your mySQL server, use following command to secure it:
mysqladmin -h server1.example.com -u root password rootpassword

Tip: Use following command to make sure mySQL starts everytim your server reboots:

chkconfig -levels 235 mysqld on
/etc/init.d/mysqld start

 

Incoming search terms:

Leave a Reply

*
Premium Wordpress Themes