{"id":104,"date":"2015-04-27T11:07:47","date_gmt":"2015-04-27T11:07:47","guid":{"rendered":"http:\/\/betakb.veeble.org\/?p=104"},"modified":"2025-04-24T11:34:50","modified_gmt":"2025-04-24T06:04:50","slug":"common-errors","status":"publish","type":"post","link":"https:\/\/www.veeble.com\/kb\/common-errors\/","title":{"rendered":"Most common MySQL errors and fixes"},"content":{"rendered":"

Error #1<\/b><\/p>\n

\"Starting MySQL. ERROR! Manager of pid-file quit without updating file.\"\n<\/pre>\n
Solution: If you’re getting the above error while starting mysql, check the mysql error log by using the following command:<\/p>\n
tail -f \/var\/lib\/mysql\/*.err\n<\/pre>\n
Here you can see the reason. Issue maybe due to the presence of incorrect variables existing in ‘\/etc\/my.cnf’.<\/p>\n
Error #2<\/b><\/p>\n
\"Can't connect to local MySQL server through socket '\/var\/lib\/mysql\/mysql.sock' (111)\"\n<\/pre>\n
Solution: Make sure that \/var\/lib\/mysql\/mysql.sock is existing. Also, confirm the presence of \/tmp\/mysql.sock. If it’s not existing, create it:<\/p>\n
ln -s \/var\/lib\/mysql\/mysql.sock \/tmp\/mysql.sock \n<\/pre>\n
Then restart mysql.<\/p>\n
Error #3<\/b><\/p>\n
ERROR 2003 (HY000): Can't connect to MySQL server on 'IP address is here' (110) \n<\/pre>\n
Solution: Open port 3306 in server firewall. If iptables is the firewall, use the following command:<\/p>\n
iptables -A INPUT -m tcp -p tcp --sport 3306 -j ACCEPT\niptables -A INPUT -m tcp -p tcp --dport 3306 -j ACCEPT\nservice iptables save\nservice iptables restart\n<\/pre>\n
Error #4<\/b><\/p>\n
When Plesk login page return some errors<\/p>\n
Solution: Disable ‘skip-bdb’ in \/etc\/my.cnf and then restart mysql.<\/p>\n
Error #5<\/b><\/p>\n
database.table_name\nError : Incorrect file format 'table_name'\nerror : Corrupt\n<\/pre>\n
Solution: If you’re getting the above error while executing ‘mysqlcheck’, try to repair the table manually.<\/p>\n
# mysql -u root -p\n<\/pre>\n
mysql > use database_name;\nmysql > repair table table_name;\n<\/pre>\n
If the issue is not solved, try the following command:<\/p>\n
mysql > repair table table_name USE_FRM;\n<\/pre>\n
It will fix the issue.<\/p>\n
One of the most misleading errors generated by MySql is shown below:-<\/p>\n
\"error    : sort_buffer_size is to small\nwarning  : Number of rows changed from 0 to 14024\"\n<\/pre>\n
In this case, you need to adjust both ‘sort_buffer_size’ and ‘myisam_sort_buffer_size’.<\/p>\n\n\n
<\/div>\n\n\n\n
High-Speed WooCommerce Servers<\/h3>
Experience lightning-fast loading speeds. Enhance user experience and boost conversions.<\/p><\/div>
View Plans.<\/path><\/svg><\/a><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
Error #1 “Starting MySQL. ERROR! Manager of pid-file quit without updating file.” Solution: If you’re getting the above error while starting mysql, check the […]<\/p>\n","protected":false},"author":12,"featured_media":8713,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[11],"tags":[],"class_list":["post-104","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"uagb_featured_image_src":{"full":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Most-common-MySQL-errors-and-fixes.jpg",1366,768,false],"thumbnail":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Most-common-MySQL-errors-and-fixes-150x150.jpg",150,150,true],"medium":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Most-common-MySQL-errors-and-fixes-300x169.jpg",300,169,true],"medium_large":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Most-common-MySQL-errors-and-fixes-768x432.jpg",768,432,true],"large":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Most-common-MySQL-errors-and-fixes-1024x576.jpg",1024,576,true],"1536x1536":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Most-common-MySQL-errors-and-fixes.jpg",1366,768,false],"2048x2048":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Most-common-MySQL-errors-and-fixes.jpg",1366,768,false]},"uagb_author_info":{"display_name":"Digin Dominic","author_link":"https:\/\/www.veeble.com\/kb\/author\/digin-dominic\/"},"uagb_comment_info":0,"uagb_excerpt":"Error #1 \"Starting MySQL. ERROR! Manager of pid-file quit without updating file.\" Solution: If you’re getting the above error while starting mysql, check the […]","_links":{"self":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/comments?post=104"}],"version-history":[{"count":6,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"predecessor-version":[{"id":8466,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/104\/revisions\/8466"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/media\/8713"}],"wp:attachment":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}