創(chuàng)建遠(yuǎn)程用戶:
GRANT ALL PRIVILEGES ON *.* TO 'zhengyu’@'%' IDENTIFIED BY ‘zhengyu' WITH GRANT OPTION;
創(chuàng)建本地用戶:將%改成localhost
刪除用戶:
DELETE FROM user WHERE User=“zhengyu" and Host="localhost";
創(chuàng)建遠(yuǎn)程用戶:
GRANT ALL PRIVILEGES ON *.* TO 'zhengyu’@'%' IDENTIFIED BY ‘zhengyu' WITH GRANT OPTION;
創(chuàng)建本地用戶:將%改成localhost
刪除用戶:
DELETE FROM user WHERE User=“zhengyu" and Host="localhost";