Potted MySQL installation

Archive - Originally posted on "The Horse's Mouth" - 2009-10-09 05:13:59 - Graham Ellis
Putting MySQL onto a machine that may previously have had an install ... here's a summary of the commands we used yesterday. It's a useful checklist (reminders to get rid of old config files that could cause a new install to start with old data, for example) but you 'll need to adopt / adapt individual commands to deal with what you find on your system.

1. Backup / copy anything you want to keep!

2. Tidy up / remove previous installs

Kill any running daemons
Also /etc/my.cnf, ~/.my.cnf, /var/lib/mysql, /etc/init.d/mysql.server
cd /usr/local
rm mysql
rm -rf mysql-5.1.xx-linux-i686-icc-glibc23/

3. Fresh Install

[download / copy fresh distribution]
tar xf ~trainee/bristol/mysql-5.1.xx-linux-i686-icc-glibc23.tar.gz
ln -s mysql-5.1.xx-linux-i686-icc-glibc23 mysql
cd mysql
chown -R mysql.mysql .
./scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data
./bin/mysqld_safe --user=mysql &
export PATH=/usr/local/mysql/bin:$PATH
./bin/mysql_secure_installation
ps aux | grep mysql
mysql -uroot -pk645pfb -hlocalhost

4. Make permanent at reboot

cd /etc/init.d
cp /usr/local/mysql/support-files/mysql.server .
cd ../rc5.d
ln -s ../init.d/mysql.server S94mysqld
ln -s ../init.d/mysql.server K09mysqld

5. Create a user account and database

mysql -hlocalhost -p -uroot
grant all on twcrp.* to twcrp@"%" identified by "abc123" ;
create database twcrp;

(Yes, I am running our MySQL course at the moment!)

Main Content

Potted MySQL installation