Centos install phpmyadmin

Centos Install PHPMYADMIN

1) Download from phpmyadmin website
2) Extract the file from the directory (such as /tmp directory) 
tar xvjf file.bz2
3) Rename the phpmyadmin folder after it is extracted
root# mv phpMyAdmin-4.0.0-all-languages.tar.bz2 phpmyadmin
4) Move the phpadmin folder to the /var/www/html folder, or, your virtual host folder such as a website called example.com. If you have a single website it will be in the html folder.
5) Open the phpmyadmin folder 
cd phpmyadmin
6) cp config.sample.inc.php config.inc.php

If mysql has no root password, you can 
change
$cfg['Servers'][$i]['AllowNoPassword'] = false;

to
$cfg['Servers'][$i]['AllowNoPassword'] = true;
But, that is a security risk.

You can alter the root password by logging into mysql and changing it.

 

[root@livedvd phpmyadmin]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.69 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> update mysql.user set password=PASSWORD('newpassword') WHERE user='root';

# service mysqld restart


Login to phpmyadmin
Look for errors and fix 
ie)
The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
The mcrypt extension is missing. Please check your PHP configuration.