MySQLERROR 1045 (28000)与ERROR 2002 (HY000)问题解决方法
来源:互联网 发布:2016真正的人工智能股 编辑:程序博客网 时间:2024/06/07 17:10
首先是我遇到的问题是:Access denied for user ‘root’@’localhost’ (using password: YES),安照网上的方法:
[root@www ~]# mysql -u root -p
Enter
password
:
ERROR 1045 (28000): Access denied
for
user
'root'
@
'localhost'
(using
password
: YES)
[root@www ~]
#/etc/init.d/mysql stop
[root@www ~]
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[root@www ~]
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root'
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
[root@www ~]# mysql -u root -p #关闭服务后又出现如下问题
Enter password:
ERROR 2002 (HY000): Can'
t
connect
to
local
MySQL server through socket
'/tmp/mysql.sock'
(2)
这一步我结合网上的例子:
[root@www ~]
#ps -ef|grepmysql显示类似:
root 18232 00:00:023 mysqld_safe
mysql 18543 00:00:33 mysqld
mysql 18543 00:00:33 mysqld
[root@www ~]
#kill -918232
[root@www ~]
#kill -918543
[root@www ~]
#/etc/init.d/mysql restart[root@www ~]# mysql -u root -p
------>重新进入
Enter
password
:
Welcome
to
the MySQL monitor. Commands
end
with
;
or
\g.
Your MySQL
connection
id
is
2
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>
阅读全文
1 0
- MySQLERROR 1045 (28000)与ERROR 2002 (HY000)问题解决方法
- mysqlERROR 1045 (28000…
- mysql更改数据目录步骤与错误(ERROR 2002 (HY000))处理方法
- mysqlERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.so
- ERROR 2002 (HY000):
- MySQL:ERROR 2002 (HY000)
- ERROR 2002 (HY000)
- ERROR 2002 (HY000): Can't connect to local MySQL server 问题解决
- ERROR 2002 (HY000) 根本解决办法
- mysql遇到:ERROR 2002 (HY000)
- ERROR 1033 (HY000): Incorrect information in file: 'abc.frm' 问题解决
- centos6.3 mysql ERROR 2002 (HY000)
- mysql启动时ERROR 2002 (HY000)
- CentOS7 安装MySQL :ERROR 2002 (HY000)***
- MySQL 启动报错-ERROR 2002 (HY000)
- linux下mysql ERROR 2002 (HY000)
- Mysql ERROR 2002 (HY000)错误解决
- Windows下Mysql错误ERROR 1045 (28000) ERROR 1054 (42S22)以及ERROR 1820 (HY000)的解决
- 百度地图API之覆盖物和事件
- C++ 对文件夹的安全权限操作
- 如何进入 Google 工作
- 【数据集介绍】ImageNet介绍
- mysql时间格式化处理
- MySQLERROR 1045 (28000)与ERROR 2002 (HY000)问题解决方法
- 设计模式---中介者模式
- windows蓝屏日志文件、dump文件收集方法
- 百度地图API之JavaScript 开源库1
- 生成迷宫的深度优先遍历算法的非递归实现
- Visual Assist 过期后重装不能使用的解决办法
- 微信小程序登录案例
- Spring中Bean的基于xml的三种实例化方式
- 百度地图API之JavaScript开源库2