mysql> GRANT ALL PRIVILEGES ON confluence.* TO 'confluence'@'localhost' IDENTIFIED BY '123456'; mysql> GRANT ALL PRIVILEGES ON confluence.* TO 'confluence'@'%' IDENTIFIED BY '123456'; mysql> FLUSH PRIVILEGES; '%'不包括localhost,要单独对@'localhost'进行赋值
mysql> GRANT ALL PRIVILEGES ON confluence.* TO 'confluence'@'localhost' IDENTIFIED BY '123456'; mysql> GRANT ALL PRIVILEGES ON confluence.* TO 'confluence'@'%' IDENTIFIED BY '123456'; mysql> FLUSH PRIVILEGES; '%'不包括localhost,要单独对@'localhost'进行赋值