#下载MYSQL 8.0版本; http://mirrors.sohu.com/mysql/MySQL-8.0/mysql-boost-8.0.28.tar.gz
#安装高版本GCC源; yum -y install centos-release-scl
#安装依赖包和库文件; yum -y install ncurses-devel make perl gcc autoconf automake zlib libxml2 libxml2-devel libgcrypt libtool bison devtoolset-10-gcc devtoolset-10-gcc-c++ devtoolset-10-binutils openssl openssl-devel
#启用新版Gcc; scl enable devtoolset-10 bash
#解压MYSQL8.x软件包; tar xzf mysql-boost-8.0.28.tar.gz
#进入MYSQL8.x源代码目录; cd mysql-8.0.28/
#预编译; cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/ \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DMYSQL_DATADIR=/data/mysql/ \ -DSYSCONFDIR=/etc \ -DMYSQL_USER=mysql \ -DMYSQL_TCP_PORT=3306 \ -DWITH_XTRADB_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_READLINE=1 \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_EXTRA_CHARSETS=1 \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DEXTRA_CHARSETS=all \ -DWITH_BIG_TABLES=1 \ -DWITH_DEBUG=0 \ -DWITH_BOOST=./boost/ \ -DFORCE_INSOURCE_BUILD=1
#编译; make -j4
#安装; make -j4 install
#初始化MYSQL数据库; /usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/
#设置MYSQL为系统服务; ln -s /usr/local/mysql/bin/* /usr/bin/ \cp support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/init.d/mysqld /etc/init.d/mysqld start
#默认源码安装初始化MYSQL没有密码,直接进入数据库; mysql
#修改密码规则和长度限制; set global validate_password.policy=0; set global validate_password.length=1;
#修改密码为aaaAAA111.,指令如下; ALTER USER 'root'@'localhost' IDENTIFIED BY 'aaaAAA111.';
#创建用户&授权jfedu用户访问; create user jfedu@'%' identified by 'aaaAAA111.';
grant all on *.* to jfedu@'%';
#默认root用户不能远程登录,需要更新密码信息; update mysql.user set host='%' where user="root"; ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'aaaAAA111.'; grant system_user on *.* to 'root'; flush privileges; |