沙足 發表於 2024-10-29 16:27:00

银河麒麟系统V10安装mysql5.7

<p>1、cat&nbsp; /proc/version查看系统版本</p>
<p><img src="https://img2024.cnblogs.com/blog/2338621/202410/2338621-20241029155320759-1134536786.png"></p>
<p>2、官网（https://dev.mysql.com/downloads/mysql/）下载mysql</p>
<p><img src="https://img2024.cnblogs.com/blog/2338621/202410/2338621-20241029155411098-1567921149.png"></p>
<p>&nbsp;3、在服务器直接下载压缩包</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">wget</span> https:<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">downloads.mysql.com/archives/get/p/23/file/mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar</span></pre>
</div>
<p>4、创建upload目录存储压缩包</p>
<p>5、cd /upload/,解压缩到/usr/local目录下</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">tar</span> zxvf mysql-<span style="color: rgba(128, 0, 128, 1)">5.7</span>.<span style="color: rgba(128, 0, 128, 1)">38</span>-linux-glibc2.<span style="color: rgba(128, 0, 128, 1)">12</span>-x86_64.<span style="color: rgba(0, 0, 255, 1)">tar</span>.gz -C /usr/local</pre>
</div>
<p>6、cd /usr/local,文件夹重命名为mysql</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">mv</span> mysql-<span style="color: rgba(128, 0, 128, 1)">5.7</span>.<span style="color: rgba(128, 0, 128, 1)">18</span>-linux-glibc2.<span style="color: rgba(128, 0, 128, 1)">5</span>-x86_64/ mysql</pre>
</div>
<p>7、创建mysql用户组和用户</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)"># 创建MySQL用户组
groupadd mysql
# 添加MySQL用户并添加到MySQL用户组
useradd </span>-r -g mysql mysql</pre>
</div>
<p><img src="https://img2024.cnblogs.com/blog/2338621/202410/2338621-20241029161102621-276716232.png"></p>
<p>&nbsp;8、创建mysql存储数据目录</p>
<p><img src="https://img2024.cnblogs.com/blog/2338621/202410/2338621-20241029161211105-694654065.png"></p>
<p>&nbsp;9、赋予权限</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">chown</span> mysql:mysql -R /usr/local/mysql/data/</pre>
</div>
<p>10、配置my.cnf文件</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">
# 设置3306端口
port</span>=<span style="color: rgba(128, 0, 128, 1)">3306</span><span style="color: rgba(0, 0, 0, 1)">
# 设置mysql的安装目录
basedir</span>=/usr/local/<span style="color: rgba(0, 0, 0, 1)">mysql
# 设置mysql数据库的数据的存放目录
datadir</span>=/usr/local/mysql/<span style="color: rgba(0, 0, 0, 1)">data
# 允许最大连接数
max_connections</span>=<span style="color: rgba(128, 0, 128, 1)">200</span><span style="color: rgba(0, 0, 0, 1)">
# 允许连接失败的次数。
max_connect_errors</span>=<span style="color: rgba(128, 0, 128, 1)">10</span><span style="color: rgba(0, 0, 0, 1)">
# 服务端使用的字符集默认为utf8mb4
character</span>-set-server=<span style="color: rgba(0, 0, 0, 1)">utf8mb4
# 创建新表时将使用的默认存储引擎
default</span>-storage-engine=<span style="color: rgba(0, 0, 0, 1)">INNODB
# 默认使用“mysql_native_password”插件认证
#mysql_native_password
default_authentication_plugin</span>=<span style="color: rgba(0, 0, 0, 1)">mysql_native_password

# 设置mysql客户端默认字符集
default</span>-character-set=<span style="color: rgba(0, 0, 0, 1)">utf8mb4

