ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (111)
[root@Hadoop ~]# mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (111)
[root@Hadoop ~]# mysqld install
-bash: mysqld: command not found
[root@Hadoop ~]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
解决办法：
[root@Hadoop ~]# rm -fr /var/lib/mysql/*
[root@Hadoop ~]# service mysqld start
Connection established. To escape to local shell, press 'Ctrl+Alt+]'. Last login: Sat Feb 29 05:13:58 2020 from 192.168.184.1 [root@Hadoop ~]# mysql ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (111) [root@Hadoop ~]# mysqld install -bash: mysqld: command not found [root@Hadoop ~]# service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] [root@Hadoop ~]# /etc/inint.d/mysql start -bash: /etc/inint.d/mysql: No such file or directory [root@Hadoop ~]# mysql --help| grep my.cnf order of preference, my.cnf, $MYSQL_TCP_PORT, /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf [root@Hadoop ~]# service mysql restart mysql: unrecognized service [root@Hadoop ~]# service mysqld restart Stopping mysqld: [ OK ] MySQL Daemon failed to start. Starting mysqld: [FAILED] [root@Hadoop ~]# rm -fr /var/lib/mysql/* [root@Hadoop ~]# service mysqld start Initializing MySQL database: Installing MySQL system tables... OK Filling help tables... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h Hadoop password 'new-password' Alternatively you can run: /usr/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd /usr ; /usr/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd /usr/mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/bin/mysqlbug script! [ OK ] Starting mysqld: [ OK ] [root@Hadoop ~]# 讯享网
然后重新启动，正常！
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请联系我们，一经查实，本站将立刻删除。
如需转载请保留出处：https://51itzy.com/kjqy/75850.html