{"id":7965,"date":"2019-07-29T07:45:41","date_gmt":"2019-07-29T07:45:41","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=7965"},"modified":"2019-07-29T08:47:57","modified_gmt":"2019-07-29T08:47:57","slug":"php-installation-appears-to-be-missing-the-mysql-extension","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/","title":{"rendered":"PHP Installation Appears To Be Missing the MySQL Extension"},"content":{"rendered":"

\u201cPHP installation appears to be missing the MySQL extension\u201d<\/strong> is a common error in WordPress, if you are setting up a WordPress CMS on a new Linux VPS. You get the message of missing MySQL extension because this extension isn\u2019t by default available in many operating systems. In this tutorial, you will learn to fix this problem and complete the WordPress installation successfully.<\/p>\n

Don\u2019t get panic if you get the missing a PHP extension error. If you see the below message on your screen while accessing the WordPress installation via web browser, then you are one of the many WordPress users that face the same problem:<\/p>\n

Your PHP installation appears to be missing the MySQL extension which is required by WordPress.<\/pre>\n
Follow the below steps to solve this error:<\/strong><\/p>\n
Connect via SSH and Check the PHP Version<\/h3>\n
Ensure that you have a SSH access to the server. Using SSH, connect to your Linux VPS and check the PHP version that you are currently using:<\/p>\n
php -v<\/pre>\n
Create Info.php File<\/h3>\n
Alternate way of checking the PHP version is by creating a simple info.php<\/em> file in your public_html<\/em> directory with the below content:<\/p>\n
<?php phpinfo(); ?><\/pre>\n
After creating the file, open your choice of web browser and access the file.<\/p>\n
Update the Required Packages<\/h3>\n
In case you are running an Ubuntu VPS and PHP 7, then execute the following commands:<\/p>\n
apt-get update\r\napt-get install php7.0-mysql<\/pre>\n
Restart the Web Server<\/h3>\n
Next, you will need to restart your Apache service for the changes to take effect, or in case you are using Nginx + PHP-FPM, then you will need to restart the PHP-FPM service.<\/p>\n
Update PHP<\/h3>\n
If you are running PHP 5, run the below commands:<\/p>\n
apt-get update\r\napt-get install php-mysql<\/pre>\n
Then you should restart the appropriate service for the changes to take effect.<\/p>\n
Search All the Available Packages Containing MySQL<\/h3>\n
In order to search all the available packages that contain mysql, you can use the below command:<\/p>\n
apt-cache search mysql<\/pre>\n
Or, if you are running a CentOS VPS that contains PHP 7 installed on the server, then execute the below commands to fix the error:<\/p>\n
yum update\r\nyum install php70w-mysql<\/pre>\n
Restart Apache<\/h3>\n
You will need to restart Apache or the PHP-FPM service if you are using Nginx + PHP-FPM as a web server.<\/p>\n
If PHP 5 is installed on your CentOS server, execute the following commands:<\/p>\n
yum update\r\nyum install php-mysql<\/pre>\n
Then you should restart the appropriate service for the changes to take effect.<\/p>\n
In order to search all the available packages containing mysql<\/em>, you can execute the following command:<\/p>\n
yum search mysql<\/pre>\n
After installing the MySQL extension for PHP, you can switch back to your WordPress setup. If the installation goes OK, the message about the missing MySQL extension won\u2019t appear. You can then continue with your WordPress setup.<\/p>\n","protected":false},"excerpt":{"rendered":"
\u201cPHP installation appears to be missing the MySQL extension\u201d is a common error in WordPress, if you are setting up a WordPress CMS on a new Linux VPS. You get the message of missing MySQL extension because this extension isn\u2019t by default available in many operating systems. In this tutorial, you will learn to fix […]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[230],"tags":[205,937,936],"class_list":["post-7965","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-database","tag-mysql","tag-mysql-extension","tag-php-installation"],"yoast_head":"\nPHP Installation Appears To Be Missing the MySQL Extension<\/title>\n<meta name=\"description\" content=\"The article provides the steps to resolve the error of PHP installation appears to be missing the MySQL extension.\" \/>\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.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHP Installation Appears To Be Missing the MySQL Extension\" \/>\n<meta property=\"og:description\" content=\"The article provides the steps to resolve the error of PHP installation appears to be missing the MySQL extension.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-29T07:45:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-29T08:47:57+00:00\" \/>\n<meta name=\"author\" content=\"Pallavi Godse\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pallavi Godse\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/\"},\"author\":{\"name\":\"Pallavi Godse\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"headline\":\"PHP Installation Appears To Be Missing the MySQL Extension\",\"datePublished\":\"2019-07-29T07:45:41+00:00\",\"dateModified\":\"2019-07-29T08:47:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/\"},\"wordCount\":430,\"commentCount\":0,\"keywords\":[\"MySQL\",\"MySQL extension\",\"PHP installation\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/\",\"name\":\"PHP Installation Appears To Be Missing the MySQL Extension\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\"},\"datePublished\":\"2019-07-29T07:45:41+00:00\",\"dateModified\":\"2019-07-29T08:47:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"description\":\"The article provides the steps to resolve the error of PHP installation appears to be missing the MySQL extension.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP Installation Appears To Be Missing the MySQL Extension\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\",\"name\":\"Pallavi Godse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g\",\"caption\":\"Pallavi Godse\"},\"description\":\"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.\",\"sameAs\":[\"https:\/\/www.milesweb.in\"],\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/author\/pallavi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHP Installation Appears To Be Missing the MySQL Extension","description":"The article provides the steps to resolve the error of PHP installation appears to be missing the MySQL extension.","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.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/","og_locale":"en_US","og_type":"article","og_title":"PHP Installation Appears To Be Missing the MySQL Extension","og_description":"The article provides the steps to resolve the error of PHP installation appears to be missing the MySQL extension.","og_url":"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2019-07-29T07:45:41+00:00","article_modified_time":"2019-07-29T08:47:57+00:00","author":"Pallavi Godse","twitter_misc":{"Written by":"Pallavi Godse","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/"},"author":{"name":"Pallavi Godse","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"headline":"PHP Installation Appears To Be Missing the MySQL Extension","datePublished":"2019-07-29T07:45:41+00:00","dateModified":"2019-07-29T08:47:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/"},"wordCount":430,"commentCount":0,"keywords":["MySQL","MySQL extension","PHP installation"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/","name":"PHP Installation Appears To Be Missing the MySQL Extension","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"datePublished":"2019-07-29T07:45:41+00:00","dateModified":"2019-07-29T08:47:57+00:00","author":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"description":"The article provides the steps to resolve the error of PHP installation appears to be missing the MySQL extension.","breadcrumb":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/php-installation-appears-to-be-missing-the-mysql-extension\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"PHP Installation Appears To Be Missing the MySQL Extension"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945","name":"Pallavi Godse","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3602d0ac1ab89332aea8205dcf474af4ff4eb319cfd584544038908cd5e4c966?s=96&d=blank&r=g","caption":"Pallavi Godse"},"description":"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.","sameAs":["https:\/\/www.milesweb.in"],"url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/pallavi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7965","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=7965"}],"version-history":[{"count":2,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7965\/revisions"}],"predecessor-version":[{"id":7971,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7965\/revisions\/7971"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=7965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=7965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=7965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}