Linux安装MySQL，并DbVisualizer连接MySQL_mysql和dbvisualizer-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_43617598/article/details/118033377

本文详细介绍了如何在Linux环境下安装JDK8、Perl及MySQL的过程，包括安装包下载、环境变量配置、服务管理及密码设置等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

准备

下载好jdk8、perl、mysql的安装包，以下.rmp文件均为安装包

安装jdk8

rpm -ivh jdk-8u291-linux-x64.rpm
# 查看jdk路径
find / | grep jdk
# 配置java环境变量
vi /etc/profile
# 填入路径
export JAVA_HOME=/usr/java/jdk1.8.0_291-amd64
export PATH=$PATH:$JAVA_HOME/bin
# 执行文件
source  /etc/profile
# 检测   
java -version

安装perl：

rpm -ivh perl-5.16.3-297.el7.x86_64.rpm perl-libs-5.16.3-297.el7.x86_64.rpm perl-macros-5.16.3-297.el7.x86_64.rpm perl-threads-shared-1.43-6.el7.x86_64.rpm perl-threads-1.87-4.el7.x86_64.rpm perl-constant-1.27-2.el7.noarch.rpm perl-Carp-1.26-244.el7.noarch.rpm perl-File-Temp-0.23.01-3.el7.noarch.rpm perl-File-Path-2.09-2.el7.noarch.rpm perl-PathTools-3.40-5.el7.x86_64.rpm perl-Exporter-5.68-3.el7.noarch.rpm perl-Socket-2.010-5.el7.x86_64.rpm perl-Storable-2.45-3.el7.x86_64.rpm perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm perl-Filter-1.49-3.el7.x86_64.rpm perl-Getopt-Long-2.40-3.el7.noarch.rpm perl-Pod-Simple-3.28-4.el7.noarch.rpm perl-Text-ParseWords-3.29-4.el7.noarch.rpm perl-Time-HiRes-1.9725-3.el7.x86_64.rpm perl-Time-Local-1.2300-2.el7.noarch.rpm perl-Pod-Escapes-1.04-297.el7.noarch.rpm perl-Pod-Usage-1.63-3.el7.noarch.rpm perl-Encode-2.51-7.el7.x86_64.rpm perl-Pod-Perldoc-3.20-4.el7.noarch.rpm perl-podlators-2.5.1-3.el7.noarch.rpm perl-HTTP-Tiny-0.033-3.el7.noarch.rpm perl-parent-0.225-244.el7.noarch.rpm

安装mysql

rpm -qa|grep mariadb
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

rpm -ivh net-tools-2.0-0.25.20131004git.el7.x86_64.rpm
rpm -ivh mysql-community-common-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.33-1.el7.x86_64.rpm

mysql服务管理

# 查看mysql是否启动
service mysqld status
# 启动mysql
service mysqld start
# 停止mysql
service mysqld stop
# 重启mysql
service mysqld restart

mysql密码管理

# 查看临时密码
grep password /var/log/mysqld.log
# 登录
mysql -p
# 重置密码
set password=password("abcd1234#U");
# 设置root用户登录密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Zh_123456' WITH GRANT OPTION;
# 刷新MySQL的系统权限相关表
flush privileges;
# 设置防火墙端口
firewall-cmd --permanent --add-port=3306/tcp
firewall-cmd --reload
# 设置简单密码
# 查看 mysql 初始的密码策略
SHOW VARIABLES LIKE 'validate_password%';
# 设置密码的验证强度等级，设置 validate_password_policy 的全局参数为 LOW
set global validate_password_policy=LOW; 
# 设置为 6 位的密码，设置validate_password_length 的全局参数为 6
set global validate_password_length=6;