{"id":1801,"date":"2021-03-13T13:53:22","date_gmt":"2021-03-13T13:53:22","guid":{"rendered":"https:\/\/blog.gordonbuchan.com\/blog\/?p=1801"},"modified":"2021-05-29T20:22:59","modified_gmt":"2021-05-29T20:22:59","slug":"web-presence-step-by-step-chapter-9-installing-and-configuring-phpmyadmin-to-manage-mysql-databases","status":"publish","type":"post","link":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/2021\/03\/13\/web-presence-step-by-step-chapter-9-installing-and-configuring-phpmyadmin-to-manage-mysql-databases\/","title":{"rendered":"Web presence step by step Chapter 9: Installing and configuring phpMyAdmin to manage MySQL databases"},"content":{"rendered":"\n

Previous step: Chapter 8: Installing and configuring WordPress to create a website<\/a>
Next step: Chapter 10: Integrating Google Site Kit with WordPress to view Google Analytics and Google Search Console visitor statistics<\/a><\/p>\n\n\n\n

Web presence step by step is a series of posts that show you to how to build a web presence.<\/p>\n\n\n\n

In this post, we install and configure phpMyAdmin to manage MySQL databases.<\/p>\n\n\n\n

This post assumes that you have performed the steps described in Chapter 8: Installing and configuring WordPress to create a website<\/a>.<\/p>\n\n\n\n

A note re MySQL and MariaDB<\/h1>\n\n\n\n

A few years ago, the company that owned MySQL was purchased by Oracle. The open source code was legally \u201cforked\u201d into a project called MariaDB. When this document refers to \u201cMySQL,\u201d it is actually referring to the MariaDB descendant of the MySQL database engine, made possible by the terms of the GPLv2 open source software license. Notice that to maintain compatibility with existing software, the command to invoke MariaDB on the command line is \u201cmysql.\u201d<\/p>\n\n\n\n

Installing the php-xml and php-mbstring libraries<\/h1>\n\n\n\n

Use an SSH terminal program to connect to the Ubuntu Linux cloud server you created in Chapter 3: Buying an Ubuntu Linux cloud server from Digital Ocean<\/a>. Enter the commands:<\/p>\n\n\n\n

apt install php-xml php-mbstring\nsystemctl restart apache2<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Generating a blowfish secret passphrase (blowfish_secret)<\/h1>\n\n\n\n
phpMyAdmin uses an encryption cipher called “blowfish.” We need to generate a blowfish secret passphrase to customize the phpMyAdmin config.inc.php configuration file.<\/p>\n\n\n\n
Use a web browser to visit the site:<\/p>\n\n\n\n
https:\/\/phpsolved.com\/phpmyadmin-blowfish-secret-generator\/?g=[insert_php]echo%20$code;[\/insert_php]<\/a><\/p>\n\n\n\n
Select the text in the line under “to,” right-click (or command-click on MacOS), then select “Copy”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Keep this web browser window open. You will need to copy the text in the line above to the clipboard then paste it into the config.inc.php file in one of the steps below.<\/p>\n\n\n\n
Downloading the phpMyAdmin zip file<\/h1>\n\n\n\n
Use a web browser to visit the site:<\/p>\n\n\n\n
https:\/\/www.phpmyadmin.net\/<\/a><\/p>\n\n\n\n
Click on the link “Download x.x.x” (where “x.x.x” represents the current version number):<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Extracting the phpMyAdmin zip file<\/h1>\n\n\n\n
(Reminder: there are detailed examples in Chapter 8: Installing and configuring WordPress to create a website<\/a> that show how to extract the contents of a zip file for each operating system.)<\/p>\n\n\n\n
Go to the file manager for your operating system (Windows File Explorer, MacOS Finder, Linux Nautilus).<\/p>\n\n\n\n
Windows<\/h2>\n\n\n\n
In File Explorer, right-click on the phpMyAdmin zip file. Select “Extract All.” In the next dialog, click “Extract.”<\/p>\n\n\n\n
MacOS<\/h2>\n\n\n\n
If you downloaded the phpMyAdmin zip file with Safari<\/h3>\n\n\n\n
if you downloaded the phpMyAdmin zip file with Safari, the zip file’s contents will be already be extracted as a directory in the Downloads directory.<\/p>\n\n\n\n
If you downloaded the phpMyAdmin zip file with Chrome<\/h3>\n\n\n\n
In Finder, go to the Downloads directory. Double-click on the phpMyAdmin zip file. The Archive Manager will extract the contents of the phpMyAdmin zip file to a directory in the Downloads directory.<\/p>\n\n\n\n
Linux<\/h2>\n\n\n\n
In Nautilus, go to the Downloads directory. Right-click on the phpMyAdmin zip file. Select “Open with Archive Manager.” In Archive Manager, click on “Extract.” In the next dialog, click on “Extract.”<\/p>\n\n\n\n
Renaming the phpMyAdmin-x-x-x-x directory, renaming and editing the config.inc.php configuration file<\/h1>\n\n\n\n
Windows<\/h2>\n\n\n\n
Use File Explorer. Locate the phpMyAdmin directory nested within a directory of the same name). Right-click on the directory. Select “Rename”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
enter the text “phpmyadmin”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Locate the file “config.sample.inc.php” file. Right-click on the file. Select “Rename”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Enter the text “config.inc.php”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Right-click on the file “config.inc.php,” select “Open with…”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Select the “Notepad” application. Check the box “Always use this app to open .php files.” Click OK:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Paste the blowfish secret string you obtained earlier in the step “Generating a blowfish secret passphrase (blowfish_secret)” into the $cfg[‘blowfish_secret’] string assignment. Be careful to place single quotes (‘) before and after the blowfish_secret string:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
MacOS<\/h2>\n\n\n\n
In Finder, locate the phpMyAdmin directory. Command-click on the directory. Select “Rename”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Enter the text “phpmyadmin”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Locate the “config.sample.inc.php” file. Command-click on the file. Select “Rename”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Enter the text “config.inc.php”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Command-click on the file. Select “Always Open With,” select “TextEdit”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Paste the blowfish secret string you obtained earlier in the step “Generating a blowfish secret passphrase (blowfish_secret)” into the $cfg[‘blowfish_secret’] string assignment. Be careful to place single quotes (‘) before and after the blowfish_secret string:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Linux<\/h2>\n\n\n\n
In Nautilus, locate the phpMyAdmin directory. Right-click on the directory. Select “Rename”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Enter the text “phpmyadmin”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Locate the “config.sample.inc.php” file. Right-click on the file. Select “Rename”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Enter the text “config.inc.php”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Right-click on the file. Select “Open With Other Application”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Click on “View All Applications”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Select “Text Editor.” Click on “Select”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Paste the blowfish secret string you obtained earlier in the step “Generating a blowfish secret passphrase (blowfish_secret)” into the $cfg[‘blowfish_secret’] string assignment. Be careful to place single quotes (‘) before and after the blowfish_secret string:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
A note about the example domain and a reminder that you should use your domain name in its place<\/h1>\n\n\n\n
For clarity and narrative flow we are using the example domain linuxstepbystep.com but you should substitute your domain name as appropriate.<\/p>\n\n\n\n
Uploading the “phpmyadmin” directory to the Ubuntu Linux cloud server<\/h1>\n\n\n\n
Use the FileZilla file transfer program to connect to the Ubuntu Linux cloud server you created in Chapter 3: Buying an Ubuntu Linux cloud server from Digital Ocean<\/a>. In the left (local) panel, locate the local phpmyadmin directory. Right-click (for MacOS, command-click) on the directory and select “Upload”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Wait for the file transfer to complete:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Accessing the phpMyAdmin application using a web browser<\/h1>\n\n\n\n
Use a web browser to visit your domain name followed by “\/phpmyadmin”:<\/p>\n\n\n\n
https:\/\/linuxstepbystep.com\/phpmyadmin<\/p>\n\n\n\n
(These are the MySQL username and password that were created in Chapter 8: Installing and configuring WordPress to create a website<\/a>: “Creating the MySQL database for the WordPress site.”)<\/p>\n\n\n\n
Enter values for the “Username:” and “Password:” fields. Click on “Go”:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
This screen appears. Click on the name of the database in the left panel:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Click on a table in the left panel:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Table view:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Previous step: Chapter 8: Installing and configuring WordPress to create a website<\/a>
Next step: Chapter 10: Integrating Google Site Kit with WordPress to view Google Analytics and Google Search Console visitor statistics<\/a><\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Previous step: Chapter 8: Installing and configuring WordPress to create a websiteNext step: Chapter 10: Integrating Google Site Kit with WordPress to view Google Analytics and Google Search Console visitor statistics Web presence step by step is a series of posts that show you to how to build a web presence. In this post, we … <\/p>\n
Continue reading “Web presence step by step Chapter 9: Installing and configuring phpMyAdmin to manage MySQL databases”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1801","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=1801"}],"version-history":[{"count":139,"href":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1801\/revisions"}],"predecessor-version":[{"id":2560,"href":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1801\/revisions\/2560"}],"wp:attachment":[{"href":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=1801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=1801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.gordonbuchan.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=1801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}