搭建环境(mysql error1045)
上一篇 /
下一篇 2010-01-08 20:00:43 / 天气: 晴朗
/ 心情: 高兴
/ 个人分类:错误解决法
为了练习课外实践项目,本想重新安装下mysql5.0 没想到到了最后一步却碰到error no.1045。大概是说和之前已存在的MySql冲突。于是百度了下,发现以下代码能解决此问题:
0t ua3X9Y0mysql>use mysql
6KsLu}M0mysql>select user, host, password from user; J@9Am!}/e0# Now you should see that u have 3 entries
DO,D*q%O|4Nb1^0+-----------------------------+
51Testing软件测试网L1f]nL7Z`D$n)e/ax| user | host | password |
51Testing软件测试网"j
W
]!XMlP3?+-----------------------------+
51Testing软件测试网2P&p5f!Dp| root | localhost | |
51Testing软件测试网nu%_-dF)G/k'm| root | 127.0.0.1 | |
51Testing软件测试网g-W]"JV%B| | localhost | |
]H{:B)E'\-X0+-----------------------------+
3C`x?-C9MU*D051Testing软件测试网~*f5?G#IWmysql> delete from user where host="localhost" and user="";51Testing软件测试网$T!q`U:rr"|
mysql> update user set password=password("xxxx") where user="root";51Testing软件测试网Zk ?M4m
[a1\Is+F
mysql> flush tables;51Testing软件测试网 BL@5iV
mysql> flush privileges;51Testing软件测试网OL3LEBwF'b
mysql> quit51Testing软件测试网dyX/[5}3~bl)H_
51Testing软件测试网+Xx.rL j+mz
然后就可以用config wizard跑一遍了。。。感谢网络上的
收藏
举报
TAG: