MySQLgrant all privileges on testdb to 其中,关键字“privileges”...grant execute on procedure testdb.pr_add to 'dba'@'localhost' grant execute on function testdb.fn_add to 'dba'@'localhost' grant all on*.*to dba@'localhost'
MySQLgrant all privileges on testdb to 其中,关键字“privileges”...grant execute on procedure testdb.pr_add to 'dba'@'localhost' grant execute on function testdb.fn_add to 'dba'@'localhost' grant all on*.*to dba@'localhost'
sysdba 是系统权限,dba 是用户对象权限。用 sysdba 系统权限身份登录后再用 show user 命令即可看到哪个用户有系统权限了。alter user 用户 identified by 密码;命令即可修改用户密码了。C:\Users\Administrator>sqlplus/as sysdba SQL*...