Windows下MySQL重装引起问题的解决
解决了Plugin 'InnoDB' init function returned error问题和error1405那个安全设置密码登陆问题，我个人觉得关键点在于删除C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\目录下的数据文件，当然，我不可能在重现问题求证了，不过看此贴的人可以尝试一下只做此步是否能解决问题，当然还有删除MYSQL安装目录中的残留文件步骤也比较重要
Cite from：http://forums.mysql.com/read.php?22,144428,250105#msg-250105
Re: Plugin 'InnoDB' init function returned error.
Posted by: Richard Lee ()
Date: February 27, 2009 10:21AM
For Windows OS:
OK, I struggled with this for ages. There are various partial fixes that did not fix it for me on the web, but in the end the following worked:
If you've installed it, then uninstall (an earlier version that had been removed could have left crap that is causing an issue, so best to start off clean). Do this as follows:
- Add/Remove Programs and remove MySQL.
- Delete the Programs File/MySQL folder (it gets left behind)
- Delete the data file (where ever you stored it) #:\MySQL DataFiles > This is assuming you have no data to as yet to worry about!!!!
- Run RegEdit and delete all the MySQL Keys (search and F3) and the half a dozen or so CLSIDs that coe up with just a single non-defailt key for MySQL. You can leave ADOBE\ keys that mention it if you have dreamweaver etc. As allways back up you registry first before choppig it!
OK. Now run te install and go through the config wizard until it fails at the start up. Then close it.
Now open up Services and open MySQL properties - I set it to run under the Administrator account rather than System/ANOther to ensure it had permissions.
Next, go to your new MySQL DataFile and delete 'ibdata1'.
Then go to 'C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data' and delete all tje 'ib_logfile' prefixed files (should be 0 and 1) - useful to notice the .err log here to which is a text file
相关文档：
MySQL(root用户)密码忘记重置
分别在Windows下和Linux下重置了MYSQL的root的密码，整理如下：
A：在windows下：
1：进入cmd，停止mysql服务：Net stop mysql
到mysql的安装路径启动mysql，在bin目录下使用mysqld-nt.exe启动，
2：执行：mysqld-nt --skip-grant-tables（窗口会一直停止 ......
参照 : http://ubuntuing.javaeye.com/blog/65547
第
一步：安装pure-ftpd和pure-ftpd-mysql.
apt-get install pure-ftpd
apt-get
install pure-ftpd-mysql
第二步：修改pure-ftpd链接mysql的密码
vim
/etc/pure-ftpd/db/mysql.conf
默认配置：
#MYSQLServer
localhost
#MYSQLPort& ......
当你连接一个MySQL服务器时，你通常应该使用一个口令。口令不以明文在连接上传输。
所有其他信息作为能被所有人读懂的文本被传输。如果你担心这个，你可使用压缩协议(MySQL3.22和以上版本)使事情变得更难。甚至为了使一切更安全，你应该安装ssh（见http://www.cs.hut.fi/ssh)。用他，你能在一个MySQL服务器和一个MySQL客� ......
第一招、mysql服务的启动和停止
net stop mysql
net start mysql
第二招、登陆mysql
语法如下： mysql -u用户名 -p用户密码
键入命令mysql -uroot -p， 回车后提示你输入密码，输入12345，然后回车即可进入到mysql中了，mysql的提示符是：
mysql>
注意，如果是连接到另外的机器上，则需要加入一个参数-h机器IP
� ......
由于系统需要，写了一个ORDER BY 的SQL查询语句进行字段排序，查询结果没有进行排序，SQL语法正确；
于是，进入MySQL控制台，执行SQL语句，没有报错，但是就是没有排序；
经过查找发现，在写 ORDER BY ' time' DESC 语句中，使用了“ ' ”符号，导致MySQL无法正常解析，去掉排序正常；
或者可以用 &ldqu ......
