[Bug 1447944] Re: Migration of custom configuration to my.cnf.migrated is not explicit enough
So I just had the terrible to idea to try and switch from mysql to mariadb (drop-in replacement, yeah sure...) and hit this bug. After a couple of hours trying different things, I went back to mysql 5.7 and used the solution in #29. I think we should stop calling mariadb a drop-in replacement, at least in the state its ubuntu's packaging is. Also during the upgrade process, the system told me existing databases could not be migrated and they were being copied somewhere else. Probably the worst user experience I've had with ubuntu in years. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1447944 Title: Migration of custom configuration to my.cnf.migrated is not explicit enough To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1447944/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1447944] Re: Migration of custom configuration to my.cnf.migrated is not explicit enough
This happened to me after installing mariadb, deciding to go back to mysqld and installing mysqld again. The fix by Markus (maier-m) (#29, 2015-04-30) solved the problem for me. Thank you very much! :) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1447944 Title: Migration of custom configuration to my.cnf.migrated is not explicit enough To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1447944/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1447944] Re: Migration of custom configuration to my.cnf.migrated is not explicit enough
This happened to me after installing mariadb, deciding to go back to mysqld and installing mysqld again. The fix by Markus (maier-m) (#29, 2015-04-30) solved the problem for me. Thank you very much! :) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1447944 Title: Migration of custom configuration to my.cnf.migrated is not explicit enough To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1447944/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1447944] Re: Migration of custom configuration to my.cnf.migrated is not explicit enough
Sorry for the double-post, but I have to correct my previous statement. #29 did not help. What helped was logging in via the mysql console as debian-sys-maint and doing the following: use mysql; update user set plugin='' where User='root'; \q After restarting the service using service mysql restart, everything worked again. And yes, I do have to enter a password for root. It works perfectly. Maybe I'll run into other issues later, but I hope that this fixed the problem permanently. Phew. Kudos to #8 and http://ubuntuforums.org/showthread.php?t=2275033 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1447944 Title: Migration of custom configuration to my.cnf.migrated is not explicit enough To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1447944/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1447944] Re: Migration of custom configuration to my.cnf.migrated is not explicit enough
Sorry for the double-post, but I have to correct my previous statement. #29 did not help. What helped was logging in via the mysql console as debian-sys-maint and doing the following: use mysql; update user set plugin='' where User='root'; \q After restarting the service using service mysql restart, everything worked again. And yes, I do have to enter a password for root. It works perfectly. Maybe I'll run into other issues later, but I hope that this fixed the problem permanently. Phew. Kudos to #8 and http://ubuntuforums.org/showthread.php?t=2275033 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1447944 Title: Migration of custom configuration to my.cnf.migrated is not explicit enough To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1447944/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1447944] Re: Migration of custom configuration to my.cnf.migrated is not explicit enough
Well, I could help on the documentation part (although I have very little experience with alternatives) but I think we should tackle this issue somewhere else: we're currently implementing new config files and the user sees an error message which does not guide him to the config file immediately. Not an easy way to find out that you need to check the config file, migrate it manually and remove the old one... Could we somehow show a message during the upgrade process itself? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1447944 Title: Migration of custom configuration to my.cnf.migrated is not explicit enough To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1447944/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1447944] Re: Migration of custom configuration to my.cnf.migrated is not explicit enough
Well, I could help on the documentation part (although I have very little experience with alternatives) but I think we should tackle this issue somewhere else: we're currently implementing new config files and the user sees an error message which does not guide him to the config file immediately. Not an easy way to find out that you need to check the config file, migrate it manually and remove the old one... Could we somehow show a message during the upgrade process itself? -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1447944 Title: Migration of custom configuration to my.cnf.migrated is not explicit enough To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1447944/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1447944] Re: Migration of custom configuration to my.cnf.migrated is not explicit enough
** Summary changed: - Cannot access mariadb after upgrading to Ubuntu 15.04: Plugin 'unix_socket' is not loaded + Migration of custom configuration to my.cnf.migrated is not explicit enough ** Changed in: mariadb-10.0 (Ubuntu) Status: Confirmed = Triaged ** Changed in: mariadb-10.0 (Ubuntu) Assignee: Otto Kekäläinen (otto) = Robie Basak (racb) ** Changed in: mariadb-10.0 (Ubuntu) Importance: Undecided = Medium ** Package changed: mariadb-10.0 (Ubuntu) = mysql-5.6 (Ubuntu) ** Tags added: mysql-5.6-transition -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1447944 Title: Migration of custom configuration to my.cnf.migrated is not explicit enough To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1447944/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1447944] Re: Migration of custom configuration to my.cnf.migrated is not explicit enough
** Summary changed: - Cannot access mariadb after upgrading to Ubuntu 15.04: Plugin 'unix_socket' is not loaded + Migration of custom configuration to my.cnf.migrated is not explicit enough ** Changed in: mariadb-10.0 (Ubuntu) Status: Confirmed = Triaged ** Changed in: mariadb-10.0 (Ubuntu) Assignee: Otto Kekäläinen (otto) = Robie Basak (racb) ** Changed in: mariadb-10.0 (Ubuntu) Importance: Undecided = Medium ** Package changed: mariadb-10.0 (Ubuntu) = mysql-5.6 (Ubuntu) ** Tags added: mysql-5.6-transition -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1447944 Title: Migration of custom configuration to my.cnf.migrated is not explicit enough To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1447944/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
