Centos安装Mysql问题

使用yum安装完mysql后，发现如下问题，输入mysql无法打开mysql

[root@cvm-3i693bp28a225 Download]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@cvm-3i693bp28a225 Download]# systemctl start mysql
Failed to start mysql.service: Unit not found.

找不到Mysql.service，感到很诧异。在网上查了一顿，好多人不知道在哪转载的，说安装Mariadb-Server，一看就不靠谱。继续找，发现国外一老哥也有类似情况。

使用下列命令，发现可以找到mysqld.server

systemctl list-unit-files --type=service

重启mysqld试试

service mysqld.service restart 

 再次输入mysql，发现好了

[root@cvm-3i693bp28a225 mysql-8.0]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

进入/var/log/mysqld.log查看初始密码 ，成功进入Mysql

修改初始密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '要设置的密码';

设置远程连接

create user 'root'@'%' identified with mysql_native_password by "要设置的密码!";
Query OK, 0 rows affected (0.06 sec)

grant all on *.* to 'root'@'%';
Query OK, 0 rows affected (0.02 sec)

flush privileges;
Query OK, 0 rows affected (0.01 sec)

退出mysql，一切正常！

总结

服务名应该是mysqld，而不是mysql，安装完成mysql后建议重启，闹了个乌龙

service mysqld.service restart 

参考链接： https://www.programmersought.com/article/5156943270/