I am passionate about art, music, photography, and I guess all things creative (including making your website)

Ubuntu and MYSQL

October 20th, 2008. Written by Josh

Run the following in terminal:

sudo apt-get install mysql-server

sudo apt-get install php5-mysql

service apache2 restart

MYSQL installation will walk you through the creation of the root password. Once complete, your done!

The second step is option if you want your server to support PHP, although I highly recommend installing regardless.

Installing PHPMYADMIN

Once complete, navigate to /var/www and run “mkdir phpmyadmin”.

Navigate to the newly created directory and download the latest version of phpmyadmin, “wget http://sourceforge.net/project/downloading.php?groupname=phpmyadmin&filename=phpMyAdmin-3.0.1-rc1-english.tar.bz2&use_mirror=internap”. Unarchive with ‘tar -xvf phpmyadmin* /var/www/phpmyadmin’.

Navigate to the new phpmyadmin directory. Make a backup of config.sample.inc.php, ‘cat config.sample.inc.php > config.inc.php’. Edit the new config.inc.php file, ‘vi config.inc.php’, modify the following:

$cfg['blowfish_secret'] = ”; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

// $cfg['Servers'][$i]['controluser'] = ‘pma’;
// $cfg['Servers'][$i]['controlpass'] = ‘pmapass’;

Line 1 needs a random string of characters between the single quotes, something long that makes no sense. 2nd and 3rd lines need your mysql user name as root, and whatever password you chose during setup.  Thats pretty much it. Rock on.

No Responses to "Ubuntu and MYSQL"

Leave a Reply