Set mysql’s root password on fresh copy from SolusVM OS template

On SolusVM, your host may provide you with OS templates such as “Ubuntu 10.04 LTS LAMP” and you click-install it to your VPS. Now how do you change its mysql’s root password? simple, run these two commands on SSH after doing

mysql
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

Installing T1LIB on Ubuntu

I recently found out about T1LIB. But I had no clue how to install this. Lucky for me I am on Ubuntu and I have the ability to search for a package.

T1LIB is actually in the latest Ubuntu 10.04 LTS. You can install it by punching in the following command

apt-get install t1lib-bin

Build-Essentials in CentOS?

If you are like me, you may be doing this to install essential build libraries to compile something from source

# wrong method
yum install build-essential

:) Build essential is a Ubuntu / Debian package. On CentOS, you need to do this

yum groupinstall "Development Tools"

Warning: This will install all development tools approx 49 packages closing to 65MB

Installing PHP’s SSH2 extension on Ubuntu

On Ubuntu 10.04 LTS, Do this (there’s no need to do any compiling anymore)

apt-get install libssh2-1-dev libssh2-php

You can now test if PHP recognizes it’s new ssh2 extension by running:

php -m |grep ssh2

Don’t forget to restart Apache

service apache2 restart

Good bye CentOS! Hello 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 CentOS 5.4 has the following versions

  • Apache 2 version is 2.2.3
  • PHP version is 5.1.6
  • MySQL version is 5.0.77
  • SVN (Subversion) version is 1.4.2

So if you are a PHP developer looking to deploy a Linux flavour on your new box, choose Ubuntu :)

Installing / re-installing and Configuring phpMyAdmin on 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

sudo apt-get install phpmyadmin

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)

sudo nano /etc/apache2/apache2.conf
# better to use the following command instead of the one above
#gksudo gedit /etc/apache2/apache2.conf

Add the following line of code inside apache2.conf:

Include /etc/phpmyadmin/apache.conf

Now restart Apache:

sudo /etc/init.d/apache2 restart

Go to /phpmyadmin/ and login with your mysql username and password.