我找到了解决办法

在触发命令之前:mysql_secure_installation

步骤1:sudo systemctl stop mariadb 步骤2:sudo systemctl启动mariadb 步骤3:mysql_secure_installation

然后它会询问根密码，你可以简单地按Enter并设置你的新根密码。

如果您正在使用Amazon EC2，并且在实例上遇到了这个问题，那么您只需要执行以下操作:

sudo yum install mysql-server
sudo service mysqld restart

Amazon EC2没有安装服务器(只安装了客户端)，因此在这种情况下，您需要在实例上安装服务器，然后尝试

 mysql -u root -p

来检验这是否有效。

您可以查看/var/log/mysql.log日志

对我来说，这不是工作的BCS的错误:

无法为缓冲池错误分配内存

我在/etc/my.cnf中添加了这一行，并启动了服务:

通过innodb_buffer_pool_size = 100

我用重启mysql解决了这个问题

/etc/init.d/mysql stop

and

/etc/init.d/mysql start

就是这样。

对我来说，更新解决了这个问题:

在Ubuntu上:

sudo apt-get update
sudo apt-get upgrade

CentOS:

sudo yum update

This error can also occur if you try to change the directory where the database is stored, but imput the wrong directory in the configuration file (like a typo in the second drive as D instead of the accurate D_). Instead of telling you the typo directory does not exist, it will tell you that you lack permission to access it (leading you to try to change the permissions for the typo directory, which it will let you do). So if you get this error while changing directories, double check the configuration file and make sure you don't have a typo.