首先是我遇到的问题是: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
[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>