Linux ARM架构-MySQL安装-银河麒麟V10操作系统
<h1 id="linux-arm架构-mysql安装-银河麒麟v10操作系统">Linux ARM架构-MySQL安装-银河麒麟V10操作系统</h1><h2 id="mysql-8029版本下载">MySQL 8.0.29版本下载</h2>
<p>直接官网下载：</p>
<p>https://dev.mysql.com/downloads/mysql/</p>
<p>选择版本：</p>
<p><img src="https://img2023.cnblogs.com/blog/1644414/202302/1644414-20230209142659262-140983754.png" alt="" loading="lazy"></p>
<h2 id="安装mysql">安装MySQL</h2>
<h3 id="删除原有的mariadb">删除原有的mariadb</h3>
<p>先查看一下是否已经安装了</p>
<pre><code class="language-shell">rpm -qa|grep mariadb
</code></pre>
<p>删除mariadb，命令：</p>
<pre><code class="language-shell">rpm -e --nodeps mariadb-libs
rpm -e mariadb-server --nodeps
</code></pre>
<h3 id="解压缩mysql离线安装包">解压缩mysql离线安装包</h3>
<pre><code class="language-bash">tar xvf mysql-8.0.31-1.el8.aarch64.rpm-bundle.tar
</code></pre>
<p>逐个安装，命令如下：</p>
<p>【必须安装】</p>
<pre><code class="language-shell">rpm -ivh mysql-community-common-8.0.31-1.el8.aarch64.rpm
rpm -ivh mysql-community-client-plugins-8.0.31-1.el8.aarch64.rpm
rpm -ivh mysql-community-libs-8.0.31-1.el8.aarch64.rpm
rpm -ivh mysql-community-client-8.0.31-1.el8.aarch64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.31-1.el8.aarch64.rpm
rpm -ivh mysql-community-server-8.0.31-1.el8.aarch64.rpm
rpm -ivh mysql-community-devel-8.0.31-1.el8.aarch64.rpm
</code></pre>
<p>查看 mysql</p>
<pre><code class="language-bash">rpm -qa | grep mysql
</code></pre>
<h2 id="初始化mysql服务">初始化mysql服务</h2>
<h3 id="查看服务状态">查看服务状态</h3>
<p>命令：</p>
<pre><code class="language-bash">systemctl status mysqld
</code></pre>
<p>接下来要启动MySQL，通过执行以下命令启动：</p>
<pre><code class="language-bash">systemctl start mysqld
</code></pre>
<h3 id="配置mysql">配置MySQL</h3>
<p>MySQL安装完成后需要对MySQL做基础配置，包括首次登录修改用户密码、数据文件位置调整、redo log大小与数量调整、undo 表空间调整、ibdata表空间调整、binlog+errorlog+slowlog+pid+socket等文件调整、性能参数调整，这些调整都可以通过修改my.cnf参数文件实现。</p>
<p>4.1 首次登录</p>
<p>在MySQL安装完成第一次启动MySQL服务后，会自动为MySQL的root用户生成一个随机初始化密码，并在MySQL的errorlog文件中记录下来，我们要找到它并用它登录MySQL，修改root用户密码后才能执行任何其它操作：</p>
<ul>
<li>找到初始化密码</li>
</ul>
<pre><code>grep password /var/log/mysqld.log
</code></pre>
<p>下图绿色方框中即为初始化密码</p>
<p><img src="https://img2023.cnblogs.com/blog/1644414/202302/1644414-20230209142737784-1216565133.png" alt="" loading="lazy"></p>
<ul>
<li>使用上面的初始化密码登录MySQL</li>
</ul>
<pre><code class="language-bash">mysql -uroot -p
</code></pre>
<ul>
<li>修改root密码</li>
</ul>
<p>使用初始化密码登录MySQL后只能执行修改密码的操作，其它任何操作是不能执行的，使用以下命令修改密码：</p>
<pre><code class="language-sql">SQL>alter user user() identified by 'LaoGeDB123!';
</code></pre>
<p><img src="https://img2023.cnblogs.com/blog/1644414/202302/1644414-20230209142756776-974908043.png" alt="" loading="lazy"></p>
<p>密码修改成功后，执行以下命令查看MySQL基本信息：</p>
<pre><code class="language-sql">SQL>status
</code></pre>
<p><img src="https://img2023.cnblogs.com/blog/1644414/202302/1644414-20230209142812904-421253370.png" alt="" loading="lazy"></p>
<ul>
<li>授权远程连接</li>
</ul>
<p>查看当前权限</p>
<pre><code class="language-sql">命令：show databases;
命令：use mysql;
命令：select host, user, plugin from user;
</code></pre>
<p>授权远程访问</p>
<pre><code class="language-sql">命令：update user set host = "%" where user='root';
命令：select host, user, plugin from user;
命令：flush privileges;
</code></pre>
<p><img src="https://img2023.cnblogs.com/blog/1644414/202302/1644414-20230209142825065-1033350811.png" alt="" loading="lazy"></p><br><br>
来源：https://www.cnblogs.com/liuweida/p/17105179.html
頁:
[1]