[Phpmyadmin-devel] Changes to MySQL user administration commands
marc at infomarc.info
Thu Mar 12 14:57:08 CET 2015
Morgan Tocker a écrit :
> Hi phpmyadmin list,
> I wanted to provide some warning on changes happening in MySQL 5.7:
Thanks Morgan, this is really appreciated.
> - The GRANT command is intended to be used to set privileges for a
> user. Allowing it to automatically create users (NO_AUTO_CREATE_USER
> sql mode) and set passwords is deprecated. NO_AUTO_CREATE_USER will
> also be enabled by default.
We use CREATE USER.
> - There are new commands for user administration. For example SHOW
> CREATE USER:
> http://dev.mysql.com/doc/refman/5.7/en/show-create-user.html and
> ALTER USER http://dev.mysql.com/doc/refman/5.7/en/alter-user.html
> - The SET PASSWORD=PASSWORD(‘password’) syntax is also changed to SET
> PASSWORD=‘password’. The previous syntax will remain supported (not
> withstanding a current bug:
> but deprecated.
Requested in  but according to , we should start to use ALTER USER
> Please let me know if you have any questions. I’d be happy to help!
Marc Delisle (phpMyAdmin)
More information about the Developers