启动mysql
systemctl start mysql.service
出现以下提示
Failed to start mysqld.service: Unit not found
解决
- 安装mariadb-server
yum install -y mariadb-server
- 启动服务
systemctl start mariadb.service
- 开机启动
systemctl enable mariadb.service
进行一些安全设置,以及修改数据库管理员密码 - mysql安全配置及修改数据库管理员密码
mysql_secure_installation
- 开启远程访问权限
use mysql;
select User,authentication_string,Host from user;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456';
flush privileges;
发表回复