mysql开启远程访问和oracl用户锁定问题

开启mysql远程访问

Grant all privileges on *.* to 'root'@'%' identified by 'root';

Flush privileges;

 

oracl锁定问题

sqlplus /nolog 

conn /as sysdba

alter user system account unlock;                      ##system为需要解锁的用户

alter profile default limit failed_login_attempts unlimited;

select resource_name,limit from dba_profiles where resource_name='FAILED_LOGIN_ATTEMPTS';

 

posted @ 2018-09-14 11:01  香菜哥哥  阅读(171)  评论(0编辑  收藏  举报