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!)
(written 2009-10-09)
Associated topics are indexed as below, or enter http://melksh.am/nnnn for individual articles
S153 - Sourcing, Running and Configuring MySQL [192] Current MySQL and PHP paths and upgrades - (2005-01-28)
[334] Symbolic links and hard links - (2005-06-02)
[489] Which MySQL server am I using? - (2005-11-07)
[515] MySQL - an FAQ - (2005-12-03)
[535] MySQL permissions and privileges - (2005-12-20)
[591] Key facts - SQL and MySQL - (2006-02-04)
[907] Browser -> httpd -> Tomcat -> MySQL. Restarting. - (2006-10-28)
[1095] Apache httpd , browser, MySQL and MySQL client downloads - (2007-02-28)
[1123] mysqldump and mysqlrestore - (2007-03-30)
[1131] MySQL - Password security (authentication protocol) - (2007-04-02)
[1689] Some sideways thoughts on the news - (2008-06-27)
[1731] Apache httpd, MySQL, PHP - installation procedure - (2008-08-01)
[1771] More HowTo diagrams - MySQL, Tomcat and Java - (2008-08-24)
[1935] Summary of MySQL installation on a Linux system - (2008-12-11)
[2085] MySQL - licensing issues, even with using the name - (2009-03-16)
[2209] Monitoring and Tuning your MySQL installation - (2009-05-31)
[2426] Which version of MySQL am I running? - (2009-09-26)
[2445] Securing MySQL on a production server - (2009-10-09)
[2458] Cant connect to local MySQL server through socket /tmp/mysql.sock - (2009-10-17)
[4390] Checking MySQL database backups have worked (not failed) - (2015-01-10)
[4406] Fixing damaged MySQL tables - Error 1712 and Error 2013 - (2015-01-25)
[4487] Starting MySQL. ERROR! The server quit without updating PID file - how we fixed it. - (2015-05-06)
Some other Articles
MySQL - efficiency and other topicsMySQL stored procedures / their use on the web from PHPLearn about MySQL stored proceduresPotted MySQL installationContrasting Cambridge, Bristol and WiltshireVariable storage - Perl, Tcl and Python comparedNot your cup of tea?Optional parameters to Python functionsMultiple returns from a function in Python