yum安裝mysql步驟及報錯ERROR 1045 (28000)

標籤：mysql   報錯   error1045   

1.centos 系統中使用yum工具安裝 mysql.

 

[[email protected] ~]#yum install -y mysql

 

2.yum install -y mysql後，啟動mysql報錯如下：

 

ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)

解決辦法：缺少組件，安裝mysql-server包。

 

3.安裝組件mysql-server

 

[[email protected] ~]#yum install -y mysql-server

 

4.啟動mysql

 

 [[email protected] ~]#service mysqld start

 

5.使用mysql報錯

 

[[email protected] ~]# mysql

ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO)

  

6.報錯解決辦法

 

（1）service mysqld stop

 

（2）/usr/bin/mysqld_safe --skip-grant-tables

（3）另外開個SSH串連
        [[email protected] ~]# mysql
        mysql> GRANT ALL PRIVILEGES ON *.* TO [email protected]"%" IDENTIFIED BY "root";
        mysql>use mysql
        mysql>update user set password=password("123456") where user="root";
        mysql>flush privileges;
        mysql>exit

 

     如果有報錯如下：

mysql> GRANT ALL PRIVILEGES ON *.* TO [email protected]"%" IDENTIFIED BY "root";
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

 

解決辦法：先輸入flush privileges; 再執行 GRANT ALL PRIVILEGES ON *.* TO [email protected]"%" IDENTIFIED BY "root";其他步驟不要忘記。

 

（4）[[email protected] ~]#pkill -KILL -t pts/0 可將pts為0的**使用者(之前運行mysqld_safe的使用者  視窗)強制踢出
（5）正常啟動 mysql：service mysqld start

如果沒啟動mysqld服務就使用mysql,會報錯:

[[email protected] ~]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (111)

 

7.成功進入mysql

 

[[email protected] ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.

mysql> show databases;
+----------------------+
| Database             |
+----------------------+
| information_schema   |
| dbname               |
| mysql                |
| test                 |
+----------------------+
4 rows in set (0.00 sec)

mysql>

 

 安全提示：

GRANT ALL PRIVILEGES ON *.* TO [email protected]"%" IDENTIFIED BY "root";

這裡最後要做一下IP或網段的限制，否則有安全隱患。

本文出自 “馮曉慶的部落格” 部落格，請務必保留此出處http://fengyunshan911.blog.51cto.com/995251/1747502

yum安裝mysql步驟及報錯ERROR 1045 (28000)