最全的mysql 5.7.13_最全的mysql 5.7.13 安装配置方法图文教程(linux) 强烈推荐!

男娘i 2023-01-12 14:55 120阅读 0赞

linux环境Mysql 5.7.13安装教程分享给大家，供大家参考，具体内容如下

1系统约定

安装文件下载目录：/data/software

Mysql目录安装位置：/usr/local/mysql

数据库保存位置：/data/mysql

日志保存位置：/data/log/mysql

2下载mysql

![b776cac4ad216306a73867be6db9d4f9.png][]

执行如下命名：

\#mkdir /data/software

\#cd /data/software

\#wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.13-linux-glibc2.5-x86\_64.tar.gz

3解压压缩包到目标位置

\# mkdir /usr/local/mysql

\#cd /dat/software

\#pwd

执行后如下：

![c339eee46a6e8231f6910921b5e5d589.png][]

\#ls

![f6394d70ec954241805c6634146894de.png][]

\#cd /usr/local

\#pwd

![cc7fabe30dae2824d824359a68cf6019.png][]

\# tar -xzvf /data/software/mysql-5.7.13-linux-glibc2.5-x86\_64.tar.gz

![cd80bc773979a0331278c255e20838e5.png][]

\#ls

![c4d58c490288004c2c7419e3bfe96d64.png][]

\--修改文件名

\# mv mysql-5.7.13-linux-glibc2.5-x86\_64 mysql

\#ls

![ad93a952ed7065a0d2621c76debb488b.png][]

4创建数据仓库目录

\--/data/mysql 数据仓库目录

\# mkdir /data/mysql

\#ls /data/

![c1f6929c41cabfd1f99fd0a4d9d76075.png][]

5新建mysql用户、组及目录

\# ---新建一个msyql组

\# useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql ---新建msyql用户禁止登录shell

6改变目录属有者

\#cd /usr/local/mysql

\#pwd

\#chown –R mysql .

\#chgrp –R mysql .

![3b4e613e760fdba9d5908764583ec9b6.png][]

\#chown -R mysql /data/mysql

7配置参数

\# bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

![3471709b53cf87dbc6cf4d54dedcec7a.png][]

此处需要注意记录生成的临时密码，如上文：YLi>7ecpe;YP

\#bin/mysql\_ssl\_rsa\_setup --datadir=/data/mysql

![6c8268897190baaf7599047b1ab796ec.png][]

8修改系统配置文件

![5643f07748914992d0875e411b12559b.png][]

\# cp my-default.cnf /etc/my.cnf

\# cp mysql.server /etc/init.d/mysql

![ba944c57647a8ee73f91bd82a0e4e47c.png][]

\# vim /etc/init.d/mysql

修改以下内容：

![873d75babb52e6c2477a2c8240d57be7.png][]

\# vim /etc/my.cnf

修改以下内容：

![5580ab5d3d3175b3ab08a22cf7d56d7b.png][]

![b7a766d5f1139660cca4560bcbe0ff07.png][]

![70b0df175162717fa9c255533f4112b9.png][]

9启动mysql

![ee9086e2a251c7f0d210e10483695521.png][]

\#bin/mysqld\_safe --user=mysql &

![c90e1dc1dd402b161f629388f909cc4b.png][]

bin/mysql --user=root –p

\--输入第6步生成的临时密码

![dff68c0c96d28d5766565c96a93267fd.png][]

![62d12ec8a0b7924433daef4f5c48f0fe.png][]

mysql> set password=password('A123456');

![6003561e79bd82db2d53c4c89c8348cb.png][]

mysql>grant all privileges on \*.\* to root@'%' identified by 'A123456';

mysql> flush privileges;

![affafb2a7d8171a6373a25f2c5367cbb.png][]

mysql> use mysql;

mysql> select host,user from user;

![77bc337a459cb22709ea3f6326960457.png][]

10添加系统路径

\# vim /etc/profile

添加：

export PATH=/usr/local/mysql/bin:$PATH

如下：

![4f5097490b24c9a84d7b95431650b7ab.png][]

