首页 > 数据库技术 > 详细

centos7源码安装mysql5.7.27

时间:2019-08-16 13:53:10      阅读:90      评论:0      收藏:0      [点我收藏+]

期间报了一万个错,快崩溃了,最后终于弄好了,特意记录一下:

yum -y install ncurses ncurses-devel bison cmake
yum install -y gcc gcc-c++
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.27.tar.gz #mysql5.7源码安装需要boost,这个包下载自带boost
mkdir -p /weblogic/mysql/mysql
mkdir -p /weblogic/mysql/datadir

以下整段为配置的命令

cmake . 
-DCMAKE_INSTALL_PREFIX=/weblogic/mysql/mysql -DMYSQL_DATADIR=/weblogic/mysql/datadir -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/my/mysql-5.7.27/boost -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

 

修改/etc/my.cnf

[mysqld]
user=mysql
basedir=/weblogic/mysql/mysql
datadir=/data/mysql
pid-file=/usr/local/mysql/mysql.pid
socket=/usr/local/mysql/mysql.sock


[mysqld_safe]
log-error=/usr/local/mysql/logs/mysqld.log
pid-file=/usr/local/mysql/pids/mysqld.pid

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[client]
default-character-set=utf8
socket=/usr/local/mysql/mysql.sock

[mysql]
default-character-set=utf8
socket=/usr/local/mysql/mysql.sock

创建配置文件中用到的而你系统中没有的目录

初始化mysql

./mysqld --initialize --user=mysql --basedir=/weblogic/mysql/mysql --datadir=/data/mysql

这一步执行完mysql会给出一个默认密码,需要记住

技术分享图片

 

把mysql.server复制到服务列表,并添加执行权限,方便管理

cp /weblogic/mysql/mysql/support-files/mysql.server /etc/init.d/msyqld
chmod +x /etc/init.d/msyqld

把mysql的bin目录添加到环境变量,方便使用

export PATH=/weblogic/mysql/mysql/bin:$PATH添加到/etc/profile最后一行,并且启用
source /etc/profile

启动服务

serivce mysqld start

 修改密码

mysqladmin -uroot -p你的初始密码 password

输入两次新密码后,密码修改完成

mysql -uroot -p你的新密码

登录后,开启数据库远程访问权限

grant all privileges  on *.* to root@% identified by "你的mysql密码";
flush privileges;

之后就可以随便用了

centos7源码安装mysql5.7.27

原文:https://www.cnblogs.com/yingyingdeyueer/p/11362798.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!