msyql8.0编译安装
1、安装依赖
yum -y install wget cmake gcc gcc-c++ncurses ncurses-devel libaio-devel openssl openssl-devel
2、下载安装包
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-boost-8.0.11.tar.gz (此版本带有boost)
3、创建mysql组
groupadd mysql
创建mysql用户
$ useradd -g mysql mysql
4、创建安装目录和数据目录
mkdir -p /usr/local/mysql
5、解压源码包
tar -zxvf mysql-boost-8.0.11.tar.gz -C /usr/local
6、编译安装(这里需要一点时间，还需要一定的内存！！我的虚拟机是3个G的内存)
cd /usr/local/mysql-8.0.11
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DMYSQL_TCP_PORT=3306 -DWITH_BOOST=/usr/local/mysql-8.0.11/boost
make && make install
7、配置my.cnf文件
>/etc/my.cnf
vi /etc/my.cnf
多次踩坑之后，我的my.cnf内容是
[mysqld]
socket=/tmp/mysql.sock
symbolic-links=0
server-id=1
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
default_authentication_plugin=mysql_native_password
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysqld.pid
!includedir/etc/my.cnf.d
8、创建目录，并修改权限信息
mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld
mkdir /var/lib/mysql
mkdir /var/log/mariadb
touch /var/log/mariadb/mariadb.log
chown -R mysql:mysql /var/log/mariadb/
chown -R mysql:mysql /var/lib/mysql/
chown -R mysql:mysql /usr/local/mysql
chmod 755 /usr/local/mysql -R
9、初始化
bin/mysqld--initialize --user=mysql --datadir=/usr/local/mysql/data
此处会出现mysql登陆root密码 一定要记住密码
bin/mysql_ssl_rsa_setup
10、启动mysql
scripts/mysqld_safe--user=mysql &
11、使用root用户登录，注意原始密码的位置
bin/mysql -uroot -p
12、修改密码，设置远程登录，创建数据库实例(这里是mysql里语句操作)
--修改root密码
alter user 'root'@'localhost' identified by '123456';
-- 刷新系统权限表
FLUSH PRIVILEGES;
alter user 'root'@'localhost' identified with mysql_native_password by "123456";
-- 刷新系统权限表
FLUSH PRIVILEGES;
alter user 'root'@'localhost' identified with caching_sha2_password by "123456";
-- 刷新系统权限表
FLUSH PRIVILEGES;
--设置远程登陆权限
CREATE USER 'root'@'%' IDENTIFIED BY '123456';
-- 刷新系统权限表
FLUSH PRIVILEGES;
-- 授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTIO
GRANT select,insert,update,delete,create,drop,index,alter ON *.* TO 'root'@'%' WITH GRANT OPTION;
GRANT show databases,create temporary tables,create view,show view ON *.* TO 'root'@'%' WITH GRANT OPTION;
-- 刷新系统权限表
FLUSH PRIVILEGES;
创建数据库实例TEST
create database TEST DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
13、然后使用navicat或者toad for mysql连接一下，看一下防火墙是否关闭
14、设为开机自动启动
将服务文件拷贝到init.d下，并重命名为mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
赋予可执行权限
chmod +x /etc/init.d/mysqld
添加服务
chkconfig--add mysqld
显示服务列表
chkconfig–list
15、mysql用户下重启mysql服务
root用户下，找到刚才启动的mysql进程
ps -ef | grep mysqld
切换到mysql用户，启动服务
---------------------
作者：pk972703678
来源：CSDN
原文：https://blog.csdn.net/pk972703678/article/details/80469096
版权声明：本文为博主原创文章，转载请附上博文链接！
