CENTOS7下编译安装MYSQL5.5

1、yum -y install cmake ncurses-devel bison
2、mkdir -pv /mydata/data
3、tar xf mysql-5.5.33.tar -C /usr/local
4、cd /usr/localmysql-5.5.33
5、cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/mydata/data \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DWITH_SSL=system \
-DWITH_ZLIB=system \
-DWITH_LIBWRAP=0 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
6、make && make install
7、groupadd -g 306 mysql
8、useradd -g mysql -u 306 -r -s /sbin/nologin mysql
9、cd /usr/local/mysql
10、chown -R .mysql ./*
11、chonw -R mysql.mysql /myda/data
12、scripts/mysql_install_db --user=mysql --datadir=/mydata/data
13、ls /mydata/data #看看是否有数据
14、cp support-files/mysql.server /etc/init.d/mysqld
15、chmod +x /etc/init.d/mysqld
16、ckcofing --add mysqld
17、cp support-files/my-large.cnf /etc/my.cnf
18、vim /etc/my.cnf
新增一行datadir=/mydata/data
19、vim /etc/profile.d/mysql.sh
新增一行export PATH=/usr/local/mysql/bin:$PATH
20、systemctl start mysqld
21、然后执行mysql命令就可以进入数据库啦！
22、use mysql
23、update user set password=password('your_password') where user='root'; #改密码
24、flush privileges

转载于:https://blog.51cto.com/12276015/2400338