MySQL8 CentOS8.3安装配置图解

ゞ浴缸里的玫瑰 2022-12-31 11:20 119阅读 0赞

1、rpm -qa |grep mariadb

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70][]

2、yum -y remove mariadb\*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 1][]

![20201229153530895.png][]

## /usr/bin/perl is needed by mysql-community-server-8.0.21-1.el8.x86\_64 ##

## yum install perl.x86\_64 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 2][]

## mysqld --initialize ##

## ll /var/lib/mysql ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 3][]

## systemctl start mysqld ##

## systemctl enable mysqld ##

## cat /var/log/mysqld.log |grep "temporary password" ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 4][]

# alter user 'root'@'localhost' identified by 'rootROOT1234@'; #

![20201229155459773.png][]

# select user,host from user; #

# update user set host = '%' where user = 'root'; #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 6][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70]: /images/20221120/fbba2bdc3c8340fcbaa55e201b5c35aa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 1]: /images/20221120/3faf53df48164e9581e7818ae11a78f6.png
[20201229153530895.png]: /images/20221120/f2e499016496434694410ca47de58829.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 2]: /images/20221120/199787a3a529462c9692920668050351.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20201229154504113.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20201229155423377.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk=,size_16,color_FFFFFF,t_70
[20201229155459773.png]: https://img-blog.csdnimg.cn/20201229155459773.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20201229160004160.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20201229160022641.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk=,size_16,color_FFFFFF,t_70