centos下mysql的一些设置
1、开机自启动mysql
最简易的方式，
我是在装系统时就装了mysql,
所以用whereis 等查找命令找到mysqld
然后编辑#vi /etc/rc.d/rc.local
?
加入
/etc/rc.d/init.d/mysqld start
重启即可
?
2、mysql编码修改
在 etc/my.cn中[mysqld]和[client]下加入，如果没有[client]自己写一个
default-character-set=utf8
?
登录mysql -uroot -p进入后用
show variables like 'character%';
查看一下编码
+--------------------------+----------------------------+
| Variable_name??????????? | Value????????????????????? |
+--------------------------+----------------------------+
| character_set_client???? | utf8?????????????????????? |
| character_set_connection | utf8?????????????????????? |
| character_set_database?? | utf8?????????????????????? |
| character_set_filesystem | binary???????????????????? |
| character_set_results??? | utf8?????????????????????? |
| character_set_server???? | utf8?????????????????????? |
| character_set_system???? | utf8?????????????????????? |
| character_sets_dir?????? | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
?
3、给mysql设置密码
刚开始装进去的mysql是没有密码的，所以启动mysql服务后设置
mysqladmin -u root password 123456
?