\# source /etc/profile

11配置mysql自动启动

\# chmod 755 /etc/init.d/mysql

\# chkconfig --add mysql

\# chkconfig --level 345 mysql on

以上就是linux环境Mysql 5.7.13安装教程的第一套方案，希望对大家的学习有所帮助。

本文实例为大家分享了Linux mysql5.7.13安装教程，供大家参考，具体内容如下

1、准备cmake-3.6.0.tar.gz

bison-3.0.4.tar.gz

mysql-5.7.13.tar.gz (http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.13.tar.gz)

2、安装cmake 和 bison首先可以查看下是否安装了 cmake

\# rpm -qa |grep cmake

\# tar zxvf cmake-3.6.0.tar.gz

\# cd cmake-3.6.0

\# ./bootstrap

\# make && make install

\# tar zxvf bison-3.0.4.tar.gz

\# cd bison-3.0.4

\# ./configure

\# make && make install

3、安装Mysql

\[root@localhost src\]\# tar -zxvf mysql-5.7.13.tar.gz

\[root@localhost src\]\# cd mysql-5.7.13

\[root@localhost mysql-5.7.13\]\# cmake -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql -DMYSQL\_UNIX\_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT\_CHARSET=gbk -DDEFAULT\_COLLATION=gbk\_chinese\_ci -DWITH\_INNOBASE\_STORAGE\_ENGINE=1 -DWITH\_ARCHIVE\_STORAGE\_ENGINE=1 -DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1 -DMYSQL\_DATADIR=/data/mysqldb -DMYSQL\_TCP\_PORT=3306 -DENABLE\_DOWNLOADS=1

...

CMake Error at cmake/boost.cmake:81 (MESSAGE):

You can download it with -DDOWNLOAD\_BOOST=1 -DWITH\_BOOST=

This CMake script will look for boost in . If it is not there,

it will download and unpack it (in that directory) for you.

If you are inside a firewall, you may need to use an http proxy:

export http\_proxy=http://example.com:80

Call Stack (most recent call first):

cmake/boost.cmake:238 (COULD\_NOT\_FIND\_BOOST)

CMakeLists.txt:451 (INCLUDE)

\-- Configuring incomplete, errors occurred!

![d5cbe615e589d2c07d1c86d0016dac17.png][]

注：重新运行配置，需要删除CMakeCache.txt文件

解决：

(1)在预编译时添加相应的选项：cmake -DDOWNLOAD\_BOOST=1 -DWITH\_BOOST=/usr/local/boost

(2)或者下载一个boost包，放到/usr/local/boost目录下，然后在cmake后面加选项-DWITH\_BOOST=/usr/local/boost

....

CMake Error at cmake/readline.cmake:64 (MESSAGE):

Curses library not found. Please install appropriate package,

remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.

Call Stack (most recent call first):

cmake/readline.cmake:107 (FIND\_CURSES)

cmake/readline.cmake:181 (MYSQL\_USE\_BUNDLED\_EDITLINE)

CMakeLists.txt:479 (MYSQL\_CHECK\_EDITLINE)

\-- Configuring incomplete, errors occurred!

See also "/usr/local/src/mysql-5.7.13/CMakeFiles/CMakeOutput.log".

See also "/usr/local/src/mysql-5.7.13/CMakeFiles/CMakeError.log".

解决：

(1)安装ncurses-devel

yum -y install ncurses-devel(2)删除CMakeCache.txt

rm CMakeCache.txt(3)重新cmake

\[root@localhost mysql-5.7.13\]\# cmake -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql -DMYSQL\_UNIX\_ADDR=mysql.mysql -DDEFAULT\_CHARSET=gbk -DDEFAULT\_COLLATION=gbk\_chinese\_ci -DWITH\_INNOBASE\_STORAGE\_ENGINE=1 -DWITH\_ARCHIVE\_STORAGE\_ENGINE=1 -DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1 -DMYSQL\_DATADIR=/data/mysqldb -DMYSQL\_TCP\_PORT=3306 -DENABLE\_DOWNLOADS=1 -DDOWNLOAD\_BOOST=1 -DWITH\_BOOST=/usr/local/boost

