Page 2 of 2

Re: Preparing for painless up to date LAMP install on CentOS

Posted: Mon Feb 23, 2015 11:21 am
by bowlesj
Hi, I have read a bunch of stuff about upgrading to PHP 5.5.X on CentOS 5 and I reduced my questions down to two. Can someone answer them. Thanks, John.

Q1: For CentOS 5, on the remi site, are these the correct set of repo install commands? "Enterprise Linux 5 (with EPEL) i386 or x86_64"
Actually I think I got a "yes" here "https://www.centos.org/docs/5/html/Depl ... ide-en-US/" at the very bottom where it says CentOS 5.

Q2: I am running "mysql Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (i386) using readline 5.1". This pypMyAdmin link http://www.phpmyadmin.net/home_page/downloads.php says "Please note that phpMyAdmin 4.3.10 requires at least PHP 5.2 and MySQL 5." Should I update this MySql? If yes, I was originally thinking I would use "yum remove mysql" then use "yum install mysql" after the remi repos were in place. However, I was reading this link "http://www.servermom.org/upgrade-php-53 ... ntos/1534/" and he suggested upgrading MySql using "mysql_upgrade -u root -p"

For any beginners of Yum PHP upgrading like myself here are a few links I found useful. I built up a full list of commands to execute.
=====================================================================================================
http://wiki.centos.org/FAQ/General (general FAQs about centos)
http://www.centos.org/docs/5/html/yum/index.html (managing software with yum)
http://www.servermom.org/upgrade-php-53 ... ntos/1534/ (a beginners guide to using the remi site with a few extra tips)
http://www.shayanderson.com/linux/cento ... php-55.htm (another way of upgrading)
https://www.centos.org/docs/5/html/5.2/ ... mconf.html (sample yum configuration file)
http://blog.famillecollet.com/pages/Config-en (the remi instructions for getting the repo files down)
https://webtatic.com/packages/php53/ (another place you can get repo files - a few tips here went into my todo list)
http://dag.wiee.rs/rpm/FAQ.php#B4 (another place you can get repo files)
https://www.centos.org/docs/5/html/Depl ... ide-en-US/ (Red Hat Enterprise Linux 5 deployment guide and it says CentOS 5 at the bottom)

Re: Preparing for painless up to date LAMP install on CentOS

Posted: Mon Feb 23, 2015 12:34 pm
by Celauran
CentOS and RHEL are interchangeable. One is the community version of the other.

You have MySQL 5.0.95, which is quite old, but does satisfy the phpMyAdmin requirements. I would recommend updating it, but not for the sake of phpMyAdmin.

Re: Preparing for painless up to date LAMP install on CentOS

Posted: Mon Feb 23, 2015 1:16 pm
by bowlesj
Thanks Celauran. I will go ahead then. John

Re: Preparing for painless up to date LAMP install on CentOS

Posted: Mon Feb 23, 2015 3:13 pm
by bowlesj
I had a problem and figured it out. So PHP 5.5.22 is now running. Thanks for the help.

Re: Preparing for painless up to date LAMP install on CentOS

Posted: Tue Feb 24, 2015 12:41 pm
by bowlesj
No question here. I just thought I would pass this on. I could log in to mysql as root but when I went to get in to phpMyAdmin it would not accept the same password (I made 100% sure I was keying it correctly - phpMyAdmin does accept cut and paste too). So I went to Google and found various pages on this problem. The first thing I tried worked (some were not so lucky from what I was reading). It took me a while to find this simple command for CentOS 5. I changed the mysql root password and it fixed the problem. I used this command.

mysqladmin -u root -pcurrentpassword password 'newpassword'

This is the link that explains the above command very well for CentOS 5 (Real short and to the point).
http://www.thegeekstuff.com/2009/07/cha ... nix-linux/
He explained one other approach and how to set the password for the first time too. He does not explain how to reset it if you forget the password.
Some of the guys reset their password (as if they had forgotten it). It is a much longer process.
Some fixed the problem other ways. It seems that one way or another there is a solution. The above is the first thing to try.

Re: Preparing for painless up to date LAMP install on CentOS

Posted: Tue Feb 24, 2015 2:43 pm
by Celauran
For resetting a forgotten MySQL root password, take a look at this: https://help.ubuntu.com/community/MysqlPasswordReset

Re: Preparing for painless up to date LAMP install on CentOS

Posted: Tue Feb 24, 2015 4:03 pm
by bowlesj
Thanks Celauran, good to know and it looks fairly easy to follow. I found some as well but was concerned about posting them with no experience or testing of them. I noticed it was Ubuntu. That brings a question since all my Google searches had "CentOS 5" in them. So generally, how much of MySql and even PHP changes across the different flavors of Linux? If parts change is it things like default directories, etc?

Re: Preparing for painless up to date LAMP install on CentOS

Posted: Tue Feb 24, 2015 4:05 pm
by Celauran
Very little changes. Packages might be bundled and/or named slightly differently, and Apache's default document root changes some, but all the important stuff is the same.