300字范文,内容丰富有趣,生活中的好帮手!
300字范文 > 腾讯云服务器安装mysql 并用SQLyog实现远程连接

腾讯云服务器安装mysql 并用SQLyog实现远程连接

时间:2024-06-09 15:22:24

相关推荐

腾讯云服务器安装mysql 并用SQLyog实现远程连接

1、 用FinalShell 连接腾讯云服务器(如图)

1-1 FinalShell 的详细用法及软件下载

详细内容见见链接

2、详细过程如下

2-1 先添加规则如下图所示

[root@VM-4-8-centos ~]# cd /usr/local/src/[root@VM-4-8-centos src]# wget /mysql57-community-release-el7-8.noarch.rpm[root@VM-4-8-centos src]# rpm -ivh mysql57-community-release-el7-8.noarch.rpm 警告:mysql57-community-release-el7-8.noarch.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY准备中...################################# [100%]正在升级/安装...[root@VM-4-8-centos src]# yum -y install mysql-server失败的软件包是:mysql-community-client-5.7.39-1.el7.x86_64GPG 密钥配置为:file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql[root@VM-4-8-centos src]# rpm --import /RPM-GPG-KEY-mysql-[root@VM-4-8-centos src]# yum -y install mysql-community-server[root@VM-4-8-centos src]# systemctl start mysqld.service[root@VM-4-8-centos src]# grep "password" /var/log/mysqld.log[root@VM-4-8-centos src]# mysql -u root -pEnter password: mysql> alter user 'root'@'localhost' identified by 'Hh123456';Query OK, 0 rows affected (0.00 sec)mysql> create user 'root'@'%' identified by 'Hh123456';Query OK, 0 rows affected (0.00 sec)mysql> grant all privileges on *.* to 'root'@'%' with grant option;Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)[root@VM-4-8-centos src]# firewall-cmd --zone=public --add-port=3306/tcp --permanentsuccess[root@VM-4-8-centos src]# firewall-cmd --list-port20/tcp 21/tcp 22/tcp 80/tcp 443/tcp 8888/tcp 39000-40000/tcp[root@VM-4-8-centos src]# firewall-cmd --reloadsuccess[root@VM-4-8-centos src]# firewall-cmd --list-port20/tcp 21/tcp 22/tcp 80/tcp 443/tcp 8888/tcp 39000-40000/tcp 3306/tcp

3、接下来如图

4、 打开数据库连接客户端

5、如图便是连接上腾讯云的数据库了

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。