[MXS-288] Error on login for Mysql >= 5.7.6 Created: 2015-07-27 Updated: 2017-12-01 Resolved: 2015-11-12 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | Core |
| Affects Version/s: | 1.2.1 |
| Fix Version/s: | 1.3.0 |
| Type: | New Feature | Priority: | Major |
| Reporter: | Fustini | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Maxscale 1.2.1 , Mysql >= 5.7.6 Linux (inside docker) |
||
| Issue Links: |
|
||||||||
| Description |
|
Hi, MariaDB Corporation MaxScale /var/log/maxscale/error1.log Mon Jul 27 14:30:09 2015 The MaxScale sql is wrong for table user on mysql from Mysql >= 5.7.6 2015-07-27T14:56:26.014577Z 2 Query SELECT COUNT(1) AS nusers_db FROM (SELECT user.user AS user,user.host AS host,user.password AS password,concat(user.user,user.host,user.password,user.Select_priv,IFNULL(db,'')) AS userdata, user.Select_priv AS anydb,db.db AS db FROM mysql.user LEFT JOIN mysql.db ON user.user=db.user AND user.host=db.host WHERE user.user IS NOT NULL AND user.user <> '' ORDER BY host DESC) AS tbl_count because mysql.user table use authentication_string instead password field |
| Comments |
| Comment by Dipti Joshi (Inactive) [ 2015-07-27 ] |
|
Thank you for trying MaxScale with MySQL 5.7.6 MaxScale will be tested with MySQL 5.7 when it goes GA. |
| Comment by markus makela [ 2015-11-12 ] |
|
MaxScale now supports the 5.7 layout of the mysql.user table. |