How to install phpMyAdmin – 2.11.3 on CentOS 5.

After , I installed PHP5, Apache2 and MySQL completed. I want to maintain MySQL service by phpMyAdmin program. This is solution of how to install phpMyAdmin 2.11.3 on CentOS 5.
[ad#ad-post-1]

  1. $ su –
  2. # cd /var/www/html
  3. # wget -c http://prdownloads.sourceforge.net/phpmyadmin/
    phpMyAdmin-2.11.3-english.tar.gz?download
  4. # tar xvfz phpMyAdmin-2.11.3-english.tar.gz
  5. # mv phpMyAdmin-2.11.3-english phpmyadmin
  6. # cd phpmyadmin
  7. # cp config.sample.inc.php config.inc.php
  8. # vi config.inc.php
    :
    $cfg[‘Servers’][$i][‘auth_type’] = ‘http‘; # default is cookies
    :
  9. # service httpd restart

You can test by open phpmyadmin by this link :

http://your.domain.com/phpmyadmin/

You should be find pop up for insert your user name and password.

0 0 votes
Article Rating
41 Comments
Inline Feedbacks
View all comments
joel
joel
13 years ago

Thanks so much for this step-by-step process. This really helps the new people that are just starting out on Unix and learning Unix.

Jonny
13 years ago

You do not need step 9 – the httpd server does not need to be restarted.

ble
13 years ago

Thanks, please visit my blogs http://panupongsk.blogspot.com , if you have a time.

Cia
13 years ago

Greate guide,it helped me very much thank you

Nitin M.
Nitin M.
13 years ago

Thanks for the installation steps

Regards,
Nitin

Sudeer
Sudeer
13 years ago

Hi,

After i did all the above installation steps and when i type the given URL in the browser,

http://localhost/phpmyadmin/

the page is loading for a very long time and finally got the below error.
—————————————————————————————————————–
Bad Request

Your browser sent a request that this server could not understand.
Size of a request header field exceeds server limit.

Cache-Control: max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, max-age=0, m
—————————————————————————————————————–
Apache/2.2.3 (CentOS) Server at localhost.localdomain Port 80
—————————————————————————————————————–

Please help me to slve this issue,thanks for your help.

Bhargav
13 years ago

Hello Folks,
It’s Working

Thanks

fabirodz
fabirodz
12 years ago

yayy it worked

hotcoder
12 years ago

Good tutorial, but I’m getting the error “You don’t have permission to “phpmyadmin” server folder. I’ve tried chown -R and chmod 0700 commands but in vain.

Aoddy
Admin
12 years ago

What is your owner when you changed owner by chown command ?

Donald Dubuque
12 years ago

cd /var/html/www/

or

cd /var/www/html/ This is my dir settings when I installed Apache,Mysql and PHP

Aoddy
Admin
12 years ago

Hi Donald,
Your dir is correct !!! . 😀

kickass
kickass
12 years ago

You are better locating phpmyadmin in /usr/share then you do a link in www

ln -s /usr/share/phpmyadmin /var/www/html

Mustapha
Mustapha
12 years ago

Hello

I’m just not sure about this

:
$cfg[‘Servers’][$i][‘auth_type’] = ‘http‘; # default is cookies
:

What should I do after I did vi to config.inc.php to the file??

Thank you

Aoddy
Admin
12 years ago

Hi Mustapha,
You don’t do anything except press F5 button on your web browser.

Chika
Chika
12 years ago

Really helpful!!

jideck
11 years ago
Aoddy
Admin
11 years ago
hellx
hellx
11 years ago

Hello,

my php version 5.3..im writing my browser adress line http://localhost/phpmyadmin
but have this message : PHP 5.2+ is required…why ?..please help me

martinparks
martinparks
11 years ago

Hey hellx, that happen to me as well, the new version 3.xx of phpmyadmin needs PHP 5.2+ if you don’t want to upgrade your PHP you will need to use version 2.xx

hellx
hellx
11 years ago

hey martinparks, already my php version 5.3.0 and version 3.xx phpmyadmin must run my system. But its not runing. What is the problem ?

sijagur
11 years ago

thanks for your info….

Dschingi
Dschingi
11 years ago

Have same prob using PHP 5.2.9:

PHP 5.2+ is required…

Has someone a solution?

worseo
worseo
11 years ago

Hi guys, thanks so much. I am new to linux. I follow the steps but this is the error I get.

phpMyAdmin – Error

Cannot load mysql extension. Please check your PHP configuration. – Documentation

worseo
worseo
11 years ago

I follow the steps but still have the below error. Can anybody help?

phpMyAdmin – Error

Cannot load mysql extension. Please check your PHP configuration. – Documentation

Ben
Ben
11 years ago

I downloaded the latest phpMyAdmin-3.2.4-rc1-english.tar.gz and installed it that way instead of the wget.
When i open a firefox it comes up with
Welcome to phpMyAdmin 2.11.5 not 3.2.4
Also below the language selection it says
Error
The configuration file now needs a secret passphrase
(blowfish_secret).

What does this mean?
I searched the config file and found a line like this
$cfg[‘blowfish_secret’] = ‘ ‘; /*YOU MUST FILL IN THIS FOR COOKIE AUTH! */
I entered a password inbetween the ‘ ‘ but it still comes up with the above error.

Whats going on there?

Alfie Punnoose
11 years ago

thanks a lot my friend. It was really easy to get the job done.

ari
ari
11 years ago

hi,

mate, i’m a bit lost.

why dont your tut work for me?

when here:

http://localhost/html/phpmyadmin/

i get all the direcory file listings – no phpmyadmin.

when here,:

http://localhost/phpmyadmin

i get file not found?

plz help.

tanx.

joel
joel
11 years ago

i can’t access phpmyadmin,hv some error”forbidden”
you dont have permission to access/phpmyadmin on this server

rob
10 years ago

Thanks a lot, this was very helpful.

rob
10 years ago

http://techblog.cfbangor.com

Thanks a lot, this was very helpful.

โมนาวี
10 years ago

It’s work, thanks for share.

Hanny
Hanny
10 years ago

got the same problem

indowaras
10 years ago

if you want to use for centos 4.6 you must use phpMyAdmin 2.11.11.3

1. Open /etc/httpd/conf/httpd.conf and include this line on last :
Include /etc/httpd/conf/phpmyadmin.conf

2. Make file /etc/httpd/conf/phpmyadmin.conf :

Alias /phpmyadmin /var/www/phpmyadmin

Options None
Order allow,deny
allow from all

3. ektrack phpMyAdmin 2.11.11.3 on /var/www/ and rename file to phpmyadmin

3. service httpd restart

Done try browse http://youdomain.com/phpmyadmin

thanks

lam
lam
9 years ago

i alrelly configed but it show You don’t have permission to access /phpmyadmin on this server.
Apache/2.2.15 (CentOS) Server at localhost Port 80
please help me

lam
lam
9 years ago

i already configed bit it show You don’t have permission to access /phpmyadmin on this server.
Apache/2.2.15 (CentOS) Server at localhost Port 80
please help me
thank!

I is happy
I is happy
9 years ago

Cheers did the trick for me on CENTOS6. Bookmarked.

Saylee
Saylee
9 years ago

It works,
Thank you for sharing
🙂

Nilesh
Nilesh
9 years ago

i have did all the steps but when i visit http://mydomain.com/phpmyadmin
it says

Not Found

The requested URL /phpmyadmin was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at mydomain.com Port 80