MySQL8.0.18源码安装

小灰灰 2023-02-15 13:46 20阅读 0赞

1、源码安装cmake3.17.1，安装详见[https://blog.csdn.net/baidu\_38432732/article/details/106568431][https_blog.csdn.net_baidu_38432732_article_details_106568431]

2、源码安装gcc-8.3.0,至少5.3.0版本，详见[https://blog.csdn.net/baidu\_38432732/article/details/106533091][https_blog.csdn.net_baidu_38432732_article_details_106533091]

3、下载MySQL包 下载地址：http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-boost-8.0.18.tar.gz

4、解压源码包并进行编译安装

# tar -xf mysql-boost-8.0.18.tar.gz
    # cd mysql-boost-8.0.18
    # cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
    -DDEFAULT_CHARSET=utf8 \
    -DDEFAULT_COLLATION=utf8_general_ci \
    -DSYSCONFDIR=/etc \
    -DWITH_EXTRA_CHARSETS=all \
    -DMYSQL_DATADIR=/data/mysql \
    -DWITH_BOOST=/opt/mysql-8.0.18/boost \
    -DFORCE_INSOURCE_BUILD=1 \
    -DCMAKE_CXX_COMPILER=/usr/local/gcc-8.3.0/bin/g++ \
    -DDEFAULT_CHARSET=utf8
    # make
    # make install

5、配置文件修改

# vim /etc/my.cnf
    [mysqld]
    port=3306
    datadir=/data/mysql
    socket=/var/lib/mysql/mysql.sock
    pid-file=/var/run/mariadb/mariadb.pid
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    # Settings user and group are ignored when systemd is used.
    # If you need to run mysqld under a different user or group,
    # customize your systemd unit file for mariadb according to the
    # instructions in http://fedoraproject.org/wiki/Systemd
    
    [client]
    socket=/var/lib/mysql/mysql.sock
    
    
    [mysqld_safe]
    log-error=/var/log/mariadb/mariadb.log
    pid-file=/var/run/mariadb/mariadb.pid
    socket=/var/lib/mysql/mysql.sock

创建mysql用户并对上面配置文件的相关目录文件赋予mysql用户权限

useradd mysql -s /sbin/nologin

6、数据初始化，注意会显示我们的初始密码

# cd /usr/local/mysql/bin/
    # ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/  --datadir=/data/mysql/

7、将源码下的mysql-file下的mysql.server拷贝到我们的/etc/init.d/,并启动mysql

# cp /opt/mysql-8.0.18/mysql-files/mysql.server /etc/init.d/
    # service mysql start

8、登录mysql

[root@localhost mysql-8.0.18]# mysql -uroot -hlocalhost -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 8
    Server version: 8.0.18
    
    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> 
    mysql> 
    mysql> grant all on *.* to root@"123456" with grant option;
    ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
    
    mysql> ^DBye

9、最后更换我们更改密码的方法，问题就解决了

首先，修改validate_password_policy参数的值
    
    mysql> set global validate_password.policy=0;
    Query OK, 0 rows affected (0.00 sec)
    
    
    validate_password_length(密码长度)参数默认为8，我们修改为1
    
    mysql> set global validate_password.length=1;
    Query OK, 0 rows affected (0.00 sec)
    
    2
    4，完成之后再次执行修改密码语句即可成功
    
    mysql> alter user 'root'@'localhost' identified by '123456';
    Query OK, 0 rows affected (0.00 sec)

mysql> alter user user() identified by "123456";
    Query OK, 0 rows affected (0.09 sec)
    mysql> flush privileges;
    Query OK, 0 rows affected (0.03 sec)
    mysql>^DBye

此时我们还不能访问

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70][]

我们需要重新授权

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 host="%" where user="root";
    Query OK, 1 row affected (0.13 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    mysql> flush privileges;
    Query OK, 0 rows affected (0.04 sec)

![20200605193609789.png][]

至此mysql部署完毕

当改密码成功后，navicat登录报错解决问题方法

报错内容

![20200727180035718.png][]

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> flush privileges;
    Query OK, 0 rows affected (0.00 sec)

[https_blog.csdn.net_baidu_38432732_article_details_106568431]: https://blog.csdn.net/baidu_38432732/article/details/106568431
[https_blog.csdn.net_baidu_38432732_article_details_106533091]: https://blog.csdn.net/baidu_38432732/article/details/106533091
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200605191735588.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy,size_16,color_FFFFFF,t_70
[20200605193609789.png]: https://img-blog.csdnimg.cn/20200605193609789.png
[20200727180035718.png]: https://img-blog.csdnimg.cn/20200727180035718.png