Linux下MySQL数据库安装与配置
Linux下MySQL数据库安装与配置
1. 安装MySQL数据库
先从MySQL官网下载MySQL,然后进入所下载的安装文件所在目录,运行如下命令进行安装,其中MySQL-server-community-5.1.56-1.rhel5.i386.rpm为刚刚下载的MySQL数据库服务器的rpm包,然后使用/etc/rc.d/init.d/mysqlrestart命令重启MySQL服务:- [root@localhost ~]# rpm -ivh MySQL-server-community-5.1.56-1.rhel5.i386.rpm
- [root@localhost ~]# /etc/rc.d/init.d/mysql restart
- Shutting down MySQL..[确定]
- Starting MySQL..[确定]
2. 配置MySQL数据库字符集
备注:配置MySQL数据库字符集的目的是方便的使用数据库,无需在每次连接的时候都要临时设置数据库字符集的,个人不建议采用这种方法,真正的工程项目都应该在连接数据库时临时设置数据库字符集,如此才便于系统的移植,而且又不会影响数据库服务器中的其他数据库的使用!
安装完成之后,需要配置MySQL的字符集配置,首先需要查找MySQL的配置文件的位置,由于MySQL的配置文件名是以.cnf结尾的,因此可用如下命令进行查找:
- [root@localhost ~]# find / -iname '*.cnf' -print
- /usr/share/mysql/my-large.cnf
- /usr/share/mysql/my-medium.cnf
- /usr/share/mysql/my-innodb-heavy-4G.cnf
- /usr/share/mysql/my-huge.cnf
- /usr/share/mysql/my-small.cnf
- /usr/share/doc/MySQL-server-community-5.1.56/my-large.cnf
- /usr/share/doc/MySQL-server-community-5.1.56/my-medium.cnf
- /usr/share/doc/MySQL-server-community-5.1.56/my-innodb-heavy-4G.cnf
- /usr/share/doc/MySQL-server-community-5.1.56/my-huge.cnf
- /usr/share/doc/MySQL-server-community-5.1.56/my-small.cnf
- /etc/pki/tls/openssl.cnf
输入完命令“find / -iname '*.cnf'-print”回车后,屏幕便显示搜索到的MySQL配置文件,然后拷贝my-large.cnf、my-medium.cnf 、my-innodb-heavy-4G.cnf 、my-huge.cnf、my-small.cnf中任意的一个到/etc目录下,并命名为my.cnf,其命令如下所示:
- [root@localhost ~]# cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
- [root@localhost ~]# vi /etc/my.cnf
然后,使用vi编辑器修改/etc/my.cnf文件,在[client]下添加: “default-character-set=gb2312”;在[mysqld]下添加:“default-character-set=gb2312”。如下所示:
- # The following options will be passed to all MySQL clients
- [client]
- default-character-set=gb2312
- #password = your_password
- port = 3306
- socket = /var/lib/mysql/mysql.sock
- # Here follows entries for some specific programs
- # The MySQL server
- [mysqld]
- default-character-set=gb2312
- port = 3306
- socket = /var/lib/mysql/mysql.sock
- skip-locking
- key_buffer_size = 16M
- max_allowed_packet = 1M
- table_open_cache = 64
- sort_buffer_size = 512K
- net_buffer_length = 8K
按一下Esc键,输入“:wq”后回车保存配置文件,输入“/etc/rc.d/init.d/mysqlrestart”重启MySQL服务,如下所示:
- [root@localhost ~]# /etc/rc.d/init.d/mysql restart
- Shutting down MySQL..[确定]
- Starting MySQL..[确定]
|
评论暂时关闭