Navicat Premium 12远程登入Oracle,mariadb报错及处理方法
2023-08-01 08:48:19 阅读次数:196
mariadb,oracle,数据库
Navicat Premium 12远程登入Oracle报错及处理方法
报错no matching authentication protocol
vi /usr/local/products/oracle12c/network/admin/sqlnet.ora
#添加如下内容
SQLNET.ALLOWED_LOGON_VERSION=8
链接报错 listener does currently know of server requested in connect descriptor
vi /usr/local/products/oracle12c/network/admin/samples/tnsnames.ora
#添加如下内容,修改对应数据库服务名和本机IP地址
3.10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CDB1)
)
)
忘了用户密码,修改用户密码
alter user system identified by 123456;
Navicat Premium 12远程登入mariadb报错及处理方法
#报错- lost connection to mysql server at 'reading initial communication packet',system error:0
vim /etc/my.cnf 中的[mysqld]下添加skip-name-resolve
#报错1698 Access denied for user *@*
mysql -u root -p
#进行远程连接授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'%' WITH GRANT OPTION;
flush privileges;
use zabbix;
GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'%'IDENTIFIED BY '111111' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '111111' WITH GRANT OPTION;
flush privileges;
版权声明:本文内容来自第三方投稿或授权转载,原文地址:https://blog.51cto.com/u_15081423/6121272,作者:QGS_51,版权归原作者所有。本网站转在其作品的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如因作品内容、版权等问题需要同本网站联系,请发邮件至ctyunbbs@chinatelecom.cn沟通。
上一篇:JDBC链接数据库
下一篇:mysql之uniquekey学习。