# 设置mysql客户端连接服务端时默认使用的端口
port</span>=<span style="color: rgba(128, 0, 128, 1)">3306</span><span style="color: rgba(0, 0, 0, 1)">
default</span>-character-set=utf8mb4</pre>
</div>
<p>11、cd /usr/local/mysql/bin&nbsp; 初始化mysql</p>
<p>注意：</p>
<ul>
<li>--defaults-file：默认配置文件地址</li>
<li>--datadir：是刚刚创建的data数据目录</li>
<li>--basedir：是MySQL安装目录</li>
<li>--user：刚刚创建的mysql用户</li>
</ul>
<div class="cnblogs_code">
<pre>./mysqld --defaults-<span style="color: rgba(0, 0, 255, 1)">file</span>=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --initialize</pre>
</div>
<p><img src="https://img2024.cnblogs.com/blog/2338621/202410/2338621-20241029161751863-1952276588.png"></p>
<p>12、启动mysql服务</p>
<div class="cnblogs_code">
<pre>/usr/local/mysql/support-files/mysql.server start</pre>
</div>
<p><img src="https://img2024.cnblogs.com/blog/2338621/202410/2338621-20241029161850278-1806640956.png"></p>
<p>&nbsp;13、修改初始密码</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)"># 切换目录
cd </span>/usr/local/mysql/<span style="color: rgba(0, 0, 0, 1)">bin
# 登录命令
.</span>/mysql -u root -p</pre>
</div>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)"># 设置密码 password自己修改
SET PASSWORD </span>= PASSWORD(<span style="color: rgba(128, 0, 0, 1)">'password</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">);
# 设置用户的访问密码用不过期
ALTER USER </span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">root</span><span style="color: rgba(128, 0, 0, 1)">'</span>@<span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">localhost</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)"> PASSWORD EXPIRE NEVER;
#刷新权限
FLUSH PRIVILEGES;</span></pre>
</div>
<p>14、防火墙放开3306</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)"># 开启端口3306
firewall</span>-cmd --zone=public --add-port=<span style="color: rgba(128, 0, 128, 1)">3306</span>/tcp --<span style="color: rgba(0, 0, 0, 1)">permanent
# 重启防火墙
firewall</span>-cmd --<span style="color: rgba(0, 0, 0, 1)">reload
# 查看已经开放的端口
firewall</span>-cmd --list-ports</pre>
</div>
<p>15、设置开机自启动</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">ln</span> -s /usr/local/mysql/support-files/mysql.server /etc/init.d/<span style="color: rgba(0, 0, 0, 1)">mysql

</span><span style="color: rgba(0, 0, 255, 1)">ln</span> -s /usr/local/mysql/bin/mysql /usr/bin/<span style="color: rgba(0, 0, 0, 1)">mysql

service mysql restart</span></pre>
</div>
<p>16、授权</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">chmod</span> +x /etc/init.d/mysql</pre>
</div>
<p>17、添加服务</p>
<div class="cnblogs_code">
<pre>chkconfig --add mysql</pre>
</div>
<p>18、显示服务列表</p>
<div class="cnblogs_code">
<pre>chkconfig --list</pre>
</div>
<p><img src="https://img2024.cnblogs.com/blog/2338621/202410/2338621-20241029162556368-2032253590.png"></p>
<p>如上图所示，如果是2，3，4，5 都是开启的话则成功。<br>如果不是，可运行以下命令开启：</p>
<div class="cnblogs_code">
<pre>chkconfig --level <span style="color: rgba(128, 0, 128, 1)">2345</span> mysql on</pre>
</div>
<p>19、重启服务器，查看mysql进程</p>
<div class="cnblogs_code">
<pre>reboot</pre>
</div>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">ps</span> -aux | <span style="color: rgba(0, 0, 255, 1)">grep</span> mysql</pre>
</div>
<p>注意：出现1130错误代表不允许远程登录异常</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)"># 访问mysql库
use mysql
# 修改root用户能在任何host访问
update user set host </span>= <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">%</span><span style="color: rgba(128, 0, 0, 1)">'</span> where user = <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">root</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">;
# 刷新
FLUSH PRIVILEGES;</span></pre>
</div>
<p>&nbsp;</p><br><br>
来源：https://www.cnblogs.com/yulongzhang/p/18513739
頁: [1]
查看完整版本: 银河麒麟系统V10安装mysql5.7