PHPMYADMIN - Centos 5

[frosty]

I am a complete beginner on Centos and want to get PHPMyadmin working on my install. Is there a patient forum user out there who could help please. (baby steps please as I really am a beginner but willing to learn)

[kmount]

Hi Frosty,

 

I don't do an awful lot with CentOS but I believe you can run as root:

 

yum install phpmyadmin

 

And then run service httpd restart to restart Apache to pick it up.

 

Then browse to http://ip/phpmyadmin

 

If it doesn't work out like that yum remove phpmyadmin again.

 

Cheers,

 

Kim

[frosty]

 

yum install phpmyadmin

 

 

Thanks for your reply. It says "No package phpmyadmin available"

[webman]

I think you have to add an additional repository for it. Have you had a look on the CentOS forum? Someone's likely to have had the same issue before.

[frosty]

I have looked but whist it sounds defeatist there are so many solutions I am unsure as to which one to adopt, hence why I came to the Oracle that is Edugeek :-)

[powdarrmonkey]

Are you stuck with CentOS or can you use a distribution with sane package managers?

[frosty]

Are you stuck with CentOS or can you use a distribution with sane package managers?

 

I will give anything a go...just want to move my web services away from Windows. What do you have in mind?

[powdarrmonkey]

Install Ubuntu Server 10.04 LTS, and then say "sudo apt-get install apache2 libapache2-mod-php5 mysql-server phpmyadmin" and follow the prompts. Much easier, and the package maintainer has a brain.

[frosty]

Thanks my friend...I will give it a go

[CyberNerd]

download the install package from here:

Index of /phpmyadmin

 

do

 rpm -Uhv packagename.rpm 

 

and errors any you may need to

 yum install prerequisite 

(eg php, mysql etc)

[somabc]

Try this

 

note: copy each section of code and run at the command prompt or after running nano in the text editor.

 

you should be root for this if not type

su

 

rpm --import http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt

cd /tmp
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm
rpm -ivh rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm

 

yum install ntp httpd mysql-server php php-mysql php-mbstring php-mcrypt phpmyadmin

 

mysql_secure_installation

 

nano /etc/httpd/conf.d/phpmyadmin.conf

#
#  Web application to manage MySQL
#

#
#  Order Deny,Allow
#  Deny from all
#  Allow from 127.0.0.1
#

Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
Alias /mysqladmin /usr/share/phpmyadmin

 

Ctrl-X to save

 

nano /usr/share/phpmyadmin/config.inc.php

 

[...]
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';
[...]

 

Ctrl-X to save again.

 

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

 

Now you can direct your browser to http://localhost/phpmyadmin/ and log in with the user name root and your new root MySQL password.

 

The Perfect Server - CentOS 5.5 x86_64 [iSPConfig 3] | HowtoForge - Linux Howtos and Tutorials

Edited November 1, 2010 by somabc

[frosty]

download the install package from here:

Index of /phpmyadmin

 

To where? (told you I was a beginner!)

[somabc]

Are you stuck with CentOS or can you use a distribution with sane package managers?

 

Whats wrong with YUM?

[CyberNerd]

To where? (told you I was a beginner!)

 

anywhere.

using the command line (terminal) - or ssh using putty

become root

 su -

export http_proxy=http://yourproxy.com:8080

download using wget

 wget http://packages.sw.be/phpmyadmin/phpmyadmin-2.11.11-1.el5.rf.noarch.rpm

install the file

 rpm -Uhv phpmyadmin-2.11.11-1.el5.rf.noarch.rpm

 

check for errors. configure phpmyadmin

 

myght be best following somabc though

[somabc]

myght be best following somabc though

 

That's the first time anyone has ever said that

[frosty]

Thanks so much to everyone who has helped so far. I am all installed and can access PHPMYADMIN but get the following message: The configuration file now needs a secret passphrase (blowfish_secret). Could anyone help please? Edited November 10, 2010 by frosty
Typo

[CyberNerd]

The Configuration File Now Needs A Secret Passphrase (blowfish_secret)

[frosty]

My /usr/share/phpmyadmin/conf.inc.php file is empty...is that right?

[Guest Guest]

IMO switch to Debian or Ubuntu now before you learn a whole new OS. By far the easiest linux distro to work with imo. Plus it would seem the debian based ones, particulaly ubuntu, are the most popular with edugeek users so you'll get the most help with those.

 

apt-get install package

If the package relies on other packages (dependancies); apt-get -f install

search the package repositary; apt-cache search package

 

As someone has already posted, to set up a LAMP webserver with phpmyadmin on ubuntu/debian it is littrally "apt-get install aforementioned packages", thats it, all the config is done for you. All that you need to do is put a password on mysql

Edited November 10, 2010 by Guest

[powdarrmonkey]

All that you need to do is put a password on mysql

 

Wrong, debconf will prompt you for it.

[Guest Guest]

Wrong, debconf will prompt you for it.

 

I didn't say where you put it in, only that you had to put it in

[frosty]

IMO switch to Debian or Ubuntu now before you learn a whole new OS.l

 

Took your advice and all up and running. IMHO it was painless to install and set up so thanks :-). Hopefully just one last question on this!? Is it possible to have the www root as a mapped drive on my PC? It is a bit of a pain using FTP.

[Guest Guest]

FTP...? Yack! Try this WinSCP :: Free SFTP and FTP client for Windows as your windows client, with "apt-get install openssh-server" on your server.

 

But to answer your question, yes and no. Yes it is perfectly possible and relatively easy with samba, but no because you will wreck permissions. If you still really want to do it, its a non-production server which you are just "dicking around" with, you will happily fix permissions after working on it, and you understand the only reason I mention this is it is a learning exercise in working with webmin and samba;

 

chmod -R 777 /var/www
cd /tmp
wget http://downloads.sourceforge.net/project/webadmin/webmin/1.520/webmin_1.520_all.deb?r=http%3A%2F%2Fwww.webmin.com%2Fdownload.html&ts=1289737871&use_mirror=kent
apt-get install samba
dpkg -i *.deb
apt-get -f install

 

Then goto https://:10000 in a web browser, and goto the server/samba module, convert unix users to samba users, add a folder share for /var/www and add yourself as a read/write user. Also goto file permissions and change both new unix files andf new unix folders to read 777.

 

Like i say this is NOT how you would do it, and you really want to get into the habit of using something like winscp and then changing permissions as you go. The reason for this is the files and folders should be owned by user and group; www-data, and set with the appropriate permissions, usually something like 750 but this will varie depending on if its your config.php file etc.

Oh, and after that, have a look over teh samba config file to see how what you have done relates to it.

Have a read of this http://www.zzee.com/solutions/unix-permissions.shtml

Edited November 14, 2010 by Guest