linux 安装mysql
源码包位置/usr/local/src/MySQL-5.6.22.tar.gz
以下步骤:
1、cd /usr/local/src
2、tar -zxvf mysql-5.6.22.tar.gz
3、cd mysql-5.6.22
4、检查是否安装了cmake,未安装则安装
yum -y install cmake
5、创建mysql用户、组、数据目录
groupadd mysql
useradd -r -g mysql mysql
mkdir -p /usr/local/mysql/data
chown -R mysql:mysql /usr/local/mysql
6、预编译
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DMYSQL_TCP_PORT=3306
7、make & make install
8、初始化数据库
cd /usr/local/mysql/
vi /etc/my.cnf
输入并保存
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
user=mysql
初始化数据库:
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/
cp support-files/mysql.server /etc/init.d/mysqld
9、service mysqld start