mysql –u root dbname mysql> SET PASSWORD FOR root@localhost=PASSWORD(‘new-password’); mysql> SET PASSWORD FOR root@”%”=PASSWORD(‘new-password’); or mysql –u root dbname mysql> UPDAGE user SET password=PASSWORD(‘new-password’) > WHERE user=’root’; mysql>FLUSH PRIVILEGES; or mysqladmin –u root password new-password
GRANT SELECT,INSERT,UPDATE,DELETE
ON dbname.* TO username@localhost IDENTIFIED BY "password"
GRANT SELECT,INSERT,UPDATE,DELETE
ON dbname.* TO root@localhost IDENTIFIED BY "password"是不是这样啊?
mysql> SET PASSWORD FOR root@localhost=PASSWORD(‘new-password’);
mysql> SET PASSWORD FOR root@”%”=PASSWORD(‘new-password’);
or
mysql –u root dbname
mysql> UPDAGE user SET password=PASSWORD(‘new-password’)
> WHERE user=’root’;
mysql>FLUSH PRIVILEGES;
or
mysqladmin –u root password new-password