{"id":1699,"date":"2019-04-11T21:42:18","date_gmt":"2019-04-11T21:42:18","guid":{"rendered":"https:\/\/draculaservers.com\/tutorials\/?p=1699"},"modified":"2021-11-14T20:34:08","modified_gmt":"2021-11-14T20:34:08","slug":"update-secure-phpmyadmin","status":"publish","type":"post","link":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/","title":{"rendered":"Secure phpMyAdmin against PLEASE_READ.WARNING Attack"},"content":{"rendered":"

phpMyAdmin<\/strong> is a free and open-source MariaDB and MySQL management tool. It’s among the most popular web-based tools that enable you to manage databases, execute SQL queries, manage accounts, export, and import data and much more.<\/p>\n

Unfortunately, it’s a target for hacking attempts, and if those attempts succeed they can cause irreparable damage as hackers can steal or delete sensitive information.<\/p>\n

For that reason, you should keep phpMyAdmin updated, as it will have the latest patches against recent exploits, and secure it against automated attacks by adding extra layers of security.<\/p>\n

Having software that is not up to date on servers is a risky move.  In 2019, phpMyAdmin<\/strong> has been the target of random attacks from botnets.<\/p>\n\n

PLEASE_READ.WARNING Attack<\/h2>\n

This attack deletes all the databases it finds and replaces them with a table name WARNING<\/strong> containing “To recover your lost data SEND BTC”.  There are serveral variations that may ask for different BTC sums or have a different database name.<\/p>\n

It appears that the attacker only deletes the data and there isn’t a way to recover them from the attacker, but this may be different from case to case. One of the people that have first detected the attack has written a detailed description<\/a>.<\/p>\n

A database exploited by this attack will look like the picture below.<\/p>\n

\"SQL<\/a><\/p>\n

In this tutorial we’ll learn how to manually update phpMyAdmin to the latest version, change phpMyAdmin default access URL and add an authentication gateway that requires an extra set of credentials before logging in. This tutorial is aimed at phpMyAdmin running with Apache Web Server<\/strong> on Ubuntu 18.04<\/strong><\/p>\n

\r\n
\r\n
\r\n

Need Help?<\/p>\r\n\r\n<\/div>\r\n

\r\n

Have a server from a different provider and need help? Hit us up!<\/p>\r\n\r\n<\/div>\r\n

\r\n

We offer various services to assist you in achieving your business goal. Working in the industry, we've gained proficiency various areas related to hosting.\r\n
\r\n

\r\n[Proficiencies Include]<\/span><\/br>\r\n  - RADIUS
\r\n  - WHMCS
\r\n  - LAMP Stack
\r\n  - LEMP Stack
\r\n  - VPN Protocols
\r\n  - SMTP
\r\n  - Remote Desktop Solutions
\r\n  - Linux in general
\r\n<\/div>\r\n<\/p>\r\n\r\n<\/div>\r\n
\r\n

Hire Us<\/p>\r\n\r\n<\/div>\r\n

HIT US UP<\/a><\/div>\r\n<\/div>\r\n<\/div>\n

How to Update phpMyAdmin to the latest Version<\/h2>\n

First, install phpMyAdmin from the official Ubuntu repositories:<\/p>\n

$ sudo apt-get install phpmyadmin<\/code><\/pre>\n
Now, change directory into \/usr\/share<\/code>:<\/p>\n
$ sudo cd \/usr\/share<\/code><\/pre>\n
Remove the phpMyAdmin directory<\/strong>:<\/p>\n
$ sudo rm -rf phpmyadmin<\/code><\/pre>\n
Use wget<\/code> to download the latest phpMyAdmin version. You can find the packages with the latest version here phpMyAdmin – Downloads<\/a>.<\/p>\n
The current latest version at the time of writing is 4.8.5, so we’ll download that one:<\/p>\n
$ wget -P \/usr\/share\/ https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.8.5\/phpMyAdmin-4.8.5-english.zip<\/code><\/pre>\n
Next, unzip it:<\/p>\n
$ unzip phpMyAdmin-4.8.5-english.zip<\/code><\/pre>\n
Finally we rename the unzipped folder phpMyAdmin-4.8.5-english<\/code> to phpmyadmin<\/code>:<\/p>\n
$ mv phpMyAdmin-4.8.5-english phpmyadmin<\/code><\/pre>\n
IMPORTANT<\/h2>\n
If you log into phpMyAdmin now, you’ll see two errors:<\/p>\n
the configuration file now needs a secret passphrase (blowfish_secret). phpmyadmin\nThe $cfg['TempDir'] (.\/tmp\/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.<\/code><\/pre>\n
To fix the first error, just run the following:<\/p>\n
$ cd \/usr\/share\/phpmyadmin\n$ cp config.sample.inc.php config.inc.php<\/code><\/pre>\n
Now you’ll have to add a Blowfish Secret in config.inc.php<\/code>. To do this, visit the following link to generate a Blowfish Secret https:\/\/www.motorsportdiesel.com\/tools\/blowfish-salt\/pma\/<\/a>. Copy the secret so we can paste it into config.inc.php<\/code>.<\/p>\n
When you’ve copied it, open the file config.inc.php<\/code>:<\/p>\n
$ sudo nano config.inc.php<\/code><\/pre>\n
And paste in the Blowfish Secret – you’ll notice the section right away. In my case right now, it’s t&GeQ>FhO@sG]\/b*&Y9lVG1mh\\UQ3CYP<\/code><\/p>\n
Credit goes to user CRIMSON 501 from askubuntu.com<\/a> for the Blowfish Secret generator made especially for phpMyAdmin.<\/small><\/p><\/blockquote>\n
Here’s how the section should look after you’ve pasted it in:<\/p>\n
\/**\n * This is needed for cookie based authentication to encrypt password in\n * cookie. Needs to be 32 chars long.\n *\/\n$cfg['blowfish_secret'] = 't&GeQ>FhO@sG]\/b*&Y9lVG1mh\\UQ3CYP'; \/* YOU MUST FILL IN THIS FOR COOKIE AUTH! *\/<\/code><\/pre>\n
Save and close the file.<\/p>\n
Lastly, we need to create a tmp<\/code> directory for phpMyAdmin and give Apache ownership over it:<\/p>\n
$ sudo mkdir tmp\n$ sudo chown -R www-data:www-data \/usr\/share\/phpmyadmin\/tmp<\/code><\/pre>\n
Well done. You’ve not upgraded your phpMyAdmin to the latest version.<\/p>\n
Changing Default phpMyAdmin Location<\/h2>\n
As attackers will probe for common locations on any software they’re trying to hack, we’ll change the default path<\/p>\n
http:\/\/domain_or_IP\/phpmyadmin<\/code><\/p>\n
to<\/p>\n
https:\/\/domain_or_IP\/somethingunexpected<\/code><\/p>\n
To change the phpMyAdmin default access URL on Ubuntu 18.04, open \/etc\/apache2\/conf-enabled\/phpmyadmin.conf<\/code> using your favorite text editor:<\/p>\n
$ sudo nano \/etc\/apache2\/conf-enabled\/phpmyadmin.conf<\/code><\/pre>\n
Among first lines ( line 3<\/strong> ) you’ll see:<\/p>\n
Alias \/phpmyadmin \/usr\/share\/phpmyadmin<\/code><\/pre>\n
Change it to something unexpected like:<\/p>\n
Alias \/castleentrance \/usr\/share\/phpmyadmin<\/code><\/pre>\n
Restart Apache:<\/p>\n
$ sudo service apache2 restart<\/code><\/pre>\n
Now you should be able to access phpMyAdmin by visiting:<\/p>\n
https:\/\/domain_or_IP\/castleentrance<\/code><\/pre>\n
Add Auth Gateway to phpMyAdmin<\/h2>\n
As an additional layer of security, we can add a popup that requires an extra login, before our usual phpMyAdmin login.<\/p>\n
To do this on Ubuntu 18.04, open the Apache configuration file and add these lines to it:<\/p>\n
\n    AuthType Basic\n    AuthName \"Restricted Content\"\n    AuthUserFile \/etc\/apache2\/.htpasswd\n    Require valid-user\n<\/code><\/pre>\n
To give you a complete example, here’s how mine looks after adding the lines:<\/p>\n
\n        # The ServerName directive sets the request scheme, hostname and port that\n        # ...\n        #ServerName www.example.com\n\n        ServerAdmin webmaster@localhost\n        DocumentRoot \/var\/www\/html\n\n        # Available loglevels: trace8, ..., trace1, debug, info, notice, warn,\n        # ...\n        #LogLevel info ssl:warn\n\n        ErrorLog ${APACHE_LOG_DIR}\/error.log\n        CustomLog ${APACHE_LOG_DIR}\/access.log combined\n\n        # For most configuration files from conf-available\/, which are\n        # ...\n        #Include conf-available\/serve-cgi-bin.conf\n\n        \n            AuthType Basic\n            AuthName \"Restricted Content\"\n            AuthUserFile \/etc\/apache2\/.htpasswd\n            Require valid-user\n        \n\n\n\n# vim: syntax=apache ts=4 sw=4 sts=4 sr noet<\/code><\/pre>\n
Save and close the file when you’re done.<\/p>\n
Now use htpasswd<\/strong> to generate a password file for an account that will be allowed to access the phpMyAdmin<\/code> login page on Ubuntu 18.04. I’ll use the username dracula<\/code>, but you can use anything you want:<\/p>\n
$ sudo htpasswd -c \/etc\/apache2\/.htpasswd dracula<\/code><\/pre>\n
You’ll be prompted to create a password and enter it again to confirm it.<\/p>\n
Finally we’ll change the permissions for the file, to prevent anyone not in the www-data<\/code> or apache<\/code> group from being able to access it:<\/p>\n
$ sudo chmod 640 \/etc\/apache2\/.htpasswd\n$ chgrp www-data \/etc\/apache2\/.htpasswd<\/code><\/pre>\n
And you’re done.<\/p>\n
Now you can go to your phpMyAdmin<\/code> access URL and you should be prompted for the extra credentials.<\/p>\n
After changing the phpMyAdmin access URL and added the extra authentication gateway, here’s how it looks like:<\/p>\n
\"phpMyAdmin_auth_gateway\"<\/a><\/p>\n
Conclusion<\/h2>\n
Well done. You’ve learned how to manually upgrade phpMyAdmin and add 2 extra layers of security to your phpMyAdmin installation.<\/p>\n
\r\n
\r\n
\r\n
Need Help?<\/p>\r\n\r\n<\/div>\r\n
\r\n
Have a server from a different provider and need help? Hit us up!<\/p>\r\n\r\n<\/div>\r\n
\r\n
We offer various services to assist you in achieving your business goal. Working in the industry, we've gained proficiency various areas related to hosting.\r\n
\r\n
\r\n[Proficiencies Include]<\/span><\/br>\r\n  - RADIUS
\r\n  - WHMCS
\r\n  - LAMP Stack
\r\n  - LEMP Stack
\r\n  - VPN Protocols
\r\n  - SMTP
\r\n  - Remote Desktop Solutions
\r\n  - Linux in general
\r\n<\/div>\r\n<\/p>\r\n\r\n<\/div>\r\n
\r\n
Hire Us<\/p>\r\n\r\n<\/div>\r\n
HIT US UP<\/a><\/div>\r\n<\/div>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"
phpMyAdmin is a free and open-source MariaDB and MySQL management tool. It’s among the most popular web-based tools that enable you to manage databases, execute SQL queries, manage accounts, export, and import data and much more. Unfortunately, it’s a target for hacking attempts, and if those attempts succeed they can cause irreparable damage as hackers […]<\/p>\n","protected":false},"author":1,"featured_media":1701,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[64,22],"tags":[42,43,49,96],"class_list":["post-1699","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-open-source","category-ubuntu","tag-apache","tag-phpmyadmin","tag-security","tag-web-servers"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"featured_image_urls_v2":{"full":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png",1024,512,false],"thumbnail":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04-150x150.png",150,150,true],"medium":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04-300x150.png",300,150,true],"medium_large":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04-768x384.png",768,384,true],"large":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04-1024x512.png",1024,512,true],"1536x1536":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png",1024,512,false],"2048x2048":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png",1024,512,false],"pk-small":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04-80x80.png",80,80,true],"pk-thumbnail":["https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04-300x225.png",300,225,true]},"post_excerpt_stackable_v2":"
phpMyAdmin is a free and open-source MariaDB and MySQL management tool. It’s among the most popular web-based tools that enable you to manage databases, execute SQL queries, manage accounts, export, and import data and much more. Unfortunately, it’s a target for hacking attempts, and if those attempts succeed they can cause irreparable damage as hackers can steal or delete sensitive information. For that reason, you should keep phpMyAdmin updated, as it will have the latest patches against recent exploits, and secure it against automated attacks by adding extra layers of security. Having software that is not up to date on…<\/p>\n","category_list_v2":"Open-source<\/a>, Ubuntu<\/a>","author_info_v2":{"name":"Vlad","url":"https:\/\/draculaservers.com\/tutorials\/author\/vlad\/"},"comments_num_v2":"1 comment","yoast_head":"\nSecure phpMyAdmin against PLEASE_READ.WARNING Attack<\/title>\n<meta name=\"description\" content=\"In this tutorial we learn how to update phpMyAdmin to the latest version, change default access URL & add an extra set of credentials before logging in.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Secure phpMyAdmin against PLEASE_READ.WARNING Attack\" \/>\n<meta property=\"og:description\" content=\"In this tutorial we learn how to update phpMyAdmin to the latest version, change default access URL & add an extra set of credentials before logging in.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Dracula Servers Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-11T21:42:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-14T20:34:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vlad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vlad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/\"},\"author\":{\"name\":\"Vlad\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/931f7fa8b2126ace6edfb82775e0ec0e\"},\"headline\":\"Secure phpMyAdmin against PLEASE_READ.WARNING Attack\",\"datePublished\":\"2019-04-11T21:42:18+00:00\",\"dateModified\":\"2021-11-14T20:34:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/\"},\"wordCount\":756,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png\",\"keywords\":[\"Apache\",\"phpMyAdmin\",\"Security\",\"Web Servers\"],\"articleSection\":[\"Open-source\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/\",\"name\":\"Secure phpMyAdmin against PLEASE_READ.WARNING Attack\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png\",\"datePublished\":\"2019-04-11T21:42:18+00:00\",\"dateModified\":\"2021-11-14T20:34:08+00:00\",\"description\":\"In this tutorial we learn how to update phpMyAdmin to the latest version, change default access URL & add an extra set of credentials before logging in.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/#primaryimage\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png\",\"contentUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png\",\"width\":1024,\"height\":512,\"caption\":\"secure_update_phpmyadmin_ubuntu_apache\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/update-secure-phpmyadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Secure phpMyAdmin against PLEASE_READ.WARNING Attack\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#website\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/\",\"name\":\"Dracula Servers Tutorials\",\"description\":\"Dedicated Servers\",\"publisher\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#organization\",\"name\":\"Dracula Servers\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/dracula_full_logo_smaller.png\",\"contentUrl\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/dracula_full_logo_smaller.png\",\"width\":1625,\"height\":200,\"caption\":\"Dracula Servers\"},\"image\":{\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/draculaservers.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/931f7fa8b2126ace6edfb82775e0ec0e\",\"name\":\"Vlad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g\",\"caption\":\"Vlad\"},\"description\":\"Tech Support\",\"sameAs\":[\"https:\\\/\\\/draculaservers.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Secure phpMyAdmin against PLEASE_READ.WARNING Attack","description":"In this tutorial we learn how to update phpMyAdmin to the latest version, change default access URL & add an extra set of credentials before logging in.","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:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"Secure phpMyAdmin against PLEASE_READ.WARNING Attack","og_description":"In this tutorial we learn how to update phpMyAdmin to the latest version, change default access URL & add an extra set of credentials before logging in.","og_url":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/","og_site_name":"Dracula Servers Tutorials","article_published_time":"2019-04-11T21:42:18+00:00","article_modified_time":"2021-11-14T20:34:08+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png","type":"image\/png"}],"author":"Vlad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vlad","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/"},"author":{"name":"Vlad","@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/person\/931f7fa8b2126ace6edfb82775e0ec0e"},"headline":"Secure phpMyAdmin against PLEASE_READ.WARNING Attack","datePublished":"2019-04-11T21:42:18+00:00","dateModified":"2021-11-14T20:34:08+00:00","mainEntityOfPage":{"@id":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/"},"wordCount":756,"commentCount":1,"publisher":{"@id":"https:\/\/draculaservers.com\/tutorials\/#organization"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png","keywords":["Apache","phpMyAdmin","Security","Web Servers"],"articleSection":["Open-source","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/","url":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/","name":"Secure phpMyAdmin against PLEASE_READ.WARNING Attack","isPartOf":{"@id":"https:\/\/draculaservers.com\/tutorials\/#website"},"primaryImageOfPage":{"@id":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png","datePublished":"2019-04-11T21:42:18+00:00","dateModified":"2021-11-14T20:34:08+00:00","description":"In this tutorial we learn how to update phpMyAdmin to the latest version, change default access URL & add an extra set of credentials before logging in.","breadcrumb":{"@id":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/#primaryimage","url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png","contentUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2019\/04\/How-to-Secure-Update-phpMyAdmin-to-Latest-Version-on-Ubuntu-18.04.png","width":1024,"height":512,"caption":"secure_update_phpmyadmin_ubuntu_apache"},{"@type":"BreadcrumbList","@id":"https:\/\/draculaservers.com\/tutorials\/update-secure-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/draculaservers.com\/tutorials\/"},{"@type":"ListItem","position":2,"name":"Secure phpMyAdmin against PLEASE_READ.WARNING Attack"}]},{"@type":"WebSite","@id":"https:\/\/draculaservers.com\/tutorials\/#website","url":"https:\/\/draculaservers.com\/tutorials\/","name":"Dracula Servers Tutorials","description":"Dedicated Servers","publisher":{"@id":"https:\/\/draculaservers.com\/tutorials\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/draculaservers.com\/tutorials\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/draculaservers.com\/tutorials\/#organization","name":"Dracula Servers","url":"https:\/\/draculaservers.com\/tutorials\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/logo\/image\/","url":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2016\/06\/dracula_full_logo_smaller.png","contentUrl":"https:\/\/draculaservers.com\/tutorials\/wp-content\/uploads\/2016\/06\/dracula_full_logo_smaller.png","width":1625,"height":200,"caption":"Dracula Servers"},"image":{"@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/draculaservers.com\/tutorials\/#\/schema\/person\/931f7fa8b2126ace6edfb82775e0ec0e","name":"Vlad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/499c7a24aa9727703300a291f8f69dfd1b01b8d6a19a4ae4fbe669b4b12b8cbe?s=96&d=mm&r=g","caption":"Vlad"},"description":"Tech Support","sameAs":["https:\/\/draculaservers.com"]}]}},"_links":{"self":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/comments?post=1699"}],"version-history":[{"count":4,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1699\/revisions"}],"predecessor-version":[{"id":2554,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/posts\/1699\/revisions\/2554"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/media\/1701"}],"wp:attachment":[{"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/media?parent=1699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/categories?post=1699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/draculaservers.com\/tutorials\/wp-json\/wp\/v2\/tags?post=1699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}