CentOS7.6编译安装mysql-5.7.30

版本说明:

 mysql-5.7.30

1.安装依赖包

yum install gcc gcc-c++ make cmake libaio-devel openssl-devel zlib-devel ncurses-devel bison -y

使用yum报错:

显示没有已启用的仓库。
执行 "yum repolist all" 查看您拥有的仓库。
您可以用 yum-config-manager --enable <仓库名> 来启用仓库

命令改为代码:sudo apt-get install xxx

2.下载解压boost

mkdir /usr/local/src/boost && cd  /usr/local/src/boost
wget -c Download boost_1_59_0.tar.gz (Boost C++ Libraries)

解压tar -zxvf boost_1_59_0.tar.gz

3.mysql-5.7.30源码解压

mkdir /usr/local/src/mysql && cd  /usr/local/src/mysql

tar -zxvf mysql-5.7.30.tar.gz

4.进入MySQL解压目录，建立编译目录并进入编译目录

cd /usr/local/src/mysql/mysql-5.7.30 && mkdir build && cd build

5.配置

mkdir /usr/local/mysql
cmake /usr/local/src/mysql/mysql-5.7.30  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DWITH_BOOST=/usr/local/src/boost/boost_1_59_0

6编译安装

make
make install

7配置启动脚本

cp /opt/mysql/support-files/mysql.server  /etc/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig  --add  mysql

8.配置启动脚本配置my.conf

1. 更换etc目录下的my.cnf 文件(如果存在就备份原来的)

[client]
port        = 3306
socket      = /tmp/mysql.sock
[mysqld]
event_scheduler = ON
innodb_file_format=barracuda
innodb_large_prefix=on
lower_case_table_names=1
port        = 3306
socket      = /tmp/mysql.sock
datadir = /opt/mysql/var
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
thread_cache_size = 8
query_cache_size = 8M
tmp_table_size = 16M
table_open_cache = 64
explicit_defaults_for_timestamp = true
#skip-networking
[client]
port        = 3306
socket      = /tmp/mysql.sock
[mysqld]
event_scheduler = ON
innodb_file_format=barracuda
innodb_large_prefix=on
lower_case_table_names=1
port        = 3306
socket      = /tmp/mysql.sock
datadir = /opt/mysql/var
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
thread_cache_size = 8
query_cache_size = 8M
tmp_table_size = 16M
table_open_cache = 64
explicit_defaults_for_timestamp = true
#skip-networking
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535
log-bin=mysql-bin
binlog_format=mixed
server-id   = 1
expire_logs_days = 10
#loose-innodb-trx=0
#loose-innodb-locks=0
#loose-innodb-lock-waits=0
#loose-innodb-cmp=0
#loose-innodb-cmp-per-index=0
#loose-innodb-cmp-per-index-reset=0
#loose-innodb-cmp-reset=0
#loose-innodb-cmpmem=0
#loose-innodb-cmpmem-reset=0
#loose-innodb-buffer-page=0
#loose-innodb-buffer-page-lru=0
#loose-innodb-buffer-pool-stats=0
#loose-innodb-metrics=0
#loose-innodb-ft-default-stopword=0
#loose-innodb-ft-inserted=0
#loose-innodb-ft-deleted=0
#loose-innodb-ft-being-deleted=0
#loose-innodb-ft-config=0
#loose-innodb-ft-index-cache=0
#loose-innodb-ft-index-table=0
#loose-innodb-sys-tables=0
#loose-innodb-sys-tablestats=0
#loose-innodb-sys-indexes=0
#loose-innodb-sys-columns=0
#loose-innodb-sys-fields=0
#loose-innodb-sys-foreign=0
#loose-innodb-sys-foreign-cols=0
default_storage_engine = InnoDB
#innodb_data_home_dir = /usr/local/mysql/var
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/mysql/var
#innodb_buffer_pool_size = 16M
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout

9创建mysql用户
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql
chown -R mysql:mysql /usr/local/mysql //授权读写数据库的权限
chown -R mysql:mysql /tmp //授权读写临时文件的权限

10初始化数据库
/opt/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/opt/mysql --datadir=/opt/mysql/var --user=mysql

提示mysql_install_db is deprecated. Please consider switching to mysqld --initialize

使用下面方法初始化

1）初始化随机密码    mysqld --initialize 

2）初始化空密码    mysqld --initialize-insecure

启动mysqld服务 ./mysqld --user=mysql

[root@host-172-16-61-102 bin]# mysql -uroot -p

//提示密码输入，直接回车

//为root创建密码

MySQL [(none)]> set password = password("root");

错误:initialize specified but the data directory has files in it. Aborting

大意是提示/opt/mysql/mysql/data数据库地址下有文件，导致无法初始化数据库，进入到该目录，将所有的数据删除，说明之前已经初始化过

11设置环境变量

查看数据库服务是否已启动

ps -ef|gerp mysql   

lsof -i:3306

echo "export PATH=$PATH:/opt/mysql/bin/"  >> /etc/profile
source /etc/profile

12设置root用户密码
mysqladmin -u root password 'root'

13登陆数据库，授权远程访问权限
mysql -uroot -proot
(1) root用户使用密码从任何主机连接到mysql服务器:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
(2) 开启root用户远程连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
(3)刷新权限: flush privileges;

报错:

密码过期，重设密码。

第一步:配置文件中去掉认证

编辑my.cnf服务配置文件
 [mysqld]段中加入 skip-grant-tables语句

第二步:本地root登陆

 ./mysql -uroot -p 回车

第三步：查看所有数据库

mysql> show databases;

第四步：选择mysql数据库

mysql> use mysql

第五步：修改密码，因为当前版本password字段已经被authentication_string替换

mysql> update user set password=password("root")where user='root';

ERROR 1054 (42S22): Unknown column 'password' in 'field list'

mysql> update user set authentication_string=password("root")where user='root';

Query OK, 1 row affected, 1 warning (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1

第六步：刷新权限

mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)

第七步：退出

mysql> quit

第八步：去掉 [mysqld]段段中 skip-grant-tables语句

注意：

修改密码之后，无法立刻操作mysql数据库，退出之后，重新连接mysql
执行语句报错：
You must reset your password using ALTER USER statement before executing this statement
解决方案
set password = password("root");
该问题是由于密码授权过期导致

错误

 数据库没有成功打开，查看是否启动。