Introduction to MySQL - Revision history

Todd: /* Installing and Configuring MySQL */

2024-06-24T20:58:17Z

Installing and Configuring MySQL

2024-06-05T16:23:52Z

Installing phpMyAdmin

2024-06-05T16:23:27Z

Installing and Configuring MySQL

2024-06-05T16:07:46Z

Installing and Configuring MySQL

2024-06-05T16:06:52Z

Installing and Configuring MySQL

2024-06-05T16:01:42Z

Installing and Configuring MySQL

2023-01-10T05:53:51Z

Installing phpMyAdmin

2023-01-10T05:52:57Z

MySQL User Management

2023-01-10T05:50:55Z

Managing Databases

2023-01-10T05:50:16Z

Using MySQL from the Command Line

@@ Line 26: / Line 26: @@
 <source lang="bash">
-$ sudo yum install -y mariadb105-server php-mbstring
+$ sudo yum install -y mariadb105-server php-mbstring php-mysqli
 </source>

@@ Line 143: / Line 143: @@
 <source lang="bash">
 $ cd /var/www/html
-$ wget 'https://files.phpmyadmin.net/phpMyAdmin/5.0.4/phpMyAdmin-5.0.4-all-languages.tar.gz'
+$ wget 'https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.tar.gz'
 $ ls
-phpMyAdmin-5.0.4-all-languages.tar.gz
+phpMyAdmin-5.2.1-all-languages.tar.gz
-$ mkdir phpmyadmin && tar -xvzf phpMyAdmin-5.0.4-all-languages.tar.gz -C phpmyadmin --strip-components 1
+$ mkdir phpmyadmin && tar -xvzf phpMyAdmin-5.2.1-all-languages.tar.gz -C phpmyadmin --strip-components 1
 $ ls
-phpmyadmin  phpMyAdmin-5.0.4-all-languages.tar.gz
+phpmyadmin  phpMyAdmin-5.2.1-all-languages.tar.gz
-$ rm phpMyAdmin-5.0.4-all-languages.tar.gz
+$ rm phpMyAdmin-5.2.1-all-languages.tar.gz
 </source>

@@ Line 45: / Line 45: @@
 When it asks for the current password for root, press Enter.  When it asks to switch to unix_socket authentication press Enter (which defaults to the answer Y or Yes). When asked to change your root password press Enter (which also defaults to Y).
-Type in the new password, press Enter, and then type the new password again.  You cannot see what you are typing because a password is supposed to be secret.  If the shell displayed the password to you while you were typing it, it would be forever saved in ''~/.bash_history''!
+Next, we will type in a new password. Please choose a fairly secure password and avoid short or obvious passwords. Type in the new password, press Enter, and then type the new password again.  You cannot see what you are typing because a password is supposed to be secret. If the shell displayed the password to you while you were typing it, it would be forever saved in ''~/.bash_history''!
 Finally press Enter to the remaining three questions (remove anonymous users, disallow root login remotely, remote test database).

@@ Line 45: / Line 45: @@
 When it asks for the current password for root, press Enter.  When it asks to switch to unix_socket authentication press Enter (which defaults to the answer Y or Yes). When asked to change your root password press Enter (which also defaults to Y).
-When it asks, type the new password, press Enter, and then type the new password again.  You cannot see what you are typing because a password is supposed to be secret.  If the shell displayed the password to you while you were typing it, it would be forever saved in ''~/.bash_history''!
+Type in the new password, press Enter, and then type the new password again.  You cannot see what you are typing because a password is supposed to be secret.  If the shell displayed the password to you while you were typing it, it would be forever saved in ''~/.bash_history''!
 Finally press Enter to the remaining three questions (remove anonymous users, disallow root login remotely, remote test database).

@@ Line 21: / Line 21: @@
 == Installing and Configuring MySQL ==
