|
|
phpmyadmin的root账号被删除后一般在ssh内提示:( A$ l# i1 b* U* U- {. Z
. k8 x1 t1 o: R) UERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
& W, p; ~$ u- E. K0 _: g
# q, P6 k7 K6 G" j: D在phpmyadmin内提示phpmyadmin #1045错误,无法登录 MySQL 服务器
3 B& q) v; ~8 b4 I" x, b4 G
2 I) V3 _2 r: D$ e 这时候需要我们重新添加root账号,步骤如下:, v% L( v4 M1 r: x+ G! [8 Q
: Q3 _' u/ p- S 在ssh内如下输入:- L4 S7 q1 E6 h+ l* T% C
, p* J( ?- |( p6 H& R+ k9 setc/init.d/mysql stop (停止mysql)
) d9 F, z5 o7 x' l: z /usr/bin/mysqld_safe --skip-grant-tables; d9 Z: B2 S) ]7 b7 y+ ~( y
另外打开个SSH连接窗口$ x4 L3 `9 Y* W
[root@localhost ~]# mysql' F5 O( r+ t; J! Z2 R! e
insert into mysql.user (host, user, password) values ('localhost', '账号一般是root', password('你设置的密码'));
8 \: m7 y) D% c. N. f3 j) l4 B" Xflush privileges;
4 J5 X1 r3 }9 x5 s% A8 R( x8 s l0 x grant all on *.* to 'root'@'localhost';
. A5 h2 |, c5 H. a
k3 n O" j; h3 L7 A# C* N* V" L6 Y6 D$ e' p5 E
然后重启 mysq 登陆 OK解决问题~ |
|