缠丝猫 发表于 2024-8-23 10:26:42

统信UOS安装MySQL

统信UOS安装MySQL


1.下载对应版本的mysql

下载链接：MySQL :: Download MySQL Community Server

https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps1.jpg&pos_id=JZl8PHN2
2.上传压缩包至服务器进行解压

# tar -xvf mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps2.jpg&pos_id=19R5PrDu
3.对解压文件进行重定名

# mv mysql-8.0.19-linux-glibc2.12-x86_64  mysql
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps3.jpg&pos_id=oXcB4yje

[*]创建用户组
# groupadd mysql

[*]添加用户
#  useradd -r -g mysql mysql

[*]创建MySQL数据目录
# mkdir /usr/local/data/
# mkdir /usr/local/data/mysql

[*]修改拥有者
# chown mysql:mysql -R /usr/local/data/

[*]天生编辑设置文件
# vim /etc/my.cnf或sudo vim /etc/my.cnf  
或者nano /etc/my.cnf
-------------如果没有my.cnf就本身创建文件
--------my.cnf 内容如下：

bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql  #解压上传的目录
datadir=/usr/local/data/mysql  #创建的文件目录
socket=/usr/local/data/mysql/mysql.sock  
log-error=/usr/local/data/mysql/mysql.err
pid-file=/usr/local/data/mysql/mysql.pid
character_set_server=utf8mb4
symbolic-links=0
default-time-zone='+08:00'

default-character-set=utf8
socket=/usr/local/data/mysql/mysql.sock
default-time-zone='+08:00'

default-character-set=utf8
socket=/usr/local/data/mysql/mysql.sock
default-time-zone='+08:00'
---------------------以上目录都是刚刚创建的/usr/local/data/mysql目录下，且已经为mysql用户赋权

[*]初始化MYSQL
得到数据库的初始密码（在mysql/bin目录下执行）
# cd /usr/local/mysql/bin/ 
# ./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql-8.0.31/ --datadir=/data/mysql/ --user=mysql --initialize

[*]检察MySQL初始密码
# cat /usr/local/data/mysql/mysql.err
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps4.jpg&pos_id=XED3y7Xs
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps5.jpg&pos_id=V55uMSL3

[*]复制 mysql.server 文件
开机自启动
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql  
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

复制成功后我们必要给赋予权限
chmod +x /etc/init.d/mysql
添加为服务：chkconfig --add mysql
检察服务列表：chkconfig --list
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps6.jpg&pos_id=SlcHEAxh
看到3、4、5状态为开或者为 on 则表示成功。 如果是 关或者 off 则执行一下：
chkconfig --level 345 mysqld on
13.登录mysql

https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps7.jpg&pos_id=1eIyUhk7

12.启动mysql

#   service mysql start
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps8.jpg&pos_id=ELiIykOp
检察状态 service mysql status


[*]修改mysql密码
先检察root的信息在修改密码
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps9.jpg&pos_id=zqGJAZgy
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY ‘admin%jxw’;
按图示修改必要在客户端的驱动连接参数中增长：allowPublicKeyRetrieval=true&useSSL=false
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps10.jpg&pos_id=0QBtSqW1

[*]开启MySQL长途权限
使用mysql数据库
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps11.jpg&pos_id=3moqeuqr
查询全部用户
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps12.jpg&pos_id=HjeztfuD
#更新root的host %允许全部IP连接
update user set host = ‘%’ where user = ‘root’;
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps13.jpg&pos_id=FlrSPi1E

#革新权限立刻见效
flush privileges;
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps14.jpg&pos_id=6HhA2lup


[*]创建metersphere数据库
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps15.jpg&pos_id=gddeoWZx


[*]设置MySQL全局变量
#打开全局变量文件
vim /etc/profile
#全局变量文件末了一行增长
export PATH=$PATH:/usr/local/mysql/bin

https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps16.jpg&pos_id=AG2NpZAh

#重新加载变量文件
source /etc/profile
测试----输入mysql -u root -p admin%jxw
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps17.jpg&pos_id=SMXb2eGb


[*]开放端口
在Linux体系中开放端口，可以使用`firewalld`或`iptables`。以下是使用`firewalld`开放端口的步骤：

[*]启动`firewalld`服务。使用命令`systemctl start firewalld`。

[*]检察`firewalld`服务状态。使用命令`systemctl status firewalld`。
[*]开放端口。使用命令`firewall-cmd --permanent --add-port=端口号/tcp`，比方，开放端口80，使用命令`firewall-cmd --permanent --add-port=80/tcp`。

[*]重启`firewalld`服务。使用命令`firewall-cmd --reload`。
以下是使用`iptables`开放端口的步骤：

[*]添加端口规则。使用命令`iptables -A INPUT -p tcp --dport 端口号 -j ACCEPT`，比方，开放端口80，使用命令`iptables -A INPUT -p tcp --dport 80 -j ACCEPT`。

[*]保存规则。使用命令`iptables-save`。
[*]重启`iptables`服务。使用命令`service iptables restart`。

[*]
https://img-home.csdnimg.cn/images/20230724024159.png?origin_url=file%3A%2F%2F%2FC%3A%5CUsers%5Ckong%5CAppData%5CLocal%5CTemp%5Cksohtml20504%5Cwps18.jpg&pos_id=CjNqDSct

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页: [1]
查看完整版本: 统信UOS安装MySQL