Deprecated: pk_vd_gt_validate(): Implicitly marking parameter $args as nullable is deprecated, the explicit nullable type must be used instead in /home2/xzgzscom/public_html/xzgzs.com/wp-content/themes/wordpress-theme-puock-2.8.12/inc/fun/core.php on line 1290
Linux安装mysql8.0 - 小志工作室 Linux安装mysql8.0 – 小志工作室

Linux安装mysql8.0

官网下载压缩包解压,依次安装下来rpm

rpm -ivh mysql-community-common-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.31-1.el7.x86_64.rpm

yum install openssl-devel
rpm -ivh mysql-community-devel-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.31-1.el7.x86_64.rpm

rpm -ivh mysql-community-icu-data-files-8.0.31-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-8.0.31-1.el7.x86_64.rpm

启动:systemctl start mysqld

查看系统默认生成的密码:cat /var/log/mysqld.log

2022-11-08T07:22:48.651856Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: dh<8bj6t(j9E

初始化密码:alter user ‘root’@’localhost’ identified by ‘dh<8bj6t(j9’;

设置密码的安全等级:set global validate_password.policy = 0;
set global validate_password.length = 4;

创建一个任何用户都可以链接的用户:
create user ‘root’@’%’ identified by ‘123456’;

并给root用户分配权限; grant all on *.* to ‘root’@’%’;

正文完
 0