CentOS下安装Mysql 8.0步骤详解
<p><strong>本次安装Mysql的CentOS版本是7.7</strong></p><img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200512214405687-1797337078.png">
<h2 id="1下载mysql">1.下载Mysql</h2>
<p>首先去Mysql官网下载安装包，网址https://dev.mysql.com/downloads/mysql/<br>
推荐大家下载Linux通用版本的，便于管理安装位置，也方便一台服务器安装多个版本的mysql，下载后将Mysql安装包上传至服务器/usr/local/目录下<br>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200512215038266-601616243.png"></p>
<h2 id="2创建mysql用户和组">2.创建Mysql用户和组</h2>
<pre><code class="language-shell">groupadd mysql #创建mysql组
useradd -r -d /home/mysql -g mysql mysql #创建mysql用户 并指定组和默认路径
chown -R mysql:mysql /home/mysql #将Mysql默认路径的用户和组改成mysql
</code></pre>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513203944240-1438873733.png">
<h2 id="3解压mysql">3.解压Mysql</h2>
<pre><code class="language-shell">tar -xvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz #解压安装包
ln -s mysql-8.0.11-linux-glibc2.12-x86_64 mysql #文件夹添加软链接为mysql
chown -R mysql:mysql /usr/local/mysql
</code></pre>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513203645260-1609019484.png">
<h2 id="4为mysql安装配置环境">4.为Mysql安装配置环境</h2>
<p>使用root用户编辑/etc/profile，将下面的内容添加到最下面,并执行<code>source /etc/profile</code>使配置生效</p>
<pre><code class="language-shell">export PATH=$PATH:/usr/local/mysql/bin
</code></pre>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513204801060-821835196.png">
<p>关闭防火墙，防火墙状态为inactive时表示关闭成功</p>
<pre><code class="language-shell">service firewalld stop
</code></pre>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513220903793-420970731.png">
<p>关闭SELinux，编辑/etc/selinux/config，将selinux=enforce改为disable即可</p>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513221100109-1826253812.png">
<h2 id="5创建mysql数据目录">5.创建Mysql数据目录</h2>
<pre><code class="language-shell">mkdir /usr/local/mysql/data #创建数据目录
chown mysql:mysql /usr/local/mysql/data #将数据目录的用户和组改成mysql
chmod 750 /usr/local/mysql/data #更改数据目录权限
</code></pre>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513211003840-2081216667.png">
<h2 id="6配置mycnf文件">6.配置my.cnf文件</h2>
<p>新建my.cnf配置文件，并添加以下内容</p>
<pre><code>
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=/usr/local/mysql/data/error.log
socket=/tmp/mysql.sock
pid-file=/usr/local/mysql/data/mysql.pid
character-set-server = utf8
lower_case_table_names=1
innodb_log_file_size=1G
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
port=3306
default-character-set=utf8
</code></pre>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513212716287-1191100763.png">
<h2 id="7初始化mysql">7.初始化Mysql</h2>
<p>执行下面的命令初始化mysql，结束后查看/data/error.log，显示(mysqld 8.0.11) initializing of server has completed就代表Mysql初始化成功了</p>
<pre><code class="language-shell">bin/mysqld --initialize --user mysql
</code></pre>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513212951047-545327655.png">
<h2 id="8启动mysql">8.启动Mysql</h2>
<p>执行<code>support-files/mysql.server start</code>启动mysql，启动成功后可查看到mysql的进程</p>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513213531721-2127165024.png">
<h2 id="9登录mysql">9.登录Mysql</h2>
<p>通过查看/data/error.log获取Mysql的初始化密码，并登录mysql</p>
<pre><code class="language-shell">mysql -u root -p
</code></pre>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513214016338-1826485453.png">
----------
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513214226383-840687189.png">
<h2 id="10修改root用户密码">10.修改root用户密码</h2>
<p>通过下面的语句可以修改root用户的密码</p>
<pre><code class="language-sql">ALTER USER 'root'@'localhost' IDENTIFIED BY 'root_123';
</code></pre>
<p>为远程登录创建用户,并赋权</p>
<pre><code>CREATE USER 'root'@'%' IDENTIFIED BY 'root_123';
GRANT ALL ON*.*TO 'root'@'%';
FLUSH PRIVILEGES;
</code></pre>
<p>这样就可以通过navicat等工具进行远程连接了<br>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513220507600-330437084.png"></p>
<h2 id="11配置mysql开机自启">11.配置mysql开机自启</h2>
<p>首先将mysql.server 复制到/etc/init.d下面</p>
<pre><code class="language-shell">cp support-files/mysql.server /etc/init.d/mysqld
</code></pre>
<p>通过chkconfig将mysql服务添加到开机启动的列表里面就可以了</p>
<pre><code class="language-shell">chkconfig --add mysqld
</code></pre>
<img src="https://img2020.cnblogs.com/blog/2030016/202005/2030016-20200513221659263-2063209683.png">
<h4 id="以上就是centos-77下安装mysql-80的全部过程了欢迎大家参考和提问">以上就是CentOS 7.7下安装Mysql 8.0的全部过程了，欢迎大家参考和提问</h4><br><br>
来源：https://www.cnblogs.com/hedwiglzy/p/12888598.html
頁:
[1]