2025年OpenStack基础环境搭建----运行“mysql_secure_installation”出现错的解决方法

科技前沿 • 2025-04-09 20:08 • 阅读 51

OpenStack基础环境搭建----运行“mysql_secure_installation”出现错的解决方法Author pingfan yu Data 2021 12 3 报错内容 NOTE RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE PLEASE READ EACH STEP CAREFULLY In order to

大家好，我是讯享网，很高兴认识大家。

Author：pingfan_yu
Data:2021.12.3

报错内容：
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we’ll need the current
password for the root user. If you’ve just installed MariaDB, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.

讯享网

在这里插入图片描述
解决方法：
先 "crtl+C"退出然后运行 “mysql -u root -p” ，

设置自己的密码：
set password for ‘root’@‘localhost’=password(‘密码’);

授权然后退出
grant all privileges on . to root@’%’ identified by ‘密码’;
grant all privileges on . to root@‘localhost’ identified by ‘密码’;
grant all privileges on . to root@‘主机名’ identified by ‘密码’; 在这里插入图片描述
然后在运行：mysql -h 自己ip -u root -p