Home > DIY > Webmin and phpmyadmin on Ubuntu Dapper

Webmin and phpmyadmin on Ubuntu Dapper

Here are quick and dirty instructions for installing webmin and phpmyadmin. This is adapted from here.

Webmin

Go to http://www.webmin.com/ and download the latest version of webmin in tar.gz format.

Once downloaded, extract it (filename may vary depending on the version you download):

tar xvfz webmin-*.tar.gz

Move into the directory:

cd webmin-*

Run the set-up program:

sudo ./setup.sh /usr/local/webmin

You can use the default settings for this, or change them if you know what you’re doing. Be sure to set a password you can remember.

phpMyAdmin for MySQL management

Go to http://www.phpmyadmin.net/home_page/index.php and download the latest stable release of phpMyAdmin in tar.gz format. Save it to /usr/src.

Extract:

cd /usr/src
tar xvfz phpMyAdmin-*.tar.gz
mv phpMyAdmin-* phpmyadmin

Move into that directory:

cd phpmyadmin/

Create a new configuration file:

cp config.sample.inc.php config.inc.php

Change the authentication mode to http

nano config.inc.php

Change this line:

$cfg['Servers'][$i]['auth_type'] = 'cookie';

…to this line:

$cfg['Servers'][$i]['auth_type'] = 'http';

Save the file.

Back in the command line, we need to set the root password, because by default, there isn’t one!

mysql -u root

You’ll then enter the MySQL console. Enter the following:

UPDATE mysql.user SET Password=PASSWORD('newpasswordhere') WHERE User='root';

This will set the root password. Now flush the privileges:

FLUSH PRIVILEGES;

Now exit:

exit

Now, we want phpMyAdmin accessible on the server ‘globally’. So that it doesn’t matter what address we’re using, we’ll still be able to access it.

In Webmin, under Apache Webserver: 1. Select “Default Server” 2. Aliases and Redirects 3. Under “Document directory aliases” enter /phpmyadmin/ into the first text box, and /usr/src/phpmyadmin/ into the box to the right of that one.

Save, and in the Terminal restart apache:

sudo /etc/init.d/apache2 restart

nano apache2.conf

add this in the appropriate place:

Options Indexes MultiViews
AllowOverride All
Order allow,deny
Allow from all

Go to http://yourdomain.com/phpmyadmin/

Login in using “root” and the password you set in the MySQL console.

You can do any MySQL configuration here. For me, I restored my Typo database for this blog from a backup.

Advertisements
Categories: DIY
  1. No comments yet.
  1. November 21, 2006 at 12:21 am

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: