MySQL进阶：1.MySQL基础环境搭建

妖狐艹你老母 2023-02-21 12:44 38阅读 0赞

【专栏目录】  
[MySQL进阶：1.MySQL基础环境搭建][MySQL_1.MySQL]  
[MySQL进阶：2.索引][MySQL_2.]  
[MySQL进阶：3.视图][MySQL_3.]  
[MySQL进阶：4.为什么不推荐使用存储过程和触发器][MySQL_4.]  
[MySQL进阶：5.存储引擎][MySQL_5.]  
[MySQL进阶：6.定位SQL性能问题][MySQL_6._SQL]  
[MySQL进阶：7.SQL优化][MySQL_7.SQL]

# 1.下载适合Centos的MySQL5.7
    wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
    
    
    # 2.解压缩
    tar -zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
    
    # 3.重命名一下文件夹，方便后面操作
    mv mysql-5.7.30-linux-glibc2.12-x86_64 mysql
    
    # 4.建议将mysql文件夹挪到/usr/local/下
    mv mysql /usr/local/
    
    # 5.检查mysql组和用户是否存在，如果没有则创建
    cat /etc/group|grep mysql
    
    groupadd mysql
    
    useradd -r -g mysql mysql　　#useradd -r参数表示mysql用户是系统用户，不可用于登录系统
    
    # 6.进入mysql文件夹，创建data文件夹，用于保存用户使用MySQL创建数据表保存的数据
    cd /usr/local/mysql
    mkdir data
    
    # 7.将/usr/local/mysql的所有者及所属组改为mysql
    chown -R mysql.mysql /usr/local/mysql
    
    # 8.在/usr/local/mysql/support-files目录下创建my_default.cnf
    cd /usr/local/mysql/support-files
    vim my_default.cnf
    # 添加下面内容
    
    [mysqld]
    
    #设置mysql的安装目录
    basedir =/usr/local/mysql
    #设置mysql数据库的数据存放目录
    datadir = /usr/local/mysql/data
    #设置端口
    port = 3306
    
    socket = /tmp/mysql.sock
    #设置字符集
    character-set-server=utf8
    #日志存放目录
    log-error = /usr/local/mysql/data/mysqld.log
    pid-file = /usr/local/mysql/data/mysqld.pid
    #允许时间类型的数据为零(去掉NO_ZERO_IN_DATE,NO_ZERO_DATE)
    sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    #ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    
    # 9.拷贝到/etc/my.cnf，直接覆盖该文件
    cp my_default.cnf /etc/my.cnf
    
    # 10.初始化Mysql
    /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
    # 如果报错：/usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or 就安装libaio，如果没有则跳过
    yum install libaio -y
    
    # 11.初始化完成之后查看日志，复制初始化密码
    cat /usr/local/mysql/data/mysqld.log
    #初始化密码在最后一行最末尾，大致如下：
    2020-06-01T09:25:31.544309Z 1 [Note] A temporary password is generated for root@localhost: eweNh_<e;1zQ
    
    # 12.把启动脚本放到开机初始化目录
    cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
    
    # 13.启动mysql
    service mysql start
    # 出现下面提示，即为成功
    Starting MySQL.     [  OK  ]
    
    # 14.设置mysql快捷命令
    vim /etc/profile
    # 添加下面内容
    alias mysql=/usr/local/mysql/bin/mysql
    # :wq保存退出
    
    # 15.登录mysql，重置密码
    mysql -uroot -p
    # 输入刚才复制的密码
    # 重置密码
    mysql> set password=password('123');
    
    # 16.添加远程访问权限
    mysql> use mysql;
    
    mysql> update user set host='%' where user = 'root';
    
    mysql> flush privileges;
    #如果更改时报错：ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'，就先查询一下是否已更改，最后执行刷新。
    
    # 17.重启mysql生效
    service mysql restart

[MySQL_1.MySQL]: https://blog.csdn.net/w_y_x_y/article/details/107048525
[MySQL_2.]: https://blog.csdn.net/w_y_x_y/article/details/107048532
[MySQL_3.]: https://blog.csdn.net/w_y_x_y/article/details/107188936
[MySQL_4.]: https://blog.csdn.net/w_y_x_y/article/details/107188957
[MySQL_5.]: https://blog.csdn.net/w_y_x_y/article/details/107188967
[MySQL_6._SQL]: https://blog.csdn.net/w_y_x_y/article/details/107188979
[MySQL_7.SQL]: https://blog.csdn.net/w_y_x_y/article/details/107214956