1: grant select,insert,update,delete on . to zlg@"%" Identified by "aaa";该语句有错, 应该是 grant select,insert,update,delete on * to zlg@"%" Identified by "aaa";2: UPDATE user SET Password=PASSWORD('sql') WHERE user='root'; 没有问题, 但执行完后要再执行一句FLUSH PRIVILEGES;3: mysqladmin -uroot -password ab12 有错应该是mysqladmin -u root password 'ab12'
grant select,insert,update,delete on . to zlg@"%" Identified by "aaa";该语句有错,
应该是
grant select,insert,update,delete on * to zlg@"%" Identified by "aaa";2:
UPDATE user SET Password=PASSWORD('sql') WHERE user='root';
没有问题,
但执行完后要再执行一句FLUSH PRIVILEGES;3:
mysqladmin -uroot -password ab12
有错应该是mysqladmin -u root password 'ab12'