MySQL5.5在Windows下的安装

选择安装目录下的*.ini文件(这里选择my-medium.ini)复制并改名为my.ini文件。添加如下内容：

BY "root";//为root添加远程连接的能力。mysql>update user set Password = password('xxxxxx') where User='root';mysql>select Host,User,Password from user where User='root'; mysql>flush privileges;mysql>exit

重新登录MySQL

#.\mysql -u root -p

mysql>?show variables like 'char%';　　//可查看字符编码是否都设置为utf8

+--------------------------+-------------------------------------------------+| Variable_name            | Value                                           |+--------------------------+-------------------------------------------------+| character_set_client     | utf8                                            || character_set_connection | utf8                                            || character_set_database   | utf8                                            || character_set_filesystem | binary                                          || character_set_results    | utf8                                            || character_set_server     | utf8                                            || character_set_system     | utf8                                            || character_sets_dir       | E:\MySQL\MySQL Server 5.5\share\charsets\   |+--------------------------+-------------------------------------------------+

8、添加一个新用户。

参考：mysql -- 添加用户，权限刷新?

grant all privileges on *.* to 用户名0@'%' identified by '密码';grant all privileges on *.* to 用户名@'localhost' identified by '密码';grant all privileges on *.* to 用户名@'127.0.0.1' identified by '密码';#insert into user (Host,User,Password) values('localhost','用户名','密码'); #insert into user (Host,User,Password) values('127.0.0.1','用户名','密码'); insert into user (Host,User,Password) values('::1','用户名',''); #update user set Password = password('密码') where User='用户名';select Host,User,Password  from user where User='用户名';flush privileges;

注意：grant命令同时会在User表中添加一条新的记录，所以用了grant命令就不需要进行insert in插入新的记录项。

如果想统一该用户所有的密码可使用upadte语句。