Tag Archives: Ubuntu Server

Installing / re-installing and Configuring phpMyAdmin on Ubuntu

Posted on by
Reply

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.

Installing MySQL 5.1 on Ubuntu

Posted on by
6

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.

nano /etc/apt/sources.list

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.

deb http://ppa.launchpad.net/monty/ubuntu gutsy main universe restricted multiverse
deb http://ppa.launchpad.net/smurf/ubuntu gutsy main universe restricted multiverse

(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

apt-get update
apt-get upgrade

Note that you may need to do sudo prefix to these commands if you are using a non-root account. Now lets do the one last step, Installing MySQL 5.1

apt-get install mysql-server-5.1

Update: I have got another source to get even latest minor version of MySQL 5.1, just follow the above steps, then start over again and add following lines to “/etc/apt/sources.list” instead of the one above.

deb http://packages.dotdeb.org stable all
deb-src http://packages.dotdeb.org stable all

It worked for me on Ubuntu 8.10, im sure it will work for just any server version.

I am not a linux guru so if someone has a better option to upgrade to MySQL 5.1 or the latest version, please let me know.

Intall Apache, MySQL and PHP on Ubuntu – Part 2

Posted on by
1

Few weeks ago I wrote an article on how to setup Xampp package on Ubuntu. Today, I am revisiting this.

I came across a great article straight from the Ubuntu community, it is very simple, very strraight forward to setup Apache / MySQL and PHP on your Ubuntu box (server or desktop)

Read the article here.

Ubuntu: Setting default gateway / ip etc

Posted on by
Reply

If you want to specify a default gateway or ip address for your Ubuntu installation, try the following steps.

Open SSH and type this command

sudo nano /etc/network/interfaces

You can edit everything there as shown in the screenshot below (click to enlarge)

Ubuntu network interface

auto eth0
iface eth0 inet static
        address 192.168.1.231
        netmask 255.255.255.0
        network 192.168.1.0
        broadcast 192.168.1.255
        gateway 192.168.1.77
        # dns-* options are implemented by the resolvconf package, if installed
        dns-nameservers 192.168.1.253 192.168.1.226
        dns-search nextbridge.org