mysql windows平台安装 异常1067，安装在linux平台 异常1130

到mysql官网下载windows和linux最新版本
http://dev.mysql.com/downloads/mysql/
1.windows版本为免安装版，解压到相应目录，配置环境变量。

2.注册windows系统服务

cd F:\mysql-5.6.15-winx64\bin

运行如下命令，成功会有提示：

mysqld install MySQL --defaults-file="F:\mysql-5.6.15-winx64\my-default.ini"

<span style="font-family:Arial, Helvetica, sans-serif;">移除服务命令为：mysqld remove</span>

win7卸载服务：sc delete MySql;

3.启动mysql服务，成功会有提示：

F:\mysql-5.6.15-winx64> net start mysql

4.修改密码（windows和linux相同操作）：

F:\mysql-5.6.15-winx64> mysql –u root
F:\mysql-5.6.15-winx64> mysql>show databases; 
F:\mysql-5.6.15-winx64> mysql>use mysql;

<pre code_snippet_id="167900" snippet_file_name="blog_20140123_5_4281114" class="html" name="code">F:\mysql-5.6.15-winx64> mysql>select `user` ,`password` from `user` where `user` = 'root';

F:\mysql-5.6.15-winx64> mysql>update `user` set `password`=PASSWORD("root") where `user`='root';

F:\mysql-5.6.15-winx64> mysql><span style="font-family:Arial, Helvetica, sans-serif;">mysql> flush privileges;</span>

<span style="font-family:Arial, Helvetica, sans-serif;">遇到mysql异常1067，查找资料解决，方法如下：</span>

方法1：在配置文件my-default.ini添加如下内容:[mysqld]skip-innodb

方法2：进入mysql安装目录data目录下，删除ibdata、<span style="font-family:Arial, Helvetica, sans-serif;">ib_logfile0、ib_logfile1删掉，重新启动：</span>

cd F:\mysql-5.6.15-winx64\data>
F:\mysql-5.6.15-winx64> net start mysql


Linux 下安装mysql 
http://dev.mysql.com/downloads/mysql/
1.操作系统：centos5.6，下载linux通用版本，解压，由于是多个rpm，安装简单。
[root@master software]# rpm -ivh MySQL-*.rpm


2.启动mysql服务
[root@master software]# service mysql start
Starting MySQL..[确定]或者如下启动：
[root@master software]# /etc/init.d/mysql start
Usage: mysql  {start|stop|restart|reload|force-reload|status}  [ MySQL server options ]


3.连接mysql，安装mysql server 时日志中有提示随机密码生成指定目录，查看
[root@master software]# cat /root/.mysql_secret
# The random password set for the root user at Wed Jan 22 18:21:06 2014 (local time): LHTlCpS7
[root@master software]#mysql -u root -p 


4.输入如上密码进入，必须设置密码，才能查询数据库。
[root@master software]# show databases;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql>select `user` ,`password` from `user` where `user` = 'root';
mysql>set PASSWORD=PASSWORD('root');


5.如果系统字符集和mysql字符集不一致的话修改系统字符集
[root@master software]#vi /etc/sysconfig/i18n
修改行LANG="en_US.UTF-8"为LANG="zh_CN.UTF-8"


遇到问题：用NavicatforMySQL连接服务器报错：1130.
问题描述：mysql权限问题，root用户只能通过本机登录。
解决办法：
1.输入密码登录
[root@master software]# mysql -u root -p 
2.查看权限，如下为只能本机登录。
mysql> select `host` from `user` where `user`='root'; 
+-----------+
| host      |
+-----------+
| 127.0.0.1 |
| ::1       |
| localhost |
| master    |
+-----------+
4 rows in set (0.00 sec)
mysql> update `user` set `host` = '%' where `user` = 'root';
[root@master software]# use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Database changed


3.修改root权限，操作成功后，测试连接，成功。
mysql> update `user` set `host` = '%' where `user` = 'root';  
mysql> flush privileges;
mysql> select `host` from `user` where `user`='root';              
+-----------+
| host      |
+-----------+
| %         |
| 127.0.0.1 |
| ::1       |
| master    |
+-----------+
4 rows in set (0.00 sec)

4.添加用户后授权。

create user websiteschema identified by 'websiteschema';

grant select on 数据库.* to 用户名@登录主机 identified by"密码" ;

grant select,insert,update,delete on *.* to test@"%" Identified by"test";

grant all privileges on *.* to websiteschema@'%' identified by 'websiteschema';

<pre code_snippet_id="167900" snippet_file_name="blog_20140123_5_4281114" class="html" name="code">