restart mysql

 

mysql> show variables like 'datadir'';

+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| datadir       | /var/lib/mysql/ |
+---------------+-----------------+

1 row in set (0.00 sec)

[root@sqmc system]# vi mysqld.service

[root@sqmc system]# service mysqld restart

Redirecting to /bin/systemctl restart mysqld.service

Warning: The unit file, source configuration file or drop-ins of mysqld.service changed on disk. Run 'systemctl daemon-reload' to reload units.

[root@sqmc system]# systemctl daemon-reload

[root@sqmc system]# service mysqld restart

Redirecting to /bin/systemctl restart mysqld.service

Job for mysqld.service failed because the control process exited with error code.

See "systemctl status mysqld.service" and "journalctl -xe" for details.