\[root@localhost mysql-5.7.13\]\# make\[root@localhost mysql-5.7.13\]\# make install

精彩专题分享：

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。

[b776cac4ad216306a73867be6db9d4f9.png]: /images/20221119/ad23b841cc624b6d8308a38afe3ec8b4.png
[c339eee46a6e8231f6910921b5e5d589.png]: /images/20221119/e242ea34b9a24da689ebee5f8a94dbfc.png
[f6394d70ec954241805c6634146894de.png]: /images/20221119/e9188b5945d146808f4950847c99a297.png
[cc7fabe30dae2824d824359a68cf6019.png]: /images/20221119/b883aabd9ab64c01b8fd7b822186a2ce.png
[cd80bc773979a0331278c255e20838e5.png]: /images/20221119/7bfc18ae6b0d4588a70a42df97517a33.png
[c4d58c490288004c2c7419e3bfe96d64.png]: /images/20221119/3c99738e312b4137b73c907356e3447d.png
[ad93a952ed7065a0d2621c76debb488b.png]: /images/20221119/c58378c4de3747da917d750798a90fc2.png
[c1f6929c41cabfd1f99fd0a4d9d76075.png]: /images/20221119/f0e6bb775ec4454da3235332e7ecf880.png
[3b4e613e760fdba9d5908764583ec9b6.png]: /images/20221119/ddd90c1844634a35be5bce727841d824.png
[3471709b53cf87dbc6cf4d54dedcec7a.png]: /images/20221119/473277072e294a19923b37ea8e9415c7.png
[6c8268897190baaf7599047b1ab796ec.png]: /images/20221119/ed5be0b5320f43169cc019848c970ca4.png
[5643f07748914992d0875e411b12559b.png]: /images/20221119/5f9e526c2e5446dea40451d7386ebefc.png
[ba944c57647a8ee73f91bd82a0e4e47c.png]: /images/20221119/c43a7075fce844cdb8eeaf7eae8d7097.png
[873d75babb52e6c2477a2c8240d57be7.png]: /images/20221119/ef560413a1684b1a82bf40196a1c9009.png
[5580ab5d3d3175b3ab08a22cf7d56d7b.png]: /images/20221119/799bc219c36f44a28f861f68b06d3662.png
[b7a766d5f1139660cca4560bcbe0ff07.png]: /images/20221119/c8d023e604e541cdb887a9e8971b8f58.png
[70b0df175162717fa9c255533f4112b9.png]: /images/20221119/b50ddc8e18874a0e82ea2ab873d88fd6.png
[ee9086e2a251c7f0d210e10483695521.png]: /images/20221119/b3a0313b7b1b4cf5babe833766ce3e52.png
[c90e1dc1dd402b161f629388f909cc4b.png]: /images/20221119/199833bbde774b12bae59a0fc319434d.png
[dff68c0c96d28d5766565c96a93267fd.png]: /images/20221119/f8e8731a88cc481e80bf0dd7ea6d09cc.png
[62d12ec8a0b7924433daef4f5c48f0fe.png]: /images/20221119/3dbe42b182b648ea9f1ba34b4d8868f9.png
[6003561e79bd82db2d53c4c89c8348cb.png]: /images/20221119/14ec1181a38a4b3ca72bc58dfe3f8fcb.png
[affafb2a7d8171a6373a25f2c5367cbb.png]: /images/20221119/8806bea33ecd49e4a044c6cd7dce14dc.png
[77bc337a459cb22709ea3f6326960457.png]: /images/20221119/7410d1fd2e4d4ccb86d7f7cdceda27e9.png
[4f5097490b24c9a84d7b95431650b7ab.png]: /images/20221119/b9851ebf59514439818872cf5ed580ee.png
[d5cbe615e589d2c07d1c86d0016dac17.png]: /images/20221119/f6b094de7e6b4e84b572b21317e7d019.png