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: http://www.tocker.ca/2015/03/10/heads-up-mysql-5-7-dmr6-contains-a-small-kno...) but deprecated.
Requested in [0] but according to [1], we should start to use ALTER USER for 5.7.6+.
Please let me know if you have any questions. I’d be happy to help!
[0] https://sourceforge.net/p/phpmyadmin/feature-requests/1620/
[1] http://dev.mysql.com/doc/refman/5.7/en/set-password.html