Instructions for not turning on mysqld-find tutorials Online

Source: Internet
Author: User

After booting, found unable to login MySQL

[Email protected] ~]# mysql-hlocalhost-uroot-p123456
MySQL: [Warning] Using a password on the command line interface can is insecure.
ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (111)

View MySQL status, not up
[Email protected] ~]# systemctl status mysqld
Mysqld.service-sysv:mysql database server.
Loaded:loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset:disabled)
Active:failed (Result:exit-code) since a 2018-05-07 18:55:45 CST; 3min 10s ago
Docs:man:systemd-sysv-generator (8)
process:995 execstart=/etc/rc.d/init.d/mysqld Start (code=exited, Status=1/failure)

May 18:55:37 Localhost.localdomain systemd[1]: Starting sysv:mysql database server ....
May 18:55:45 localhost.localdomain mysqld[995]: MySQL Daemon failed to start.
May 18:55:45 Localhost.localdomain mysqld[995]: Starting mysqld: [Failed]
May 18:55:45 localhost.localdomain systemd[1]: Mysqld.service:control process exited, Code=exite...s=1
May 18:55:45 localhost.localdomain systemd[1]: Failed to start sysv:mysql database server.
May 18:55:45 localhost.localdomain systemd[1]: Unit Mysqld.service entered failed state.
May 18:55:45 localhost.localdomain systemd[1]: Mysqld.service failed.
Hint:some lines were ellipsized, use-l to show on full.

[Email protected] run]# mkdir-p/var/run/mysqld
[Email protected] run]# chown mysql.mysql mysqld
[Email protected] run]# systemctl start mysqld
Open success!

Instructions for not turning on mysqld-find tutorials Online

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.