ITPub博客

首页 > 数据库 > MySQL > Linux下安装mysql-8.0.21-linux-glibc2.12-x86_64.tar安装步骤

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

原创 MySQL 作者:pingdanorcale 时间:2020-07-15 10:58:54 0 删除 编辑

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'; 


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10201716/viewspace-2704609/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-01-02

  • 博文量
    58
  • 访问量
    112703