{"id":1126,"date":"2013-07-16T13:56:37","date_gmt":"2013-07-16T13:56:37","guid":{"rendered":"http:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=1126"},"modified":"2023-08-03T07:49:00","modified_gmt":"2023-08-03T06:49:00","slug":"mysqli-error-while-accessing-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/","title":{"rendered":"MySQLi error while accessing phpMyadmin"},"content":{"rendered":"

Some options from phpMyadmin (like routines function) show an error of MySQLi support built in and cannot use features such as Routines as expected.<\/p>\n

You are using PHP’s deprecated ‘mysql’ extension, which is not capable of handling multi queries. The execution of some stored routines may fail!<\/b> Please use the improved ‘mysqli’ extension to avoid any problems.<\/p><\/blockquote>\n

MySQLi should be compiled on the server & use command below if it is.<\/p>\n

# \/usr\/local\/cpanel\/3rdparty\/bin\/php -m | grep -i MySQLi
\nmysqli<\/p>\n

If it does not returns the output above you will have to re compile php on the server with MySQLi.<\/p>\n

Even if MySQLi is compiled, you receive the error. A small modification will allow phpMyadmin to use MySQLi.<\/p>\n

# grep sql \/usr\/local\/cpanel\/base\/3rdparty\/phpMyAdmin\/config.inc.php
\n\/* Select mysql if your server does not have mysqli *\/
\n$cfg[‘Servers’][$i][‘extension’] = ‘mysql’;<\/p>\n

Replace mysql with mysqli in phpMyAdmin configuration.<\/p>\n","protected":false},"excerpt":{"rendered":"

Some options from phpMyadmin (like routines function) show an error of MySQLi support built in and cannot use features such as Routines as expected. You are using PHP’s deprecated ‘mysql’ extension, which is not capable of handling multi queries. The execution of some stored routines may fail! Please use the improved ‘mysqli’ extension to avoid […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,5,22,4],"tags":[],"class_list":["post-1126","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-cpanel-faq","category-dedicated-server-faq","category-vps-faq","category-web-hosting-faq"],"yoast_head":"\nMySQLi error while accessing phpMyadmin<\/title>\n<meta name=\"description\" content=\"Encountering a MySQLi error when accessing phpMyAdmin? Don't worry! This comprehensive guide offers troubleshooting tips and solutions to fix the issue. Learn how to resolve MySQLi errors and regain smooth access to your database through phpMyAdmin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQLi error while accessing phpMyadmin\" \/>\n<meta property=\"og:description\" content=\"Encountering a MySQLi error when accessing phpMyAdmin? Don't worry! This comprehensive guide offers troubleshooting tips and solutions to fix the issue. Learn how to resolve MySQLi errors and regain smooth access to your database through phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-16T13:56:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-03T06:49:00+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/\",\"name\":\"MySQLi error while accessing phpMyadmin\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"datePublished\":\"2013-07-16T13:56:37+00:00\",\"dateModified\":\"2023-08-03T06:49:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/90143c7d8df4b4de36b3dbb0bb272f69\"},\"description\":\"Encountering a MySQLi error when accessing phpMyAdmin? Don't worry! This comprehensive guide offers troubleshooting tips and solutions to fix the issue. Learn how to resolve MySQLi errors and regain smooth access to your database through phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQLi error while accessing phpMyadmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/90143c7d8df4b4de36b3dbb0bb272f69\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/42e5b55cc2772cd685c8803f6f7f854b?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/42e5b55cc2772cd685c8803f6f7f854b?s=96&d=blank&r=g\",\"caption\":\"admin\"},\"description\":\"With over 10+ years of experience in the web hosting industry, I have achieved extensive exposure to result-oriented methodologies. And expertise in different domains like Datacentre Services, Cloud computing technology, Web hosting industry and many more.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQLi error while accessing phpMyadmin","description":"Encountering a MySQLi error when accessing phpMyAdmin? Don't worry! This comprehensive guide offers troubleshooting tips and solutions to fix the issue. Learn how to resolve MySQLi errors and regain smooth access to your database through phpMyAdmin.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/","og_locale":"en_GB","og_type":"article","og_title":"MySQLi error while accessing phpMyadmin","og_description":"Encountering a MySQLi error when accessing phpMyAdmin? Don't worry! This comprehensive guide offers troubleshooting tips and solutions to fix the issue. Learn how to resolve MySQLi errors and regain smooth access to your database through phpMyAdmin.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2013-07-16T13:56:37+00:00","article_modified_time":"2023-08-03T06:49:00+00:00","author":"admin","twitter_misc":{"Written by":"admin","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/","name":"MySQLi error while accessing phpMyadmin","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"datePublished":"2013-07-16T13:56:37+00:00","dateModified":"2023-08-03T06:49:00+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/90143c7d8df4b4de36b3dbb0bb272f69"},"description":"Encountering a MySQLi error when accessing phpMyAdmin? Don't worry! This comprehensive guide offers troubleshooting tips and solutions to fix the issue. Learn how to resolve MySQLi errors and regain smooth access to your database through phpMyAdmin.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/mysqli-error-while-accessing-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"MySQLi error while accessing phpMyadmin"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/90143c7d8df4b4de36b3dbb0bb272f69","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/42e5b55cc2772cd685c8803f6f7f854b?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/42e5b55cc2772cd685c8803f6f7f854b?s=96&d=blank&r=g","caption":"admin"},"description":"With over 10+ years of experience in the web hosting industry, I have achieved extensive exposure to result-oriented methodologies. And expertise in different domains like Datacentre Services, Cloud computing technology, Web hosting industry and many more.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/admin\/"}]}},"views":1603,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/1126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=1126"}],"version-history":[{"count":3,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/1126\/revisions"}],"predecessor-version":[{"id":14917,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/1126\/revisions\/14917"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=1126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=1126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=1126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}