Mysql Debian-start Fatal Error Upgrade Failed
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more mysql_upgrade fatal error upgrade failed about Stack Overflow the company Business Learn more about hiring developers or posting ads mysql_upgrade failed while fetching server version with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow error: failed while fetching server version! could be due to unauthorized access. is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up mysql_upgrade - FATAL ERROR: Upgrade Failed up vote 8 down vote favorite 1 mysql_upgrade error: failed while fetching server version! I recently had my MySQL server upgraded from 5.1 to 5.5 and I'm trying to upgrade my databases using mysql_upgrade but I keep getting this error: [root@ip-??-???-???-??? ~]# mysql_upgrade -uadmin -p Enter password: Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed I can't figure why this won't run. MySQL Server is running. mysql share|improve this question asked Mar 21 '14 at 16:40 seaBass
Fatal Error: Mysql.user Table Is Damaged. Please Run Mysql_upgrade.
2481211 Try adding --verbose to the mysql_upgrade and see if that shows anything. Try doing this while the server is not running and see if that makes a difference. Related thread on sf: serverfault.com/questions/527422/… –Aziz Saleh Mar 21 '14 at 16:57 add a comment| 9 Answers 9 active oldest votes up vote 13 down vote I had the same issue going from MySQL 5.5 to 5.6 on OS X (installed via MacPorts). Seems that mysql_upgrade needs to be run as user root and only root and a password needs to be set up for the user. Any other user with administrative privileges does not seem work. So the only valid command seems to be: mysql_upgrade -u root -p Initial solution by Chris_H at FreeBSD forums. share|improve this answer answered Apr 24 '14 at 7:18 Eero Otsus 39119 In fact, it works with other user with sufficients privileges, but you have to let the password empty. You'll have a prompt to type it after command execution. –Groco Oct 2 '15 at 7:39 @Groco - yes, -p implies the password prompt. So yes, might work with other administrator accounts as well provided that the password is not supplied as an argument of th
here for a quick overview of the site Help Center Detailed answers to any questions you might have
Can't Open The Mysql.plugin Table. Please Run Mysql_upgrade To Create It. Windows
Meta Discuss the workings and policies of this site About Us how to run mysql_upgrade Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with [error] fatal error: mysql.user table is damaged. us Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. Join them; it only http://stackoverflow.com/questions/22564509/mysql-upgrade-fatal-error-upgrade-failed takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Mysql stopped working up vote 0 down vote favorite Mysql is up and running on my system but i can not login with any user. I also cannot start/stop/status http://superuser.com/questions/404237/mysql-stopped-working the server. All i got is: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) From the logs: Mar 24 08:30:13 debian /etc/mysql/debian-start[1074]: Upgrading MySQL tables if necessary. Mar 24 08:30:13 debian /etc/mysql/debian-start[1078]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Mar 24 08:30:13 debian /etc/mysql/debian-start[1078]: Looking for 'mysql' as: /usr/bin/mysql Mar 24 08:30:13 debian /etc/mysql/debian-start[1078]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Mar 24 08:30:13 debian /etc/mysql/debian-start[1078]: Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/mysqld.sock' Mar 24 08:30:13 debian /etc/mysql/debian-start[1078]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect Mar 24 08:30:13 debian /etc/mysql/debian-start[1078]: FATAL ERROR: Upgrade failed Mar 24 08:30:13 debian /etc/mysql/debian-start[1111]: Checking for insecure root accounts. I can login after killing the process and start mysql with mysqld --skip-grant-tables but i am not able to reset debian-sys-maint password: mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'mypass'; ERROR
Sign in Pricing Blog Support Search GitHub This repository Watch 4 Star 11 Fork 2 gplessis/dotdeb-mysql Code Issues 3 Pull https://github.com/gplessis/dotdeb-mysql/issues/12 requests 0 Projects 0 Pulse Graphs New issue FATAL ERROR: Upgrade https://bugs.mysql.com/bug.php?id=77803 failed #12 Closed teunis90 opened this Issue Oct 8, 2014 · 1 comment Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 3 participants teunis90 commented Oct 8, 2014 Today I installed Debian Wheezy as a clean install fatal error and added the dotdeb repository after, created a snapshot and tried to install mysql5.6 with Ansible. After the installation I got an error message in my syslog: Oct 8 15:01:26 prod5 mysqld: 2014-10-08 15:01:26 3574 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure This could be fixed by entering: "mysql_upgrade", but this should happen in the failed while fetching install script or init script. I found out that my init script does try to update but fail somehow. Oct 8 15:07:57 prod5 /etc/mysql/debian-start[5564]: Looking for 'mysql' as: /usr/bin/mysql Oct 8 15:07:57 prod5 /etc/mysql/debian-start[5564]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Oct 8 15:07:57 prod5 /etc/mysql/debian-start[5564]: FATAL ERROR: Upgrade failed Oct 8 15:07:57 prod5 /etc/mysql/debian-start[5579]: Checking for insecure root accounts. Oct 8 15:07:57 prod5 /etc/mysql/debian-start[5584]: Triggering myisam-recover for all MyISAM tables Any clue if this is an general error or does this happen because I installed it via Ansible? gothick commented Jan 8, 2015 If it's any help to anyone in the future, I found that this error was because I had the wrong password for the debian-sys-maint user specified in /etc/mysql/debian.cnf, having restored all my databases from another server. gplessis closed this Feb 8, 2015 Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment Contact GitHub API Training Shop Blog About © 2016 GitHub, Inc. Terms Privacy Sec
wisborg Krogh Email Updates: Status: Closed Impact on me: None Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical) Version:5.6 OS:Any Assigned to: View Add Comment Files Developer Edit Submission View Progress Log Contributions [22 Jul 2015 23:37] Jesper wisborg Krogh Description: When doing an upgrade, you execute mysql_upgrade. If mysql_upgrade fails to connect or it connects with a user without the proper privileges, it will return the error: FATAL ERROR: Upgrade failed which is not very informative. How to repeat: shell$ mysql_upgrade --socket=... --user=root --password Enter password: