我本地的虚拟机访问本地的win10系统搭建的MariaDB报错:ERROR 1130 (HY000): Host '192.168.1.178' is not allowed to connect to this MariaDB server
解决办法:
打开mysql服务端,登录并执行以下命令:
MariaDB [(none)]> grant all privileges on *.* to 'root'@'%'identified by 'zhbr2281'with grant option;
显示结果如下:
再返回虚拟机,登录数据库,完成