[Phpmyadmin-devel] Changes to MySQL user administration commands

[Marc Delisle]

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-known-bug.html)
> 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

-- 
Marc Delisle (phpMyAdmin)