diff options
| author | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2011-03-18 16:16:17 +0200 |
|---|---|---|
| committer | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2011-03-18 16:16:17 +0200 |
| commit | dd0823cc03681e6e3e0b7ef9ec26649f70fece48 (patch) | |
| tree | ab790168cd83258fd1e1245376db240a2a4d41fb /scripts/mysql_system_tables_fix.sql | |
| parent | 12d9d4963f4b887b04d41635fe1a34ddfbda19cd (diff) | |
| download | mariadb-git-dd0823cc03681e6e3e0b7ef9ec26649f70fece48.tar.gz | |
Bug # 11766011: mysql.user.authentication_string column causes
configuration wizard to fail
Made the fields mysql.user.plugin and mysql.user.authentication_string
nullable to conform with some older clients doing inserts instead of
using the commands.
Diffstat (limited to 'scripts/mysql_system_tables_fix.sql')
| -rw-r--r-- | scripts/mysql_system_tables_fix.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/mysql_system_tables_fix.sql b/scripts/mysql_system_tables_fix.sql index 90dd49c254a..c57b3be5fae 100644 --- a/scripts/mysql_system_tables_fix.sql +++ b/scripts/mysql_system_tables_fix.sql @@ -640,8 +640,8 @@ DROP PREPARE stmt; drop procedure mysql.die; -ALTER TABLE user ADD plugin char(64) DEFAULT '' NOT NULL, ADD authentication_string TEXT NOT NULL; -ALTER TABLE user MODIFY plugin char(64) DEFAULT '' NOT NULL; +ALTER TABLE user ADD plugin char(64) DEFAULT '', ADD authentication_string TEXT; +ALTER TABLE user MODIFY plugin char(64) DEFAULT ''; -- Need to pre-fill mysql.proxies_priv with access for root even when upgrading from -- older versions |