创建用户:createuseriscidentifiedby"isc"defaulttablespaceUSERStemporarytablespaceTEMPprofileDEFAULT;grantconnecttoisc;grantdbatoisc;grantresourcetoisc;grantunlimitedtablespacetoisc;----更改用户名密码:　alteruseriscidentifiedbypassword或者:connectisc/abc123输入:password----删除用户Connectsystem/adminDropuseruse

mysqlversion: Serverversion:5.6.19-logMySQLCommunityServer(GPL) CentosVersion: CentOSLinuxrelease7.6.1810(Core) 卸载旧版本mysql rpm-qa|grepmariadb rpm-qa|grep-imysql mariadb-libs-5.5.65-1.1.al7.x86_64 rpm-e--nodepsmariadb-libs-5.5.65-1.1.al7.x86_64 yu

Grantdbatoisc；Grantconnecttoisc；

alteruserabcidentifiedbypassword或者:connectabc/abc123输入:password注:abc为用户名!