Repost from duplicate bug thread: Also receiving this error. A ton of errors really. It also failed to update several MySQL tables in information_schema and performance_schema and many other things. Over a series of hours I got MySQL to work by running mysql_upgrade and doing several other things, some of which are linked to below, sorry I did not create exact steps:
http://askubuntu.com/questions/705458/ubuntu-15-10-mysql-error-1524-unix-socket http://stackoverflow.com/questions/31967527/table-performance-schema-session-variables-doesnt-exist Finally I noticed this: Setting up mysql-server-5.7 (5.7.12-0ubuntu1.1) ... mysql_upgrade: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) while connecting to the MySQL server SOLUTION: CREATE USER 'debian-sys-maint'@'localhost' IDENTIFIED BY '***';GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '***' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; Note: You can get the debian-sys-maint password from /etc/mysql/debian.cnf Then: sudo apt-get upgrade Anyways good luck folks, this took me several hours to move through this hell. I believe something messed up with the install, the debian-sys- maint user was not created, so system could not update MySQL schema which probably lead to a whole host of other errors. Be sure to check your logs so you can resolve this quicker than it took me. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1574168 Title: mysql-server-5.7.postinst fails with "Can't create database 'performance_schema'; database exists" To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1574168/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
