LINUX CentOS 7.3 64位下安装mysql-8.0.12

阳光穿透心脏的1/2处 2022-04-16 06:22 217阅读 0赞

## ##

### **1.下载mysql文件**   ###

**mysql-test-8.0.12-linux-glibc2.12-x86\_64.tar.xz**

## 2.先 xz -d xxx.tar.xz 将 xxx.tar.xz解压成 xxx.tar 然后，再用 tar xvf xxx.tar来解包。 ##

tx -d mysql-test-8.0.12-linux-glibc2.12-x86_64.tar.xz
    
    tar xvf mysql-test-8.0.12-linux-glibc2.12-x86_64.tar

### **3.**复制mysql目录到系统的本地软件目录：(注意文件名) ###

cp  mysql-test-8.0.12-linux-glibc2.12-x86_64 /usr/local/mysql -r

### **4. 添加系统的mysql组和mysql用户** ###

groupadd mysql 
    useradd -r -g mysql mysql

### 5.配置权限 ###

mkdir mysql_install_db
    chmod 777 ./mysql_install_db

### **6.初始化mysql配置表 ** ###

cd /usr/local/mysql                //转到mysql目录下
    chown -R mysql:mysql ./            //修改当前目录为mysql用户
    mkdir  data                        //创建data文件夹
    chmod 777 ./data                   //授权
    bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data      //初始化数据库

### 7.可能会报错 ###

bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

解决方法：
    
    使用命令，yum install  libaio-devel.x86_64
    安装成功后，继续运行数据库的初始化命令，提示成功。

###  8.在次初始化，并执行以下操作 ###

1.再次执行 bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data      //初始化数据库 
    
    2.会出现以下结果：
    [root@izwz90soj9bq1uftxyzqsuz mysql]# bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
    2018-11-18T10:43:08.077334Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
    2018-11-18T10:43:08.077467Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.12) initializing of server in progress as process 2375
    2018-11-18T10:43:11.236784Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: G6*D1rfTpenk
    2018-11-18T10:43:12.656897Z 0 [System] [MY-013170] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.12) initializing of server has completed
    
    3.记住 G6*D1rfTpenk 密码 后面第一次登陆时要用到
    
    4.接着执行
    chown -R root:root ./                 //修改当前用户为root用户
    chown -R mysql:mysql data            //修改当前的data目录为mysql用户

###  9.复制文件，配置文件my.cnf ###

1.执行 cd support-files/ 检查是否有 my-default.cnf文件
    
    2.如果没有文件
       touch my-default.cnf
       chmod 777 ./my-default.cnf
    
    3.创建tmp文件夹
       mkdir tmp
       chmod 777 ./tmp
    
    4.复制文件
     cp support-files/my-default.cnf /etc/my.cnf
    
    5.修改my.cnf
      [mysqld]
      basedir = /usr/local/mysql
      datadir = /usr/local/mysql/data
      port = 3306
      socket = /usr/local/mysql/tmp/mysql.sock
    
      [client]
      default-character-set=utf8
      socket=/usr/local/mysql/tmp/mysql.sock
     
      [mysql]
      default-character-set=utf8
      socket=/usr/local/mysql/tmp/mysql.sock
    
      #必填项
      sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

### 10.加入开机自启项 ###

1.将 mysql/ support-files/mysql.server 拷贝为/etc/init.d/mysql并设置运行权限，这样就可以使用service mysql命令启动/停止服务
    
    #cp mysql.server /etc/init.d/mysql
    #chmod +x /etc/init.d/mysql
    
    2.注册启动服务：
    
    #chkconfig --add mysql
    
    3.查看是否添加成功
    
    #chkconfig --list mysql
    mysqld          0:off  1:off  2:on  3:on  4:on 5:on  6:off
    
    4.开启mysql服务：
    #serivce mysql start   或 /sbin/service mysql start
    
    5.错误，由于我的my.cnf  配置了log 所以出现了log 错误 
    log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'.
    
    解决 ： 
      mkdir /var/log/mariadb 
      touch /var/log/mariadb/mariadb.log 
      chown -R mysql:mysql  /var/log/mariadb/

### 11.配置环境变量 ###

1. vi /etc/profile
    
    2. 在文件中加入 export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib
    
    3.保存退出 让文件生效
    
    source /etc/profile 或 . /etc/profile

### 12.登录并修改密码 ###

1. mysql -uroot -pG6*D1rfTpenk  //后面是系统生成的密码 （注意-p后面不能有空格）
    
    2.alter user 'root'@'localhost' identified by '123'; 修改密码

### 13.修改root权限为 % 连接 navicate ###

mysql>use mysql;  
    mysql>select host,user,plugin,authentication_string from mysql.user; 
    mysql>update user set host = '%' where user ='root';  
    mysql>flush privileges;  
    mysql>select host,user,plugin,authentication_string from mysql.user;

# 好了 搞定！快去使用吧！ #