https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6416 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |tomascohen@gmail.com --- Comment #7 from Tomás Cohen Arazi <tomascohen@gmail.com> --- (In reply to rainer.stowasser from comment #6)

It seems to have something to do with the restore script

MariaDB [information_schema]> select * from USER_PRIVILEGES;

'koha_bibzamg'@'localhost' | def | USAGE | NO

'koha_zabibli'@'%' | def | USAGE | NO

the user bibzamg was created with koha-create the user koha_zabibli'@'%'with koha-restore

(In reply to Simon Story from comment #2)

The '%' wildcard seems to match when mysql is checking the host the connection is being made, not when matching users to delete.

I see in koha-create that 'koha_demo'@'localhost' shouldn't have been created. Since the code is: CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd'

Perhaps Magnus you are mistaken as to the course of events?

This is current code (20.05's): mysql_hostname="localhost" # Set up MySQL database for this instance. if [ "$op" = create ] then if [ ! -e /etc/mysql/debian.cnf ]; then MYSQL_OPTIONS="-u root" echo "WARNING: The koha-common.cnf file is a dead soft link!" else MYSQL_OPTIONS="--defaults-extra-file=/etc/mysql/koha-common.cnf" fi mysql $MYSQL_OPTIONS <<eof CREATE DATABASE \`$mysqldb\`; CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`@'$mysql_hostname'; FLUSH PRIVILEGES; eof -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.