Linux:
安装
[root @ localhost ~]# yum install mysql-server
设定为开机自动启动
[root @ localhost ~]# chkconfig mysqld on
启动mysql服务
[root @ localhost ~]# /etc/init.d/mysqld start
检查是否启动成功
[root@localhost ~]# /etc/init.d/mysqld status
mysqld (pid 9234) is running...
Windows:
下载并安装最新版本:
http://dev.mysql.com/downloads/windows/
Windows环境,Mysql默认是忽略大小写的,请在my.ini添加如下命令设置大小写敏感
在命令行使用(sc qc MySQL|find ".ini")查看my.ini文件所在目录
[mysqld]
lower_case_table_names = 2
(重启Mysql, CMD输入如下命令:)
net stop mysql
net start mysql
检查Mysql大小写是否敏感:
mysql> create database NEWTEST;
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| NEWTEST |
| mysql |
| test |
+--------------------+
4 row in set (0.00 sec)