笺注:这是在 CentOS8安装LNMP+phpMyAdmin 的基础上进行的。
插入防火墙规则:( 打开TCP 3306端口 )
[root@centos8 ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
success
[root@centos8 ~]# firewall-cmd --reload
success
查看防火墙firewalld的配置文件:
[root@centos8 ~]# cat /etc/firewalld/zones/public.xml
<?xml version="1.0" encoding="utf-8"?>
<zone>
<short>Public</short>
<description>For use in public areas. You do not trust the other computers on networks to not harm your computer. Only selected incoming connections are accepted.</description>
<service name="ssh"/>
<service name="dhcpv6-client"/>
<service name="cockpit"/>
<port port="80" protocol="tcp"/>
<port port="3306" protocol="tcp"/>
</zone>
服务器本地登录MariaDB数据库:
mysql -uroot -p123456a
###
自定义一个数据库用户并授权:
授权用户zhuohua@'%' (密码886),可以从任意IP进行访问,可以对所有的库进行任意操作:
MariaDB [(none)]> grant all privileges on *.* to zhuohua@'%' identified by '886';
MariaDB [(none)]> flush privileges;
查看所有数据库用户及其主机信息:
select user,host from mysql.user;
查看数据库用户zhuohua@'%'的权限:
MariaDB [(none)]> show grants for zhuohua@'%';
+-----------------------------------------------------------------------------------------------------------------+
| Grants for zhuohua@% |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'zhuohua'@'%' IDENTIFIED BY PASSWORD '*F961C54AFEB4D281CE53D7CB8E7822890D86FFFC' |
+-----------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
Navicat 是一个图形化管理多种数据库的工具。
Windows客户端使用Navicat,远程访问MariaDB数据库:
新建“查询”:
使用“查询”创建库:
使用“查询”创建表:
在库db1里创建一个表t_1:
use db1;
create table t_1(
id int not null auto_increment,
name varchar(20) not null,
grade varchar(10),
age float default 60,
ruxueriqi datetime,
chinese decimal(50, 2),
math numeric(60, 3),
primary key (id)
);
效果:
MariaDB [(none)]> desc db1.t_1;
相关文章:
使用Navicat远程管理MySQL8.0 |