linux系统安装mysql

约定不等于承诺〃 2021-12-23 19:55 274阅读 0赞

### 一、首先在oracle官网下载mysql的压缩包 ###

![1136550-20180903164300941-1034022556.png][]

![1136550-20180903164355796-793342619.png][]

![1136550-20180903164434612-351942747.png][]

![1136550-20180903164549948-16397660.png][]

### 下载此tar包，并通过ftp上传到服务器，通过xshell解压到对应的路径下，检查系统是否安装了mariadb，因为它是mysql的分支，安装mysql两者会有冲突 ###

//检查命令
    yum list installed | grep mariadb
    //卸载命令
    yum -y remove mariadb-libs.x86_64

![1136550-20180903165036252-298849078.png][]

### 创建data目录，用于储存数据库表数据 ###

mkdir data

### 安装mysql ###

./mysqld --initialize --user=mysql --datadir=/usr/local/mysql-5.7.17/data --basedir=/usr/local/mysql-5.7.17

![1136550-20180903165249214-451174499.png][]

**安装后的初始密码如上，需记录，用于一会mysql的登录：.hOXYhVRu3um**

### 启用安全功能，生成数字证书 ###

./mysql_ssl_rsa_setup --datadir=/usr/local/mysql-5.7.17/data

![1136550-20180903165914306-397892560.png][]

**数据证书文件**

![1136550-20180903170132794-728078753.png][]

### 给整个mysql的安装目录赋值权限 ###

chown -R mysql:mysql /usr/local/mysql-5.7.17/

![1136550-20180903170653913-1037589940.png][]

### 启动mysql ###

//&表示从后台启动
    ./mysqld_safe &

![1136550-20180903172606912-1314996697.png][]

//查看进程
    ps -ef|grep mysql

![1136550-20180903172645786-548037901.png][]

### 使用mysql ###

//在bin目录下执行
    ./mysql -uroot -p
    //执行后粘贴密码

![1136550-20180903173222422-647022321.png][]

### 进入后需要先修改密码 ###

//修改密码语句
    alter user 'root'@'localhost' identified by '123456';

![1136550-20180903173733146-1427974475.png][]

### 授予远程访问，受权限之前，在本机安装的mysql，只能本机访问这个mysql，通过授予权限任何服务器都可以访问，也可以指定某个服务器进行访问 ###

grant all privileges on *.* to root@'%' identified by '123456';
    //其中*.*的第一个*表示数据库名，第二个*表示所有的数据库表
    //root@'%'root表示数据库用户名，%表示ip地址，也可以指定具体的ip地址：root@'135.149.96.53'

![1136550-20180903174832398-798856303.png][]

授权成功，通过navicat连接，连接成功

![1136550-20180903175030227-1924151817.png][]

退出mysql

![1136550-20180903175500723-1863683273.png][]

### 关闭mysql服务 ###

//关闭mysql服务
    ./mysqladmin -uroot -p shutdown

![1136550-20180903175732131-930454082.png][]

mysql服务已关闭。

### 将mysqld服务加入开机自启动项 ###

将mysql下的support-files复制到etc/init.d/mysql下

cd  /usr/local/mysql/support-files/
    cp mysql.server /etc/init.d/mysql
    //添加可执行此文件的权限
    chmod +x /etc/init.d/mysql

\-- 把mysql注册为开机启动的服务

chkconfig --add mysql
    //查看启动项中是否有mysql
    chkconfig --list mysql

![1136550-20180904164040004-287601432.png][]

### //启动mysql服务 service mysql start  ###

### //关闭mysql服务 service mysql stop ###

### 设置utf8字符集编码： ###

复制support-files文件下的my-default.cnf到/etc/my.cnf

cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

![1136550-20180904165019352-465052187.png][]

转载于:https://www.cnblogs.com/xiaotang5051729/p/9561643.html

[1136550-20180903164300941-1034022556.png]: /images/20211223/a597c3cf421f4e2699cde5c35db51de2.png
[1136550-20180903164355796-793342619.png]: /images/20211223/28cfd96e19384f38abdab2d7f0da215c.png
[1136550-20180903164434612-351942747.png]: /images/20211223/a39a35077b6847399918eadce5cef2c3.png
[1136550-20180903164549948-16397660.png]: /images/20211223/e1b43d83ef1f44888d36159812cffb48.png
[1136550-20180903165036252-298849078.png]: /images/20211223/e5bc4034ea214c5996dfa77a19f18839.png
[1136550-20180903165249214-451174499.png]: /images/20211223/55ec1aa5516d49ff974cd9ab3ddc30dd.png
[1136550-20180903165914306-397892560.png]: /images/20211223/4e26d7f4ace14ffb8b29a1c603ae2fa9.png
[1136550-20180903170132794-728078753.png]: /images/20211223/5695f12500c64ea3b4c120b27a0e6837.png
[1136550-20180903170653913-1037589940.png]: /images/20211223/d5ff2904492f4c6d99255e5aa10473be.png
[1136550-20180903172606912-1314996697.png]: /images/20211223/2fcc0246a0ee47e8b34028354851db00.png
[1136550-20180903172645786-548037901.png]: /images/20211223/daa076cea668463a9cd53a145265a607.png
[1136550-20180903173222422-647022321.png]: /images/20211223/c842430bdb864a8c80b03bb642654915.png
[1136550-20180903173733146-1427974475.png]: /images/20211223/d803891bdc974e888722a8ea4468a88f.png
[1136550-20180903174832398-798856303.png]: /images/20211223/09faafec23f84c62b5a67767c306bb2e.png
[1136550-20180903175030227-1924151817.png]: /images/20211223/b3afc5fa13c84beda482080a160e0ea6.png
[1136550-20180903175500723-1863683273.png]: /images/20211223/0f39419774cf4a83915608389f05c59d.png
[1136550-20180903175732131-930454082.png]: /images/20211223/8cddd0dbc1dc455691ef5bfe26cd03a0.png
[1136550-20180904164040004-287601432.png]: /images/20211223/a7be0f538c634b9ba3c523a18081891c.png
[1136550-20180904165019352-465052187.png]: /images/20211223/8fdd330e06824e9fa259ff40c0efab5a.png