There is a behavior change between MySQL and MariaDB: With: CREATE DATABASE koha_kohadev; CREATE USER koha_kohadev@localhost IDENTIFIED BY 'password'; CREATE USER koha_kohadev@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON koha_kohadev.* TO koha_kohadev; Using Mysql, as admin user: mysql> SHOW GRANTS FOR koha_kohadev@'localhost'; GRANT USAGE ON *.* TO 'koha_kohadev'@'localhost' IDENTIFIED BY PASSWORD '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' mysql> SHOW GRANTS FOR koha_kohadev; GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' GRANT ALL PRIVILEGES ON `koha_kohadev`.* TO 'koha_kohadev'@'%' Using Mysql, as koha_user user: mysql> SHOW GRANTS FOR koha_kohadev@'localhost'; GRANT USAGE ON *.* TO 'koha_kohadev'@'localhost' IDENTIFIED BY PASSWORD <secret> mysql> SHOW GRANTS FOR koha_kohadev; GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD <secret> GRANT ALL PRIVILEGES ON `koha_kohadev`.* TO 'koha_kohadev'@'%' Using MariaDB, as admin user: MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev@localhost; GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD '*'2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev; GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD '*'2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 GRANT ALL PRIVILEGES ON `koha_kohadev`.* TO 'koha_kohadev'@'%' So all the same so far :) But, Using MariaDB, as koha_user user: MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev@localhost; GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD '*'2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev; ERROR 1044 (42000): Access denied for user 'koha_kohadev'@'localhost' to database 'mysql' BOOM! The installer does not parse the expected output and then raise an error.
Created attachment 56922 [details] [review] Bug 17513: Create GRANT for user@localhost in koha-create See the bug description for the details. Test plan: Use this script to create a new koha installation, using MariaDB You should not display "user koha_kohadev doesn't have enough privilege on database koha_kohadev "
Created attachment 56975 [details] [review] [SIGNED OFF] Bug 17513: Create GRANT for user@localhost in koha-create See the bug description for the details. Test plan: Use this script to create a new koha installation, using MariaDB You should not display "user koha_kohadev doesn't have enough privilege on database koha_kohadev " Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Could have sworn this had been signed off.. will amend to singed off instead of passed qa
Thanks Jonathan, great to see Maria making it to first class citizen ;)
Created attachment 57643 [details] [review] Bug 17513: Create GRANT for user@localhost in koha-create See the bug description for the details. Test plan: Use this script to create a new koha installation, using MariaDB You should not display "user koha_kohadev doesn't have enough privilege on database koha_kohadev " Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> Confirm that this still works (with MySQL).
Pushed to master for 16.11, thanks Jonathan!
Pushed to 3.22.x, will be in 3.22.13
Should go into 16.05 too please, I just ran into it.
Pushed to 16.05.x, for 16.05.06 release