Comments - Upgrading MariaDB on Windows

Trying to upgrade existing 10.1.17 to 10.4.13

Almost all the time, it fails with permission denied error related to file renaming at phase 4/7: Running 'mysql_fix_privilege_tables' ERROR 1025 (HY000) at line 385: Error on rename of '.\mysql\#sql-5834_e' to '.\mysql\event' (errno: 13 "Permission denied")

Full log content - given below

Executing "C:\Program Files\MariaDB 10.1\bin\mysqld.exe" "--defaults-file=C:\Program Files\MariaDB 10.1\data\my.ini" "--loose-innodb-fast-shutdown=0" "--skip-networking" "--enable-named-pipe" "--socket=mysql_upgrade_service_23060" "--skip-slave-start" 2020-08-05 14:53:37 23084 [Note] C:\Program Files\MariaDB 10.1\bin\mysqld.exe (mysqld 10.1.17-MariaDB) starting as process 23088 ... Executing "C:\Program Files\MariaDB 10.4\bin\mysqld.exe" "--defaults-file=C:\Program Files\MariaDB 10.1\data\my.ini" "--skip-networking" "--skip-grant-tables" "--enable-named-pipe" "--socket=mysql_upgrade_service_23060" "--skip-slave-start" Executing "C:\Program Files\MariaDB 10.4\bin\mysqladmin.exe" "--protocol=pipe" "--socket=mysql_upgrade_service_23060" "ping" 2020-08-05 14:53:41 0 [Note] C:\Program Files\MariaDB 10.4\bin\mysqld.exe (mysqld 10.4.13-MariaDB) starting as process 19880 ... C:\Program Files\MariaDB 10.4\bin\mysqladmin.exe: connect to server at 'localhost' failed error: 'Can't open named pipe to host: . pipe: mysql_upgrade_service_23060 (2)' Executing "C:\Program Files\MariaDB 10.4\bin\mysqladmin.exe" "--protocol=pipe" "--socket=mysql_upgrade_service_23060" "ping" mysqld is alive Executing "C:\Program Files\MariaDB 10.4\bin\mysql_upgrade.exe" "--protocol=pipe" "--force" "--socket=mysql_upgrade_service_23060" Phase 1/7: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Phase 2/7: Installing used storage engines... Skipped Phase 3/7: Fixing views Phase 4/7: Running 'mysql_fix_privilege_tables' ERROR 1025 (HY000) at line 385: Error on rename of '.\mysql\#sql-5834_e' to '.\mysql\event' (errno: 13 "Permission denied") ERROR 1025 (HY000) at line 461: Error on rename of '.\mysql\#sql-5834_e' to '.\mysql\proxies_priv' (errno: 13 "Permission denied") FATAL ERROR: Upgrade failed

Hi there, maybe try intermediate steps first? i.e. go from 10.1 to 10.2, 10.2 to 10.3, etc