-To use MySQL, you need the MySQL Server package.  Because we will be interacting with MySQL primarily from PHP scripts, we will also need the associated PHP libraries. In '''yum (RHEL)''', you need the packages '''mariadb-server''' and '''php-mbstring''', and from '''amazon-linux-extras''', you need the package '''lamp-mariadb10.2-php7.2'''. If you're wondering what MariaDB is, it is a fork of MySQL server that is recommended by Amazon for use with Linux 2 AMI systems. For our purposes, MariaDB and MySQL are effectively identical.
+To use MySQL, you need the MySQL Server package.  Because we will be interacting with MySQL primarily from PHP scripts, we will also need the associated PHP libraries. In '''yum (RHEL)''', you need the packages '''mariadb105-server''' and '''php-mysqlnd'''. If you're wondering what MariaDB is, it is a fork of MySQL server that is recommended by Amazon for use with Linux 2 AMI systems. For our purposes, MariaDB and MySQL are effectively identical.
 To install these packages from their respective package repositories, run the following two commands:
 <source lang="bash">
-$ sudo yum install -y mariadb-server php-mbstring
+$ sudo yum install -y mariadb105-server php-mbstring
 </source>

@@ Line 42: / Line 42: @@
 <source lang="bash">
-$ mysqladmin -u root password
+$ sudo mysql_secure_installation
 </source>
 When it asks, type the new password, press Enter, and then type the new password again.  You cannot see what you are typing because a password is supposed to be secret.  If the shell displayed the password to you while you were typing it, it would be forever saved in ''~/.bash_history''!
 == Using MySQL from the Command Line ==

@@ Line 134: / Line 134: @@
 To add your user to the apache group:
-  $ sudo usermod -a -G apache YOUR_USERNAME
+  $ sudo usermod -a -G apache <YOUR_USERNAME>
 '''Note you may have to exit your server and ssh back in for this to take effect'''
 Change the owner of the www folders to your user, and the group apache
-  $ sudo chown -R YOUR_USERNAME:apache /var/www
+  $ sudo chown -R <YOUR_USERNAME>:apache /var/www
 '''Now that you can access the /var/www/html directory''' download phpMyAdmin to apache's root directory using '''wget''', extract it using '''tar -xzvf''', and then remove the archive using '''rm''':

@@ Line 92: / Line 92: @@
 <source lang="mysql">
-create user 'USERNAME'@'localhost' identified by 'PASSWORD';
+create user '<USERNAME>'@'localhost' identified by '<PASSWORD>';
 </source>
@@ Line 102: / Line 102: @@
 <source lang="mysql">
-grant PRIVILEGES on DATABASE.TABLE to USERNAME@'localhost';
+grant <PRIVILEGES> on <DATABASE>.<TABLE> to <USERNAME>@'localhost';
 </source>
@@ Line 108: / Line 108: @@
 <source lang="mysql">
-grant all on *.* to USERNAME@'localhost' with grant option;
+grant all on *.* to <USERNAME>@'localhost' with grant option;
 </source>
@@ Line 116: / Line 116: @@
 <source lang="mysql">
-grant select,insert,update,delete on DATABASE.* to USERNAME@'localhost';
+grant select,insert,update,delete on <DATABASE>.* to <USERNAME>@'localhost';
 </source>

@@ Line 68: / Line 68: @@
 <source lang="mysql">
-create database DATABASENAME;
+create database <DATABASENAME>;
 </source>
@@ Line 74: / Line 74: @@
 <source lang="mysql">
-drop database DATABASENAME;
+drop database <DATABASENAME>;
 </source>
@@ Line 80: / Line 80: @@
 <source lang="mysql">
-use DATABASENAME;
+use <DATABASENAME>;
 </source>

@@ Line 55: / Line 55: @@
 <source lang="bash">
-$ mysql -u USERNAME -p DATABASENAME
+$ mysql -u <USERNAME> -p <DATABASENAME>
 Welcome to the MariaDB monitor. ...