MySQL学习日记1入门-安装MySQL

编译安装MySQL5.5.22

在Centos6.5中实现

1. yum -y install ncurses-devel
2. tar zxf cmake-2.8.6.tar.gz 
3. cd cmake-2.8.6
4. ./configure && gmake && gmake install
5. tar zxf /usr/local/src/mysql-5.5.22.tar.gz
6. cd /usr/local/src/mysql-5.5.22
7. cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc/ -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all && make && make install

优化调整

1. cp support-files/my-medium.cnf /etc/my.cnf 
2. cp support-files/mysql.server /etc/init.d/mysqld
3. chmod +x /etc/init.d/mysqld 
4. chkconfig --add mysqld
5. chkconfig mysqld on
6. echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
7. . /etc/profile

初始化数据库

1. groupadd mysql
2. useradd -M -s /sbin/nologin -g mysql mysql
3. chown -R mysql:mysql /usr/local/mysql
4. /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

启动MySQL服务

service mysqld start

5.6.26版本

[root@localhost ~]# yum remove -y mysql mysql-devel mysql-server
[root@localhost ~]# cd /usr/local/src/
[root@localhost src]# tar xvf mysql-5.6.26.tar.gz
[root@localhost src]# cd mysql-5.6.26
[root@localhost mysql-5.6.26]# useradd -u 8003 -M -s /sbin/nologin mysql
[root@localhost mysql-5.6.26]# yum -y install ncurses-devel cmake
[root@localhost mysql-5.6.26]#cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_USER=mysql
[root@localhost mysql-5.6.26]# make && make install
[root@localhost mysql-5.6.26]# chown -R mysql:mysql /usr/local/mysql/
[root@localhost mysql-5.6.26]# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
[root@localhost mysql-5.6.26]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@localhost mysql-5.6.26]# cd
[root@localhost ~]# vim /etc/init.d/mysqld
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
[root@localhost ~]# chkconfig mysqld on
[root@localhost ~]# /usr/local/mysql/scripts/mysql_install_db
–defaults-file=/etc/my.cnf
–basedir=/usr/local/mysql
–datadir=/usr/local/mysql/data –user=mysql
[root@localhost ~]# service mysqld start
[root@localhost ~]# ln -s /usr/local/mysql/bin/* /usr/bin/