centos5.3安装mysql_centos5.5中安装mysql5.5.3数据库教程

1.挂载linux光盘，修改yum源

mount /dev/cdrom /media/

cd /etc/yum.repos.d/

rm -rf CentOS-Base.repo

vim CentOS-Media.repo

baseurl=file:///media

gpgcheck=0

enabled=1

2.安装编译mysql源码必需的程序

yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers

3.编译安装mysql

./configure –prefix=/usr/local/mysql –without-debug –enable-thread-safe-client –with-pthread –enable-assembler –enable-profiling –with-mysqld-ldflags=-all-static –with-client-ldflags=-all-static –with-extra-charsets=all –with-plugins=all –with-mysqld-user=mysql –without-embedded-server –with-server-suffix=-community –with-unix-socket-path=/tmp/mysql.sock && make && make install

4.创建mysql用户

useradd mysqluser

5.设置mysql安装目录的权限给mysql用户

setfacl -m u:mysqluser:rwx -R /usr/local/mysql

setfacl -m d:u:mysqluser:rwx -R /usr/local/mysql

6.安装mysql和test数据库

/usr/local/mysql/bin/mysql_install_db –user=mysql

7.启动mysql服务

/usr/local/mysql/bin/mysqld_safe –user=mysql &

8.修改mysql的登陆密码为123456

/usr/local/mysql/bin/mysqladmin -u root password “123456”

9.使用mysql用户登陆数据库

/usr/local/mysql/bin/mysql -u root -p 123456

10.备份配置mysql的配置文件

cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf

11.配置mysql的配置文件

vi /etc/my.cnf

#修改客户端的连接字符集

default-character-set=utf8

#修改服务器和数据库字符集

character-set-server=utf8

#修改服务器校验字符集

collation-server=utf8_general_ci

12.重启mysql服务，让字符集生效

pkill mysqld

/usr/local/mysql/bin/mysqld_safe –user=mysql &