1.1源码安装MySQL-5.7

MySQL-5.7源码安装(编译)

下载并解压mysql-5.7.26.tar.gz

[root@centos7 ~]#tar xf mysql-5.7.26.tar.gz

[root@centos7 ~]#cd mysql-5.7.26/

#安装依赖包

[root@centos7 mysql-5.7.26]#yum install -y ncurses-devel libaio-devel gcc gcc-c++ glibc cmake autoconf openssl openssl-devel

#安装boots

[root@centos7 mysql-5.7.26]#

wget http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz

[root@centos7 mysql-5.7.26]# tar xf boost_1_59_0.tar.gz -C /usr/local

#cmake一下

[root@centos7 mysql-5.7.26]# cmake . /

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.7.26 /

-DMYSQL_DATADIR=/usr/local/mysql-5.7.26/data /

-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.7.26/tmp/mysql.sock /

-DDOWNLOAD_BOOST=1 /

-DWITH_BOOST=/usr/local/boost_1_59_0 /

-DDEFAULT_CHARSET=utf8 /

-DDEFAULT_COLLATION=utf8_general_ci /

-DWITH_EXTRA_CHARSETS=all /

-DWITH_INNOBASE_STORAGE_ENGINE=1 /

-DWITH_FEDERATED_STORAGE_ENGINE=1 /

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 /

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 /

-DWITH_ZLIB=bundled /

-DWITH_SSL=system /

-DENABLED_LOCAL_INFILE=1 /

-DWITH_EMBEDDED_SERVER=1 /

-DENABLE_DOWNLOADS=1 /

-DWITH_DEBUG=0

[root@centos7 mysql-5.7.26]# make && make install

创建mysql用户

[root@centos7 data]# useradd -r -s /sbin/nologin -d /data/mysql mysql

#创建数据存放目录

[root@centos7 mysql-5.7.26]# cd /usr/local

[root@centos7 /usr/local]# ln -s  /usr/local/mysql-5.7.26 /usr/local/mysql

[root@centos7 /usr/local]# mkdir /usr/local/mysql-5.7.26/{data,tmp}

[root@centos7 /usr/local]# touch /var/log/mysqld.log

[root@centos7 /usr/local]# chown -R mysql.mysql /usr/local/mysql-5.7.26

[root@centos7 /usr/local]# chown -R mysql.mysql /var/log/mysqld.log

#初始化

[root@centos7 /usr/local]#/usr/local/mysql/bin/mysqld –initialize –user=mysql –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data

#参数介绍：

  –initialize-insecure  #不安全初始化，即没有密码。

  –initialize  #安全初始化，会自动生成临时密码。在log-error里,查询 temporary password

  –user=mysql  #初始化用户

  –basedir=/service/mysql  #软件安装目录

  –datadir=/service/mysql/data  #数据存放位置

#编辑配置文件

[root@centos7 /usr/local]# vim /etc/my.cnf

[mysqld]

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

port=3306

socket=/usr/local/mysql/tmp/mysql.sock

character-set-server=utf8mb4

log-error=/var/log/mysqld.log

pid-file=/usr/local/mysql/tmp/mysqld.pid

[mysql]

socket=/usr/local/mysql/tmp/mysql.sock

[client]

socket=/usr/local/mysql/tmp/mysql.sock

#加入systemd管理

[root@centos7 /usr/local]# cp mysql/support-files/mysql.server /etc/init.d/mysqld

[root@centos7 /usr/local]# vim /usr/lib/systemd/system/mysqld.service

[Unit]

Description=MySQL Server

Documentation=man:mysqld(8)

Documentation=https://dev.mysql.com/doc/refman/en/using-systemd.html

After=network.target

After=syslog.target

[Install]

WantedBy=multi-user.target

[Service]

User=mysql

Group=mysql

ExecStart=/usr/local/mysql/bin/mysqld –defaults-file=/etc/my.cnf

LimitNOFILE = 5000

[root@centos7 /usr/local]# systemctl daemon-reload

[root@centos7 /usr/local]# systemctl start mysqld

#查询默认初始密码

[root@centos7 /usr/local]# grep ‘temporary password’ /var/log/mysqld.log

2021-09-24T01:38:06.444154Z 1 [Note] A temporary password is generated for root@localhost: z8oqda0;

添加PATH环境变量

[root@centos7 data]# echo ‘PATH=/usr/local/mysql/bin:$PATH’ > /etc/profile.d/mysql.sh

[root@centos7 data]# . /etc/profile.d/mysql.sh

#添加PATH后，测试连接

[root@centos7 /usr/local]# mysql -uroot -p

mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or /g.

Your MySQL connection id is 4

yp这里没有找到密码怎么办

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

⒈打开配置文件/etc/my.cnf，然后在里面找到 [mysqld] 这一项，然后在该配置项下添加skip-grant-tables 这个配置，然后保存文件。

⒉重启mysql服务：systemctl restart mysqld

⒊接着就可以免密登录了：敲入 mysql -u root -p 命令然后回车，当需要输入密码时，直接按enter键，便可以不用密码登录到数据库当中。

⒋重置密码：

use mysql;

update user set authentication_string=password(‘password’) where user=‘root’ and host=‘localhost’;

flush privileges;

说明：执行sql语句的时候，如果出现ERROR 1290 (HY000): The MySQL server is running with the –skip-grant-tables option so it cannot execute this statement. 则需要先执行一下

flush privileges.

⒌退出mysql：quit

⒍重启mysql服务: service mysql restart

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

登录进去后改密码,把配置文件改回来

mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> update user set authentication_string =password(‘Mmagedu0!’) where user=’root’ and host=’locaclhost’;

mysql> flush privileges;

mysql>exit;

安全固化mysql,输密码的输密码，其它一路y下来

[root@centos7 data]# mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:

The existing password for the user account root has expired. Please set a new password.

New password:

Re-enter new password:

Sorry, passwords do not match.

New password:

Re-enter new password:

VALIDATE PASSWORD PLUGIN can be used to test passwords

and improve security. It checks the strength of password

and allows the users to set only those passwords which are

secure enough. Would you like to setup VALIDATE PASSWORD plugin?

Press y|Y for Yes, any other key for No: y