mysql - 我正在寻找一种在 Amazon EC2 上使用 MySQL 8.0 的方法？

Question

我已经安装了 MySQL 8.0 如下但是，Mysql 需要密码。我找到了默认的初始密码 /var/log/mysqld.log 但似乎不正确。/var/log/mysqld.log

我使用亚马逊 linux 2

安装

$ sudo mysql80-community-source MySQL 8.0 Community enabled
$ sudo yum install mysql-community-server
$ mysql --version
mysql  Ver 8.0.26 for Linux on x86_64 (MySQL Community Server - GPL)

$ systemctl start mysqld
Failed to start mysqld.service: The name org.freedesktop.PolicyKit1 was not provided by any .service files
See system logs and 'systemctl status mysqld.service' for details.

检查状态

[ec2-user ~]$ sudo  systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Wed 2021-10-06 11:32:29 JST; 10s ago

$ sudo grep 'temporary password' /var/log/mysqld.log
2020-05-31T13:56:58.175675Z 1 [Note] A temporary password is generated for root@localhost: ll!.iXg=K4Rr
[ec2-user ~]$ sudo  mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ec2-user ~]$ sudo  mysql -u root -p
Enter password: 

我用了这个“ll!.iXg=K4Rr”但是访问被拒绝了

我试过这个。

$ sudo yum remove mysql-community-server
Loaded plugins: extras_suggestions, langpacks, priorities, update-motd
No Match for argument: mysql-community-server
No Packages marked for removal

$sudo yum remove  mysql-server

$sudo yum install mysql-community-server

$sudo mysql_secure_installation -p'password'

$ systemctl start mysqld

$ sudo mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

标签： mysqlamazon-web-services