mysql在虚拟机中启动失败

问题1：查看my.cnf文件缺少对应文件/var/run/mysqld/

方法1：

mkdir -p /var/run/mysqld/

    chown mysql.mysql /var/run/mysqld/

MySQL日常坑洞之服务器重启后MySQL服务启动失败：Can't create/write to file '/var/run/mysqld/mysqld.pid'_Light-dragon的博客-优快云博客m

方法2：

 echo "d /var/run/mysqld 0755 mysql mysql -" > /usr/lib/tmpfiles.d/mysql.conf

方法3：

       手动在 /usr/lib/tmpfiles.d/ 建立mysql.conf，然后输入 d /var/run/mysqld 0755 mysql mysql -

d /var/run/mysqld 0755 mysql mysql -

服务器重启/var/run/mysqld消失_流萤的博客-优快云博客

问题2：Failed to restart mysqld.service: Unit not found.

描述问题：启动mysql:systemctl start mysqld时出现问题2

解决方法

/opt/mysql/support-files/mysql.server
/opt/mysql/support-files/mysql.server status

/opt/mysql/support-files/是我安装的mysql目录

Failed to execute operation: No such file or directory

解决方法

cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld