I just upgraded the 5.6 version to the latest 5.7 version. Everything worked before doing this. Now, when I try to run mysql-server by service mysql-server start. It shows starting mysql. It hangs there for about maybe 1 min or two. Then it takes me back to the console. I then run service mysql-server status and it says mysql not running.
I look into the error logs and find this:
That is the only error I get. How do I fix this error?
I done a google search and found people had similar issues with MySQL 5.6. I seen them say to make changes to the my.cnf file. It said to put 10M but the location I looked at mine and it was already there but it had 128M instead of 10M. I changed it to 10M and still got the same issue.
I would like to know what I need to do to fix this.
I look into the error logs and find this:
Code:
2016-07-29T08:38:41.926090Z 0 [ERROR] InnoDB: The Auto-extending innodb_system data file '/var/db/mysql/ibdata1' is of a different size 1152 pages (rounded down to MB) than specified in the .cnf file: initial 8192 pages, max 0 (relevant if non-zero) pages!
2016-07-29T08:38:41.926141Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2016-07-29T08:38:42.135842Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2016-07-29T08:38:42.135865Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-07-29T08:38:42.135875Z 0 [ERROR] Failed to initialize plugins.
2016-07-29T08:38:42.135883Z 0 [ERROR] Aborting
That is the only error I get. How do I fix this error?
I done a google search and found people had similar issues with MySQL 5.6. I seen them say to make changes to the my.cnf file. It said to put 10M but the location I looked at mine and it was already there but it had 128M instead of 10M. I changed it to 10M and still got the same issue.
I would like to know what I need to do to fix this.
Last edited by a moderator: