mac下mysql

1、下载安装

http://dev.mysql.com/downloads/mysql/

2、配置

vi ~/.bash_profile

export PATH=$PATH:/usr/local/mysql/bin

source .bash_profile

Mac OS X中MySQL 的配置文件（my.cnf）的位置

/usr/local/mysql/support-files/

// 修改客户端字符集

[client]
default-character-set=utf8 

[mysql]
default-character-set=utf8 

// 修改服务器字符集 utf8-general-ci

[mysqld]
default-character-set=utf8（mysql 5.5版本添加character-set-server=utf8）

配置文件

http://leeyin.iteye.com/blog/1459274

设置默认存储引擎

http://www.linuxidc.com/Linux/2010-04/25512.htm

因为MySQL默认的是MyISAM数据引擎，不支持事务也不支持外键，所以需要用到Innodb引擎，于是决定将mysql的默认引擎设置为innodb。

1 . 查看MySQL存储引擎是用的哪个？登录MySQL数据库，在mysql>提示符下搞入show engines;命令。
+------------+---------+----------------------------------------------------------------+
| Engine     | Support | Comment                                                        |
+------------+---------+----------------------------------------------------------------+
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      |
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     |
| BerkeleyDB | YES     | Supports transactions and page-level locking                   |
| BLACKHOLE  | NO      | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE    | NO      | Example storage engine                                         |
| ARCHIVE    | NO      | Archive storage engine                                         |
| CSV        | NO      | CSV storage engine                                             |
| ndbcluster | NO      | Clustered, fault-tolerant, memory-based tables                 |
| FEDERATED  | NO      | Federated MySQL storage engine                                 |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          |
| ISAM       | NO      | Obsolete storage engine                                        |
+------------+---------+----------------------------------------------------------------+

说明目前默认的数据引擎是MyISAM，并且也支持InnoDB引擎。

2. 设置InnoDB为默认引擎：在配置文件my.cnf中的 [mysqld] 下面加入default-storage-engine=INNODB 一句，保存。

3. 重启mysql服务器：mysqladmin -u root -p shutdown或者service mysqld restart 登录mysql数据库，在mysql>提示符下搞入show engines;命令。如果出现 InnoDB |DEFAULT，则表示我们 设置InnoDB为默认引擎成功。

3、启动与关闭

sudo /Library/StartupItems/MySQLCOM/MYSQLCOM [start | stop | restart]

4、备份与还原

 mysqldump -h 127.0.0.1 -u root -p dbname>dbname.dmp

 mysql -h 127.0.0.1 -u root -p dbname<dbname.dmp

5、常用命令

mysql> show global variables like 'character%';

mysql> show status like 'innodb_rows_%'; 

mysql> show variables like 'query%'; 

show variables
http://www.2cto.com/database/201108/100546.html

show processlist; //查看当前运行状态。

mysql -uroot -psss@pas -e "set GLOBAL max_connections=2048"
mysql -uroot -psss@pas -e "show variables" |grep max_connection