MySQL Install 1. InstallMySQL using yum
--Check whether mysql has been installed
yum list installed | grep mysql
yum list installed | grep MySQL
--yum -y remove ..... ex:
yum -y remove MySQL-server
yum -y remove MySQL-client-5.5.13-1.rhel5.x86_64
--Install command:
yum search mysql
yum -y install mysql-server.x86_64
/usr/bin/mysql_install_db
--Start mysqld service
service mysqld start
service mysqld
Usage: /etc/init.d/mysqld {start|stop|status|condrestart|restart}
mysqladmin -uroot password [password]
--After installation, mysql directories and files’ distribution
mysql client executable file
/usr/bin/mysql
mysqld service
/usr/libexec/mysqld, /usr/libexec/mysqlmanager
log and database file
/var/lib/mysql
mysql.sock
/var/lib/mysql/mysql.sock
mysql config file
/etc/my.cnf
error message and character files
/usr/share/mysql
--Start mysqld service
service mysqld start
service mysqld
Usage: /etc/init.d/mysqld {start|stop|status|condrestart|restart}
mysqladmin -uroot password [password]
-After installation, mysql directories and files’ distribution
mysql client executable file
/usr/bin/mysql
mysqld service
/usr/libexec/mysqld, /usr/libexec/mysqlmanager
log and database file
/var/lib/mysql
mysql.sock
/var/lib/mysql/mysql.sock
mysql config file
/etc/my.cnf
error message and character files
/usr/share/mysql
3. InstallMySQL using source code
cd /home1/mysql
1. Compile and install cmake,
wget http://www.cmake.org/files/v2.8/cmake-2.8.5.tar.gz
tar xvf cmake-2.8.5.tar.gz
cd cmake-2.8.5
./bootstrap
make
make install
2. Compile and install mysql-5.5.15 (Directory: /home1/mysql/mysql-service)
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.15.tar.gz/from/http://mirror.khlug.org/mysql/
tar xvf mysql-5.5.15.tar.gz
cd mysql-5.5.15
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
vi /etc/init.d/mysqld(edit this file,find and edit the variables, if there no these variable add them)
basedir=/home1/mysql/mysql-service
datadir=/home1/mysql/mysql-service/data
4. Add them into bootup:
chkconfig --add mysqld
chkconfig --level 345 mysqld on
7. Many programs call mysql.sock from /var/lib/mysql/mysql.sock:
mkdir -p /var/lib/mysql
ln -s /var/lib/mysql/mysql.sock /home1/mysql/mysql-service/tmp/mysql.sock
4. InstallMySQL using compressed TAR archive without Installation
1. Download compressed tar archive mysql file
cd /home1/mysql
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.16-linux2.6-x86_64.tar.gz/from/http://mirror.khlug.org/mysql/
tar xvf mysql-5.5.16-linux2.6-x86_64.tar.gz
cp -r mysql-5.5.16-linux2.6-x86_64/ mysql
mkdir -p /home1/mysql/mysql/tmp
groupadd mysql
useradd -g mysql mysql
cd /home1/mysql/mysql
ln -s /home1/mysql/mysql/bin/mysql /usr/bin/
chown -R mysql .
chgrp -R mysql .
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data
/home1/mysql/mysql/bin/mysqld_safe --user=mysql & --start mysqld service
Error:
110915 18:01:50 [ERROR] Can't start server : Bind on unix socket: Permission denied
110915 18:01:50 [ERROR] Do you already have another mysqld server running on socket: /home1/mysql/mysql/tmp/mysql.sock ?
Solution: chmod 777 /home1/mysql/mysql/tmp/
/home1/mysql/mysql/bin/mysqladmin -uroot -p shutdown -- shut down mysql
Error:
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
2. Add mysql service into bootup
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod 700 /etc/init.d/mysqld
chkconfig –add mysqld
chkconfig –level 345 mysqld on