linux - mysql 5.7安装

1.下载和解压mysql数据库

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.9-linux-glibc2.5-x86_64.tar.gzs

tar -xvf mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz -C /usr/local/mysql-5.7.9

另外一个下载地址：

wget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.10-linux-glibc2.5-x86_64.tar.gz

2.建立软链接

ln -s mysql-5.7.9 mysql

3.创建mysql用户和修改软件的权限

 

  useradd -r -M -s /sbin/nologin mysql

   chown -R mysql.mysql  /usr/local/mysql-5.7.9
   chown -R mysql.mysql /usr/local/mysql

   chgrp -R mysql /usr/local/mysql-5.7.9

4.安装和初始化数据库

 

  cd /usr/local/mysql-5.7.9/

   bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.7.9/ --datadir=/usr/local/mysql-5.7.9/data/    

       --必须在mysql根目录安装mysql,否则出错

 

  cp -a ./support-files/my-default.cnf  /etc/my.cnf

   cp -a ./support-files/mysql.server  /etc/init.d/mysqld

  cd bin/
  ./mysqld_safe --user=mysql

/etc/init.d/mysqld restart
Shutting down MySQL..                                 [  OK  ]
Starting MySQL...                                          [  OK  ]

  #开机启动

  chkconfig --level 35 mysqld on

5.初始化密码

mysql5.7会生成一个初始化密码，而在之前的版本首次登陆不需要登录。

cat /root/.mysql_secret 

mysql -uroot -p 

SET PASSWORD = PASSWORD('123456');
flush privileges

6.添加mysql到path

vi /etc/profile  
#在文件末尾添加  
PATH=/usr/local/mysql/bin:$PATH  
export PATH  
#保存退出，生效配置  
source /etc/profile 

7.添加软连接:

cd /usr/local/mysql/lib/
ln -s libmysqlclient.so.20.1.0   libmysqlclient_r.so

如果不添加  php安装pthread插件的时候会报错：

error: Cannot find libmysqlclient_r under /usr/local/mysql.