MySQL安装方式

一、单实例_rpm
1、上传安装包
tar -xf mysql-5.7.24-1.el6.x86_64.rpm-bundle.tar
2、检查是否安装

rpm -qa | grep -i mysqlrpm -qa | grep -i maria若有安装 yum remove -y  包名rm -fr /usr/lib/mysqlrm -fr /usr/include/mysqlrm -fr /etc/my.cnfrm -fr /var/lib/mysqlrm -fr /usr/share/mysqlrm -fr /usr/local/mysqlfind / -name mysql

3、安装MySQL

mkdir -p /home/mysql/{3306,3307}/{data,log}chown -R mysql:mysql /homechmod -R 755 /homecd /home/mysql/rpm -ivh mysql-community-common-5.7.24-1.el6.x86_64.rpmrpm -ivh mysql-community-libs-5.7.24-1.el6.x86_64.rpmrpm -ivh mysql-community-client-5.7.24-1.el6.x86_64.rpmrpm -ivh mysql-community-server-5.7.24-1.el6.x86_64.rpm

4、my.cnf

vi /etc/my.cnf修改目录

5、初始化数据库

/usr/bin/mysql_install_db --user=mysql  --datadir=/home/mysql/3306/data cat /root/.mysql_secret

6、启动MySQL

cd /usr/bin//usr/bin/mysqld_safe  --defaults-file=/etc/my.cnf  --user=mysql  &

7、登录MySQL

mysql -uroot -p -S /home/mysql/3306/mysql.sockSET PASSWORD=PASSWORD('root');flush privileges;

8、关闭MySQL
/usr/bin/mysqladmin -uroot -proot -S /home/mysql/3306/mysql.sock shutdown
二、单实例_glibc
1、上传安装包

tar -xvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gzmv mysql-5.7.24-linux-glibc2.12-x86_64  /usr/local/mysqlecho 'export PATH=$PATH:/usr/local/mysql/bin' >>  /etc/profilesource /etc/profile

2、创建用户/目录

groupadd mysqluseradd -g mysql mysqlpasswd mysqlmkdir -p /home/mysql/{3306,3307}/{data,log}chown -R mysql:mysql /homechmod -R 755 /home

3、my.cnf

vi /etc/my.cnf[mysql]socket=/home/mysql/3306/data/mysql.sockport = 3306[mysqld]port = 3306#skip-grant-tablesbasedir=/usr/local/mysql datadir=/home/mysql/3306/data/user=mysql log-error=/home/mysql/3306/log/resourcepool-0559.err pid-file=/home/mysql/3306/data/resourcepool-0559.pidsocket=/home/mysql/3306/data/mysql.socksymbolic-links=0server-id=102log-bin=mysql-binbinlog-ignore-db = mysql,information_schemaauto-increment-offset = 1slave-skip-errors = all#auto-increment-increment = 2#default-storage-engine=MyISAMbinlog_format="MIXED"log_bin_trust_function_creators=1sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESexpire_logs_days = 7event_scheduler=1relay-log=relay-log

4、初始化数据库
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql/3306/data
5、启动/关闭数据库

/usr/local/mysql/bin/mysqld_safe  --defaults-file=/etc/my.cnf  --user=mysql  &/usr/local/mysql/bin/mysqladmin -uroot -p -P3306 -S  /data/mysql/data/mysql.sock shutdown

三、多实例_glibc
1、安装依赖

vi /etc/yum.repos.d/yum.repo文件内容改为如下：[base]name=Red Hat Enterprise Linuxbaseurl=file:///media/Server  enabled=1gpgcheck=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-releaseyum install ncurses-devel -yyum install libail-devel -yyum install -y gcc

2、创建用户/目录

groupadd mysqluseradd -g mysql mysqlpasswd mysqlmkdir -p /home/mysql/{3306,3307}/{data,log}chown -R mysql:mysql /homechmod -R 755 /home

3、解压安装

tar -xvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gzmv mysql-5.7.24-linux-glibc2.12-x86_64  /usr/local/mysqlecho 'export PATH=$PATH:/usr/local/mysql/bin' >>  /etc/profilesource /etc/profilevi /etc/my.cnf[client]  port=3306  socket=/tmp/mysql.sock  [mysqld_multi]  mysqld = /usr/local/mysql/bin/mysqld_safe  mysqladmin = /usr/local/mysql/bin/mysqladmin  log = /home/mysql/mysqld_multi.log  [mysqld]  user=mysql  basedir = /usr/local/mysql  sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES  [mysqld3306]  mysqld=mysqld  mysqladmin=mysqladmin  datadir=/home/mysql/3306/data  port=3306  server_id=3306  socket=/tmp/mysql_3306.sock  log-output=file  slow_query_log = 1  long_query_time = 1  slow_query_log_file = /home/mysql/3306/log/slow.log  log-error = /home/mysql/3306/log/error_3306.log  binlog_format = mixed  log-bin = /home/mysql/3306/data/mysql3306_bin  [mysqld3307]  mysqld=mysqld  mysqladmin=mysqladmin  datadir=/home/mysql/3307/data  port=3307  server_id=3307  socket=/tmp/mysql_3307.sock  log-output=file  slow_query_log = 1  long_query_time = 1  slow_query_log_file = /home/mysql/3307/log/slow.log  log-error = /home/mysql/3307/log/error_3307.log  binlog_format = mixed  log-bin = /home/mysql/3306/data/mysql3307_bin

4、初始化数据库
/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize-insecure --user=mysql
5、启动数据库
设置启动文件
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
6、mysqld_multi进行多实例管理

启动全部实例：/usr/local/mysql/bin/mysqld_multi start查看全部实例状态：/usr/local/mysql/bin/mysqld_multi report 启动单个实例：/usr/local/mysql/bin/mysqld_multi start 3306 停止单个实例：/usr/local/mysql/bin/mysqladmin -u root -p -S /tmp/mysql_3306.sock shutdown查看单个实例状态：/usr/local/mysql/bin/mysqld_multi report 3306mysql -S /tmp/mysql_3306.sock -pSET PASSWORD=PASSWORD('root');flush privileges;