Summary of MySQL installation on a Linux system
Archive - Originally posted on "The Horse's Mouth" - 2008-12-11 10:47:58 - Graham EllisThe critical steps of deleting an old copy of MySQL, and installing and starting up a nice new clean one!
(the numbers are my "history number" - I did a lot of ls-ing and vi-ing in between!)
1001 cd /usr/local
1004 rm -rf mysql-5.1.24-rc-linux-i686-icc-glibc23/
1006 rm mysql
1009 tar xzf /home/trainee/bristol/mysql-5.1.24-rc-linux-i686-icc-glibc23.tar.gz
1013 ln -s mysql-5.1.24-rc-linux-i686-icc-glibc23 mysql
1014 cd mysql
1016 vi INSTALL-BINARY
1017 chown -R mysql.mysql .
1019 scripts/mysql_install_db --user=mysql
1021 chown -R root .
1022 chown -R mysql data
1024 bin/mysqld_safe --user=mysql &
Notes:
a) There may be a need to shut the Ole Daemon down first.
b) Beware files /etc/my.cnf and /root/.my.cnf which may exist from a previous install and have the database parameters and directories set to goodness only knows where
c) I HAVE DESTROYED ALL THE DATA that was being held in the previous database (but then I have a good backup, yah?)
d) I need to go on and set up the password and accounts for the database. It's left wide open with the base install - but not as wide as it used to be
e) To make it reload on reboot, the mysql.server script that's supplied with the download should be put into /etc/init.d, with appropriate links from rc5.d or rc3.d