MySQL安装方法集合（64bit CentOS）

MySQL安装方法集合（64bit CentOS）

                                                      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

 

 

2.        InstallMySQL using RPM file

--Download mysql-server RPM file

wget http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-server-5.5.16-1.linux2.6.x86_64.rpm/from/http://mirror.khlug.org/mysql/  

--Download mysql-client RPM file

wget http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-client-5.5.16-1.linux2.6.x86_64.rpm/from/http://mirror.khlug.org/mysql/  

rpm -ivh MySQL-server-5.5.16-1.linux2.6.x86_64.rpm MySQL-client-5.5.16-1.linux2.6.x86_64.rpm

 

--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

 

cmake -DCMAKE_INSTALL_PREFIX=/home1/mysql/mysql-service \

-DMYSQL_UNIX_ADDR=/home1/mysql/mysql-service/tmp/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk,gb2312 \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DMYSQL_DATADIR=/home1/mysql/mysql-service/data \

-DMYSQL_USER=mysql

 

make

make install

 

3. MySQL configuration

chmod +w /home1/mysql/mysql-service

chown -R mysql:mysql /home1/mysql/mysql-service

 

mkdir -p /home1/mysql/mysql-service/data/

mkdir -p /home1/mysql/mysql-service/log/

 

cd support-files/

cp my-large.cnf /home1/mysql/mysql-service/my.cnf

cp mysql.server /etc/init.d/mysqld

 

/home1/mysql/mysql-service/scripts/mysql_install_db \

--defaults-file=/home1/mysql/mysql-service/my.cnf \

--basedir=/home1/mysql/mysql-service \

--datadir=/home1/mysql/mysql-service/data \

--user=mysql

 

chmod +x /etc/init.d/mysqld

 

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

 

5. start mysql service：

service mysqld start

 

6.Set password：

/home1/mysql/mysql-service/bin/mysqladmin password [new-password]

 

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

            

            cp support-files/my-medium.cnf /etc/my.cnf

            vi my.cnf

                 basedir=/home1/mysql/mysql

                  datadir=/home1/mysql/mysql/data

                 socket          = /home1/mysql/mysql/tmp/mysql.sock  

                  innodb_data_home_dir = /home1/mysql/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)'

 

               Solution：

-- mysqladmin call mysql.sock from /tmp/mysql.sock default

ln -s /home1/mysql/mysql/tmp/mysql.sock /tmp/mysql.sock

 

                bin/mysqladmin -uroot password [password]

            

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