分享一些mysql资料

1.mysql5.1官网资料

https://dev.mysql.com/doc/refman/5.1/zh/index.html

 

2，mysql字符集问题解答：

 查看字符集： show variables like '%char%';

修改mysql的字符集和默认存储引擎

 

 

3，linux下快速安装mysql

shell> groupadd mysql
shell> useradd -g mysql mysql

# Beginning of source-build specific instructions
shell> tar zxvf mysql-VERSION.tar.gz
shell> cd mysql-VERSION
shell> ./configure --prefix=/usr/local/mysql
shell> make
shell> make install
# End of source-build specific instructions

# Postinstallation setup
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> bin/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql var

# Next command is optional
shell> cp support-files/my-medium.cnf /etc/my.cnf

或者：
shell> cp share/my-medium.cnf /etc/my.cnf

shell> bin/mysqld_safe --user=mysql &

# Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server