During an upgrade of WordPress, I realised it was about time I figured out how to backup my databases. This led to the requirement for phpMyAdmin, and this section.<\/p>\n
There doesn’t seem to be any Debian packaging for phpMyAdmin, so I just went to the homepage<\/a> and downloaded it. It consists of a single tarball that gets extracted into the \/var\/www document root, and then one configuration file config.inc.php that needs the userid and password of the MySQL administrator entered.<\/p>\n Without some security, this configuration is now wide open for anyone to access the phpMyAdmin system and play with the databases. I solved this by editing the \/etc\/apache2\/sites-available\/default configuration file, and inserting the following:<\/p>\n Alias \/phpmyadmin\/ “\/var\/www\/phpMyAdmin-2.6.1\/” During an upgrade of WordPress, I realised it was about time I figured out how to backup my databases. This led to the requirement for phpMyAdmin, and this section. There doesn’t seem to be any Debian packaging for phpMyAdmin, so I just went to the homepage and downloaded it. It consists of a single tarball… Continue reading phpMyAdmin<\/span><\/a><\/p>\n","protected":false},"author":24,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-14","post","type-post","status-publish","format-standard","hentry","category-wordpress","entry"],"_links":{"self":[{"href":"https:\/\/blog.stmellion.org\/index.php?rest_route=\/wp\/v2\/posts\/14","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.stmellion.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.stmellion.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.stmellion.org\/index.php?rest_route=\/wp\/v2\/users\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.stmellion.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14"}],"version-history":[{"count":0,"href":"https:\/\/blog.stmellion.org\/index.php?rest_route=\/wp\/v2\/posts\/14\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.stmellion.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.stmellion.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.stmellion.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n <Directory \/var\/www\/phpMyAdmin-2.6.1\/>
\n Options Indexes FollowSymLinks MultiViews
\n AllowOverride None
\n Order allow,deny
\n allow from my ip address<\/i>
\n <\/Directory><\/p>\n","protected":false},"excerpt":{"rendered":"