<\/p>\n
Type http:\/\/localhost\/phpmyadmin in browser Create new database (match the database name in the backup sql file) Copy from USB drive (files and folders under public_html folder\/) to \/var\/www\/html\/ folder<\/p>\n Open “wp-config.php” with Text Editor. <\/p>\n with<\/p>\n Ctrl + O with<\/p>\n Ctrl + O Open it in a text editor ( Inside the block, add the following lines:<\/span><\/p>\n Ctrl + O How to Install WordPress on Raspberry Pi<\/a> Preparation Take full backup of existing system Copy files to USB drive (extFat format) On Raspberry Pi: Update system sudo apt-get update sudo apt-get upgrade Mount USB Drive sudo apt install exfat-fuse exfat-utils Install Apache sudo apt install apache2 -y Install MariaDB sudo apt-get install mariadb-server -y Install PHP sudo apt-get install php php-mysql […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-3675","post","type-post","status-publish","format-standard","hentry","category-20"],"_links":{"self":[{"href":"http:\/\/www.hi-alex.com\/index.php?rest_route=\/wp\/v2\/posts\/3675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.hi-alex.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.hi-alex.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.hi-alex.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.hi-alex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3675"}],"version-history":[{"count":0,"href":"http:\/\/www.hi-alex.com\/index.php?rest_route=\/wp\/v2\/posts\/3675\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.hi-alex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.hi-alex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3675"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.hi-alex.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}sudo apt-get update<\/code>
\nsudo apt-get upgrade<\/code><\/p>\nMount USB Drive<\/h4>\n
sudo apt install exfat-fuse exfat-utils<\/code><\/p>\nInstall Apache<\/h4>\n
sudo apt install apache2 -y<\/code><\/p>\nInstall MariaDB<\/h4>\n
sudo apt-get install mariadb-server -y<\/code><\/p>\nInstall PHP<\/h4>\n
sudo apt-get install php php-mysql -y<\/code><\/p>\nInstall PHPMyAdmin<\/h4>\n
sudo apt install phpmyadmin<\/code>
\nselect \"apache2\" option by pressing SPACE and then ENTER<\/code>
\nselect \"Yes\" at the next prompt<\/code>
\nSet a password for PHPMyAdmin<\/code><\/p>\nCreate a new user to create and access data tables within PHPMyadmin<\/h4>\n
sudo mysql -u root -p<\/code>
\nGRANT ALL PRIVILEGES ON *.* TO 'username<\/span>'@'localhost' IDENTIFIED BY 'password_set_in_previous_step<\/span>' WITH GRANT OPTION;<\/code>
\nexit out of MySQL cmd line by typing “quit” in the terminal<\/p>\nConfiguring Apache for PHPMyAdmin<\/h4>\n
sudo nano \/etc\/apache2\/apache2.conf<\/code>
\nAdd the following line to the bottom of the file:
\nInclude \/etc\/phpmyadmin\/apache.conf<\/code>
\nSave and exit by pressint CTRL + X and then pressing Y then ENTER.<\/p>\nRestart Apache service<\/h4>\n
sudo service apache2 restart<\/code><\/p>\nAccessing PHPMyAdmin<\/h4>\n
\nUser Name and Password are the ones set in previous step.<\/p>\nInstall GEdit<\/h4>\n
sudo apt install gedit -y<\/code><\/p>\nIncrease import file size of PHPMyAdmin<\/h4>\n
sudo gedit \/etc\/php\/7.3\/apache2\/php.ini<\/code>
\nupdate the following values:
\nmemory_limit: 256M (default = 128)<\/code>
\npost_max_size: 64M<\/code>
\nupload_max_filesize: 40M<\/code>
\nSave and exit.
\nRestart apache
\nsudo \/etc\/init.d\/apache2 restart<\/code><\/p>\nImport Database<\/h4>\n
\nGo to Import tab (ignore errors), select backup sql file and import<\/p>\n“Install” WordPress<\/h4>\n
Edit “wp-config.php”<\/h4>\n
\nUpdate the following values:
\nDB_USER
\nDB_PASSWORD
\nAlso, add the following values:
\ndefine(‘WP_SITEURL’, ‘http:\/\/www.hi-alex.com\/’);
\ndefine(‘WP_HOME’, ‘http:\/\/www.hi-alex.com\/’);<\/p>\nDone<\/h4>\n
Fixing phpmyadmin “phpmyadmin – count(): Parameter must be an array or an object that implements Countable” error:<\/h4>\n
sudo nano +613 \/usr\/share\/phpmyadmin\/libraries\/sql.lib.php<\/code>
\nreplace code<\/p>\n((empty($analyzed_sql_results['select_expr']))\n || (count($analyzed_sql_results['select_expr'] == 1)\n && ($analyzed_sql_results['select_expr'][0] == '*')))<\/code><\/pre>\n((empty($analyzed_sql_results['select_expr']))\n || (count($analyzed_sql_results['select_expr']) == 1)\n && ($analyzed_sql_results['select_expr'][0] == '*'))\n<\/code><\/pre>\n
\nEnter
\nCtrl + X
\nsudo service apache2 restart<\/code>
\nsudo nano +613 \/usr\/share\/phpmyadmin\/libraries\/sql.lib.php<\/code>
\nreplace code<\/p>\nif<\/span> (<\/span>$options <\/span>!=<\/span> null <\/span>&&<\/span> count<\/span>(<\/span>$options<\/span>)<\/span> ><\/span> 0<\/span>)<\/span> {\n<\/span><\/code><\/pre>\nif<\/span> (<\/span>$options <\/span>!=<\/span> null <\/span>&&<\/span> count<\/span>((<\/span>array<\/span>)<\/span>$options<\/span>)<\/span> ><\/span> 0<\/span>)<\/span> {<\/span><\/code><\/pre>\n
\nEnter
\nCtrl + X
\nsudo service apache2 restart<\/code>
\n <\/p>\nSecuring phpmyadmin, block access from internet<\/h4>\n
sudo nano \/etc\/phpmyadmin\/apache.conf<\/code>) and find the block that looks like:<\/span><\/p>\n<Directory \/usr\/share\/phpmyadmin>\n...\n<\/Directory>\n<\/span><\/pre>\nOrder Deny,Allow\nDeny from all<\/span>\nAllow from localhost\nAllow from 127.0.0.1\nAllow from 192.168.68.0\/24\n<\/span><\/pre>\n
\nEnter
\nCtrl + X
\nsudo service apache2 restart<\/code>
\n <\/span><\/p>\nMap www.hi-alex.com to a sub folder under \/var\/www\/html\/<\/h4>\n
sudo nano \/etc\/apache2\/sites-enabled\/000-default.conf<\/code>
\nAdd the following lines:
\nServerAdmin webmaster@localhost<\/code>
\nDocumentRoot \/var\/www\/html\/blog<\/code>
\nServerName www.hi-alex.com<\/code>
\nCtrl + O
\nEnter
\nCtrl + X
\n <\/p>\nReferences:<\/h4>\n
\nHow to Install phpmyadmin on Raspberry Pi<\/a>
\nIncrease phpmyadmin import file size<\/a>
\nMount ExFat disk on Raspberry Pi<\/a>
\nCopy or Move WordPress to Another Server<\/a>
\nFix phpmyadmin error<\/a>
\nFix phpmyadmin error on Import tab<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"