银河麒麟系统安装mysql数据库

芦志航 發表於 2023-2-17 11:46:00

<h2>1.1 准备材料</h2>
mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
MySQL5.7下载地址
https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
<h2>1.1 安装前准备工作</h2>
1、检查是否已经安装MySQL # rpm -qa | grep mysql
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217114216930-1579084774.png">
 2、将查询出的包卸载掉
# rpm -e --nodeps
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217114237023-999245680.png">
 3、将/usr/lib64/libLLVM-7.so也一并删除
# rm -rf /usr/lib64/libLLVM-7.so
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217114312195-823788001.png">
 4、检查是否删除成功
# rpm -qa | grep mysql
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217114330192-1771784356.png">
 5、查询残余文件夹
# whereis mysql
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217114340106-1720872801.png">
 6、删除残余文件
# rm -rf /usr/bin/mysql /usr/share/man/man1/mysql.1.gz
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217114405784-1634762765.png">
 7、验证删除结果
# whereis mysql
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217114419519-1117863015.png">
 8、检查MySQL用户组以及用户是否存在，若没有则创建
# cat /etc/group | grep mysql
# cat /etc/passwd |grep mysql
# groupadd mysql
# useradd -r -g mysql mysql
<img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217114430194-1479519832.png">
 9、将mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz安装包上传到银河麒麟系统虚拟机中
<img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217140131469-110145113.png">
10、开始安装MySQL数据库 
#解压mysql数据库压缩包
# tar -zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217140258533-1627222935.png">
<img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217140629213-1639346349.png">
<img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217140708805-47585204.png">
#复制解压后的mysql目录移动至/usr/local/mysql
# cp -r mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217141405455-1881581636.png">
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217141753019-1949248359.png">
在目录下/usr/local/mysql/创建data目录
# mkdir /usr/local/mysql/data
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217142118623-978333930.png">
 更改MySQL目录下所有的目录文件夹所属组和用户以及权限
# chown -R mysql:mysql /usr/local/mysql
# chmod -R 755 /usr/local/mysql
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217142235787-1194201650.png">
修改MySQL的数据配置文件vim /etc/my.cnf ，修改完后内容如下
来使用vim打开该文件，然后按一下i进入INSERT更改模式，使用小键盘旁边的上下左右按键可以移动光标位置，移动到想到的位置进行正常的增删操作，在操作完毕后，按Ctrl+C结束INSERT模式，再输入:wq再按回车即可退出。
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217142311632-1488065153.png">
<div class="cnblogs_code">
<pre>

datadir=/usr/local/mysql/data

basedir=/usr/local/mysql

socket=/usr/local/mysql/data/mysql.sock

user=mysql

port=3306

character-set-server=utf8

symbolic-links=0

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

port=3306

socket=/usr/local/mysql/data/mysql.sock </pre>
</div>
注意socket的值必须前后一致，否则会报错：Can’t connect to local MySQL server through socket的解决方法
解决办法：https://www.cnblogs.com/liunaixu/p/17122132.html
11、编译安装并初始化MySQL数据库，并记录初始化后末尾输出的默认密码
# cd /usr/local/mysql/bin
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217143114582-442983268.png">
 读取密码
# ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
<img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217143414022-638951380.png">
以上步骤执行完成后生产的临时密码，该数据库密码：ab)8xkZTi4XD
<div class="cnblogs_Highlighter">
<pre class="brush:sql;gutter:true;"># ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
2023-02-17T06:33:04.515456Z 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-02-17T06:33:05.303844Z 0 InnoDB: New log files created, LSN=45790
2023-02-17T06:33:05.413152Z 0 InnoDB: Creating foreign key constraint system tables.
2023-02-17T06:33:05.486498Z 0 No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ef7ba16f-ae8c-11ed-877c-000c29cb2878.
2023-02-17T06:33:05.487709Z 0 Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2023-02-17T06:33:05.947457Z 0 CA certificate ca.pem is self signed.
2023-02-17T06:33:06.086861Z 1 A temporary password is generated for root@localhost: ab)8xkZTi4XD</pre>
</div>
12、添加开机自启并开启服务
# cp -rf /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
# chmod +x /etc/init.d/mysqld
<img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217143838785-550922983.png">
 # systemctl enable mysqld
<img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217143629154-1139846206.png">
# /usr/lib/systemd/systemd-sysv-install enable mysqld
<img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217143648685-1833710038.png">
添加环境变量，在空白处添加以下代码
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
# vim /etc/profile
<img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217143708069-1190005243.png">
使环境变量生效
# source /etc/profile
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217144151250-1572576324.png">
开启MySQL服务
# systemctl start mysqld
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217144159805-1906816395.png">
 查询服务状态
# systemctl status mysqld
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217144205991-1863131119.png">
使用默认密码登录数据库
# mysql -u root -p
输入密码：ab)8xkZTi4XD
<img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217144214427-574867980.png">
至此MySQL安装完成
13、修改密码：
mysql>  set password for root@localhost = password('mysql123');
 <img src="https://img2023.cnblogs.com/blog/1204515/202302/1204515-20230217144614584-90138230.png">
14、查看MySQL数据库版本
mysql> select version();
<img src="https://img2023.cnblogs.com/blog/1204515/202303/1204515-20230314172754490-1917047341.png">
  
来源：https://www.cnblogs.com/liunaixu/p/17129670.html

頁: [1]

琼殿技术论坛's Archiver

银河麒麟系统安装mysql数据库