MySQL8.0新規ユーザー
1554 ワード
-- mysql USE mysql -- mysql ：pig ：123456 CREATE USER pig IDENTIFIED BY '123456' ; -- pig SELECT * FROM user WHERE USER = 'pig' ; SHOW GRANTS FOR pig; -- pig auto_dev EXECUTE( ),INSERT,SELECT,UPDATE ，@'%' ip GRANT EXECUTE , INSERT , SELECT , UPDATE ON SUN.* TO 'pig' @ '%' ; -- pig alter user 'pig' @ '%' identified with mysql_native_password by "123456" ; -- FLUSH PRIVILEGES ; -- SELECT * FROM user WHERE USER = 'pig' ; SHOW GRANTS FOR pig;