How to install PhpMyadmin in Linux

Login as Root

[root@server~]# cd /var/www/html 

[root@server~]# # wget -c

[root@server~]# # tar -xzvf phpMyAdmin-3.3.7-english.tar.gz

[root@server~]# # rm -rf phpMyAdmin-3.3.7-english.tar.gz

[root@server~]# # mv phpMyAdmin-3.3.7-english phpmyadmin

[root@server~]# # cd phpmyadmin

[root@server~]# # cp

[root@server~]# # service httpd restart

 You can test by open phpmyadmin by this link : ( Eg : http://localhost/phpmyadmin)

Try to login as a mysql user.

If you get this error

#2002 Cannot log in to the MySQL server

Solution :

Reset Mysql root password and retry after that.

 Reset Mysql Root Password

1: Stop the MySQL server process.

[root@server~]# # /etc/init.d/mysqld stop

2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password.

[root@server~]# # mysqld_safe –skip-grant-tables &

3: Connect to mysql server as the root user.

[root@server~]# # mysql -u root

4: Setup new mysql root account password i.e. reset mysql password.

mysql> use mysql;

mysql> update user set password=PASSWORD(“NEW-ROOT-PASSWORD”) where User=’root’;

mysql> flush privileges;

mysql> quit;

5: Exit and restart the MySQL server.

[root@server~]#  /etc/init.d/mysqld stop

6: Start MySQL server and test it

[root@server~]# /etc/init.d/mysql start

[root@server~]#  mysql -u root -p

Login with new root password


About Manish Jha

Hi All I am Manish Kumar Jha aka Alex Hunt. I am currently working in VMware Software India Pvt Ltd as Operations System Engineer (vCloud Air Operations). I have around 5 Years of IT experience and have exposure on VMware vSphere, vCloud Director, RHEL and modern data center technologies like Cisco UCS and Cisco Nexus 1000v and NSX. If you find any post informational to you please press like and share it across social media and leave your comments if you want to discuss further on any post. Disclaimer: All the information on this website is published in good faith and for general information purpose only. I don’t make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information you find on this blog is strictly at your own risk. The Views and opinions published on this blog are my own and not the opinions of my employer or any of the vendors of the product discussed.
This entry was posted in Linux/CentOS. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s