Good bye CentOS! Hello Ubuntu

CentOS, Linux, PHP, Reviews, Tips and Tricks, Ubuntu
Its been about almost more then two years since I have been playing with CentOS on many different platforms etc. Its very stable but on the other hand, PHP/MySQL updates are very hard to get and still PHP is 5.1.6. I tried EPEL repo and it updated PHP to 5.3.1 but still there were conflicts with stuff and many core packages. So, I thought why not move to Ubuntu since it has just announced 10.04LTS (Long Term Support) in April 2010. Folks at iWeb were really nice to do a reinstall without any charges and also process a memory upgrade request at an amazing 50% discount. Ubuntu 10.04 LTS Apache 2 version is 2.2.14 PHP version is 5.3.2 MySQL version is 5.1.41-3ubuntu12 SVN (Subversion) version is 1.6.6 As a comparison…
Read More

Installing / re-installing and Configuring phpMyAdmin on Ubuntu

How to, Linux, OpenSource, PHP, Resources, Tips and Tricks, Tutorials, Ubuntu
phpMyAdmin is a very common and handy tool that most of the developers use. It is available on almost every server. Installing phpMyAdmin on Ubuntu server is even easier, you just need to but what if we accidently skip the configuration screen where phpmyadmin makes modifications to apache? Dont worry just do the following Edit Apache's configuration file (assuming you are using apache2) Add the following line of code inside apache2.conf: Now restart Apache: Go to /phpmyadmin/ and login with your mysql username and password.
Read More

Installing MySQL 5.1 on Ubuntu

How to, Linux, Tips and Tricks, Tutorials, Ubuntu
I wanted to use PARTITIONING introduced in MySQL 5.1 to handle some 2 Million records (and growing everyday) in a table. Ubuntu 8.10 does not have MySQL 5.1 available if you do apt-get the latest version available is 5.0 So this is what I did, its easy and this might help somebody. I prefer nano editor but you can use any editor of your choice. Add these new lines at the end of the end of the file. (These packages were targeted for 7.10 so I will recommend using them and removing them from this list once you got the latest MySQL version) Now run the following commands Note that you may need to do sudo prefix to these commands if you are using a non-root account. Now lets do…
Read More