mysql -u root mysql mysql> INSERT INTO user (Host,User,Password) VALUES('localhost','root',password('rootpassword')); mysql> INSERT INTO user (Host,User,Password) VALUES('host1','user1',password('password1')); mysql> INSERT INTO user (Host,User,Password) VALUES('host2','user2',password('password2')); ... mysql> FLUSH PRIVILEGES;user 的其它字段都是默认值,如果不想用默认值,一并设置好了
mysql> INSERT INTO user (Host,User,Password) VALUES('localhost','root',password('rootpassword'));
mysql> INSERT INTO user (Host,User,Password) VALUES('host1','user1',password('password1'));
mysql> INSERT INTO user (Host,User,Password) VALUES('host2','user2',password('password2'));
...
mysql> FLUSH PRIVILEGES;user 的其它字段都是默认值,如果不想用默认值,一并设置好了