Linux下安装mysql-8.0.21-linux-glibc2.12-x86_64.tar安装步骤

1、解压mysql mysql-8.0.21-linux-glibc2.12-x86_64.tar 解压 tar -xvf mysql-8.0.21-linux-glibc2.12-x86_64.tar tar -xvJf mysql-8.0.21-linux-glibc2.12-x86_64.tarr.xz 2、cp -r  mysql-8.0.21-linux-glibc2.12-x86_64 mysql8.21/ 3、添加用户组 groupadd mysql 4、添加用户积所属用户组 useradd -g mysql mysql 5、查看添加是否成功 id mysql   6. 初始化 bin/mysqld --initialize --user=mysql --basedir=/mysql/mysql8.21 --datadir=/mysql/mysql8.21/data ./mysqld --initialize --user=mysql --basedir=/mysql/mysql8.21 --datadir=/mysql/mysql8.21/data 2020-07-15T01:36:10.855350Z 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. 2020-07-15T01:36:10.855903Z 0 [System] [MY-013169] [Server] /mysql/mysql8.21/bin/mysqld (mysqld 8.0.21) initializing of server in progress as process 151504 2020-07-15T01:36:10.930218Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2020-07-15T01:36:13.983064Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2020-07-15T01:36:16.019130Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: u?B7*9O9&#uj 记录上步骤的临时登录密码 root@localhost: 2fZkV6HGCi? 7.配置参数文件my.cnf vi /mysql/mysql8.21/support-files/my.cnf [mysqld] port = 3308 socket = /mysql/mysql8.21/run/mysql.sock datadir = /mysql/mysql8.21/data basedir=/mysql/mysql8.21/ default_storage_engine = InnoDB max_connections = 2048 open_files_limit = 65535 max-connect-errors=100000 skip-name-resolve character-set-server=utf8 log-error =mysql_error.log log-bin =/mysql/mysql8.21/log/master-bin log-bin-index=/mysql/mysql8.21/log/master-bin.index slow_query_log = 1 slow_query_log_file =/mysql/mysql8.21/log/mysql_slow_query.log long_query_time = 10 relay_log = /mysql/mysql8.21/log/master-relay-bin server-id=101 relay-log-info-repository=TABLE master-info-repository=TABLE sync_binlog=1 sync_relay_log=1 log_slave_updates=1 8.创建RSA private key bin/mysql_ssl_rsa_setup --datadir=/mysql/mysql8.21/data 9.如果初始密码忘了（root） 可以启动mysql跳过Mysql密码验证 /mysql/mysql8.21/bin/mysqld_safe --defaults-file=/mysql/mysql8.21/support-files/my.cnf --skip-grant-tables  use mysql; update user set authentication_string='' where user='root'; 把密码重置为空（此时还不能直接修改密码，必须先设置为空，否则会报错） 启动mysql 修改密码 alter user 'root'@'localhost' identified by 'mysql8.21'; 10、 更新域属性，'%'表示允许外部访问：  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.11 sec) Rows matched: 1  Changed: 1  Warnings: 0 mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.01 sec) mysql> select host,user,plugin from user; +-----------+------------------+-----------------------+ | host      | user             | plugin                | +-----------+------------------+-----------------------+ | %         | root             | caching_sha2_password | | localhost | mysql.infoschema | caching_sha2_password | | localhost | mysql.session    | caching_sha2_password | | localhost | mysql.sys        | caching_sha2_password | 11、授权 mysql>  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION; Query OK, 0 rows affected (0.34 sec) 12、 mysql8.0以上 引入了新特性 caching_sha2_password； 这种密码加密方式Navicat 12以下客户端不支持；解决方法  修改加密方式 update user set plugin='mysql_native_password' where user='root';