Mysql实例MySQL5.7.10 安装文档教程详解

MYSQL必读
yum -y install gcc-c++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison

MYSQL必读
rpm -qa boost*

MYSQL必读
yum -y remove boost-*

MYSQL必读
# groupadd mysql
# mkdir /home/mysql #自定义位置
# mkdir /home/mysql/data #自定义位置
# useradd -g mysql -d /home/mysql mysql

MYSQL必读
cmake -DCMAKE_INSTALL_PREFIX=/home/mysql -DMYSQL_DATADIR=/home/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost

MYSQL必读
make && make install

MYSQL必读
./mysqld --initialize --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data

MYSQL必读
# mv /etc/my.cnf /etc/my.cnf.bak

MYSQL必读
# cd /mysql/support-files

MYSQL必读
# cp my-default.cnf /etc/my.cnf

MYSQL必读
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
[client]
default-character-set=utf8

MYSQL必读
cp /mysql/support-files/mysql.server /etc/init.d/mysqld

MYSQL必读
chmod 755 /etc/init.d/mysqld

MYSQL必读
ln -s /mysql/bin/mysql /usr/bin/

MYSQL必读
service mysqld start

MYSQL必读
mysql -uroot -p

MYSQL必读
alter user 'root'@'localhost' identified by '123456';