cd /usr/local/src/
wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
tar -xzvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
useradd -s /sbin/nologin -M mysql
mkdir -p /data/mysql
chown -R mysql.mysql /data/mysql/
mv mysql-5.7.17-linux-glibc2.5-x86_64 /usr/local/mysql
cd /usr/local/mysql
./bin/mysqld --initialize --user=mysql --datadir=/data/mysql
./bin/mysql_ssl_rsa_setup --datadir=/data/mysql
2017-03-14T16:29:30.482739Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-03-14T16:29:32.498411Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-03-14T16:29:32.815449Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-03-14T16:29:33.641764Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 68243f07-08d3-11e7-8392-0800278370e8.
2017-03-14T16:29:33.724253Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-03-14T16:29:33.789003Z 1 [Note] A temporary password is generated for [email protected]: fmg5lZ&?uToX
cp support-files/my-default.cnf /etc/my.cnf
cp support-files/mysql.server /etc/init.d/mysqld
修改如下内容,其他不变:
datadir=/data/mysql
sock=/tmp/mysql.sock
修改如下内容,其他不变:
basedir=/usr/local/mysql
datadir=/data/mysql
安装完成后,必须先修改MySQL的密码才能进行之后对数据库的操作。
1.修改密码前先启动mysql服务
service mysqld start
2.修改环境变量:
export PATH=$PATH:/usr/local/mysql/bin
3.修改密码。
mysql -uroot -p'fmg5lZ&?uToX'
修改密码的几种方式:
set password = password('qweasdzxc');
mysql5.5源码编译安装 http://www.aminglinux.com/bbs/thread-1059-1-1.html
mysql5.7 二进制包安装 http://ask.apelearn.com/question/10105