搭建环境(mysql error1045)
上一篇 /
下一篇 2010-01-08 20:00:43 / 天气: 晴朗
/ 心情: 高兴
/ 个人分类:错误解决法
为了练习课外实践项目,本想重新安装下mysql5.0 没想到到了最后一步却碰到error no.1045。大概是说和之前已存在的MySql冲突。于是百度了下,发现以下代码能解决此问题:
tRo
KJbGV0mysql>use mysql51Testing软件测试网1O;wx6t
A
h8_4t}
mysql>select user, host, password from user;51Testing软件测试网E&nlz@-JBz2v# Now you should see that u have 3 entries
0W[%B X:_/mlI0+-----------------------------+
iq9u!w9D T0| user | host | password |
m"J0\gX/GP0+-----------------------------+
|K%z\6Z0| root | localhost | |
51Testing软件测试网]J5yzG| root | 127.0.0.1 | |
I:r*sf'P q k0| | localhost | |
51Testing软件测试网ZB&QUnS+-----------------------------+
"Kt%yDRf6a0PG-~5@E+D0mysql> delete from user where host="localhost" and user="";
uz0@^4ms0mysql> update user set password=password("xxxx") where user="root";51Testing软件测试网bsC!l*m,M^V}
mysql> flush tables;51Testing软件测试网(h5VKpw+v[:H!C
mysql> flush privileges;
M3}*qX,S%C0mysql> quit
lj#V0Mb%l)C[051Testing软件测试网$c/DS
HM7Jr
然后就可以用config wizard跑一遍了。。。感谢网络上的
收藏
举报
TAG: