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">