mySQL安装指南

[1]安装mysql:
 3个关键选择：
  编码方式：选GBK或者UTF8
  勾选允许系统环境变量路径
  输入自定义mysql密码,要记住密码
[2]最后点击安装时，如果程序无法响应，则安装失败
 强制关闭安装程序。
 进入控制面板卸载mySQL,卸载程序执行完毕后控制面板还有mySQL，其实后台还在执行另外一个卸载程序，等待其完成。待控制面板上的mySQL消失后，到mySQL安装路径查看是否卸载干净：C:\Program Files,未卸载干净则手动卸载
 重新安装mySQL;
[3]在安装MySQL时，出现“The security settings could not be applied to the database because the connection has failed with the following error. Error Nr. 1045 Access denied for user 'root'@'localhost' (using password: YES)” 解决办法：
The security settings could not be applied to the database because the connection has failed with the following error.

Error Nr. 1045

Access denied for user 'root'@'localhost' (using password: YES)

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.

解决方法：

1, 首先卸载MySQL

2, 再根据这个目录 C:\Documents and Settings\All Users\Application Data\MySQL，将mysql删除

3, 重新安装MySQL 就好了（电脑不用重启）

[4]mysql-connector-java-5.1.25-bin.jar文件是mySQL驱动，从myEclipse连接mysql时要把该文件复制到WebRoot/WEB-INF/lib文件中，json包也是复制到该目录
[5]sqlyog是数据库的可视化工具，方便对数据库进行操作