首先官网下载安装包https://dev.mysql.com/downloads/mysql/5.7.html#downloads
然后上传解压至/usr/local目录
[root@localhost db]# tar -xf mysql-5.7.26-linux-glibc2.12-x86_64.tar [root@localhost db]# tar -xzf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz [root@localhost db]# mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql [root@localhost db]#
然后创建mysql用户和组以及数据目录
[root@localhost db]# mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql [root@localhost db]# groupadd mysql [root@localhost db]# useradd mysql -g mysql [root@localhost db]# cd /usr/local/mysql [root@localhost mysql]# mkdir data [root@localhost mysql]# chown mysql: -R /usr/local/mysql/ [root@localhost mysql]#
然后初始化数据并记录临时密码
[root@localhost mysql]# bin/mysqld --initialize --user=mysql --datadir /usr/local/mysql/data 2019-07-26T01:34:24.479757Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-07-26T01:34:24.682695Z 0 [Warning] InnoDB: New log files created, LSN=45790 2019-07-26T01:34:24.717419Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2019-07-26T01:34:24.723157Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8009a802-af45-11e9-839c-000c29984aae. 2019-07-26T01:34:24.723996Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2019-07-26T01:34:24.724629Z 1 [Note] A temporary password is generated for root@localhost: ucZ5w5ZkSq;1 [root@localhost mysql]#
然后修改/etc/my.cnf配置文件中datadir为/usr/local/mysql/data
[root@localhost mysql]# cat /etc/my.cnf [mysqld] datadir=/usr/local/mysql/data [root@localhost mysql]#
然后将mysql加入init.d目录并启动mysql
[root@localhost mysql]# cp support-files/mysql.server /etc/init.d/mysqld [root@localhost mysql]# /etc/init.d/mysqld start Starting MySQL.Logging to '/usr/local/mysql/data/localhost.localdomain.err'. SUCCESS! [root@localhost mysql]# ps -ef|grep mysql root 12957 1 0 09:37 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/localhost.localdomain.pid mysql 13057 12957 4 09:37 pts/0 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=localhost.localdomain.err --pid-file=/usr/local/mysql/data/localhost.localdomain.pid root 13092 10198 0 09:37 pts/0 00:00:00 grep --color=auto mysql [root@localhost mysql]#
最后mysql/bin加入path,并登陆数据库并重设密码
[root@localhost bin]# ./mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.26 Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> set password=password('mysql'); Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> exit Bye [root@localhost bin]# ./mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) [root@localhost bin]# ./mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.26 MySQL Community Server (GPL) Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.01 sec) mysql>
ojbk,then have fun!
总结
以上所述是小编给大家介绍的OEL7.6源码安装MYSQL5.7的教程,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对网站的支持!
如果你觉得本文对你有帮助,欢迎转载,烦请注明出处,谢谢!
华山资源网 Design By www.eoogi.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
华山资源网 Design By www.eoogi.com
暂无评论...
稳了!魔兽国服回归的3条重磅消息!官宣时间再确认!
昨天有一位朋友在大神群里分享,自己亚服账号被封号之后居然弹出了国服的封号信息对话框。
这里面让他访问的是一个国服的战网网址,com.cn和后面的zh都非常明白地表明这就是国服战网。
而他在复制这个网址并且进行登录之后,确实是网易的网址,也就是我们熟悉的停服之后国服发布的暴雪游戏产品运营到期开放退款的说明。这是一件比较奇怪的事情,因为以前都没有出现这样的情况,现在突然提示跳转到国服战网的网址,是不是说明了简体中文客户端已经开始进行更新了呢?
更新日志
2024年12月24日
2024年12月24日
- 小骆驼-《草原狼2(蓝光CD)》[原抓WAV+CUE]
- 群星《欢迎来到我身边 电影原声专辑》[320K/MP3][105.02MB]
- 群星《欢迎来到我身边 电影原声专辑》[FLAC/分轨][480.9MB]
- 雷婷《梦里蓝天HQⅡ》 2023头版限量编号低速原抓[WAV+CUE][463M]
- 群星《2024好听新歌42》AI调整音效【WAV分轨】
- 王思雨-《思念陪着鸿雁飞》WAV
- 王思雨《喜马拉雅HQ》头版限量编号[WAV+CUE]
- 李健《无时无刻》[WAV+CUE][590M]
- 陈奕迅《酝酿》[WAV分轨][502M]
- 卓依婷《化蝶》2CD[WAV+CUE][1.1G]
- 群星《吉他王(黑胶CD)》[WAV+CUE]
- 齐秦《穿乐(穿越)》[WAV+CUE]
- 发烧珍品《数位CD音响测试-动向效果(九)》【WAV+CUE】
- 邝美云《邝美云精装歌集》[DSF][1.6G]
- 吕方《爱一回伤一回》[WAV+CUE][454M]