【1】mysql报错ERROR 2003 (HY000)和ERROR 1045 (28000)

 mysql

mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

 

解决方法：

重启mysql： sudo /etc/init.d/mysqld start

ps -ef |grep mysql

root     21910     1  0 21:31 pts/2    00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql

mysql    22014 21910  0 21:31 pts/2    00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock

 

 

再次登录

mysql -u root -p

mysql: [Warning] Using a password on the command line interface can be insecure.

Enter password:

ERROR 1045 (28000): Access den