install_apache_mysql_php_linux_ubuntu_server
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
install_apache_mysql_php_linux_ubuntu_server [2020/06/08 04:37] – [Installing Apache2 (version 2.4)] wikiadmin | install_apache_mysql_php_linux_ubuntu_server [2020/06/08 18:46] – [Install MySQL Database Server] wikiadmin | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Installing Apache2 web server, MySQL database server, and PHP language | + | ====== Installing Apache2 web server, MySQL database server, and PHP language |
- | You can install these with LAMP or XAMPP or install each separately using apt-get installer. | + | You can install these with LAMP or XAMPP. You can also install |
As of April, May June, 2020, Let's install Apache 2.4, MySQL 8.0 and PHP 7.4 on Ubuntu 20.04 LTS. | As of April, May June, 2020, Let's install Apache 2.4, MySQL 8.0 and PHP 7.4 on Ubuntu 20.04 LTS. | ||
Line 150: | Line 150: | ||
Repeat the above steps for site www1 by changing the site-name to whatever it will be, such as www2.exmample.com | Repeat the above steps for site www1 by changing the site-name to whatever it will be, such as www2.exmample.com | ||
+ | ===== Install MySQL Database Server ===== | ||
+ | The apt repositories for Ubuntu 20.04 LTS contain MySQL server version 8.0. | ||
+ | |||
+ | Install mysql-server packages for the MySQL database. Also, install the php-mysql package to use MySQL support using PHP. Use the following command to install it. | ||
+ | |||
+ | < | ||
+ | |||
+ | The installer will prompt for the root password. This password will work for your MySQL root user. After installing MySQL execute the following command for initial settings of MySQL server. The script will ask more questions for settings than earlier MySQL versions, such as password validation policy etc. | ||
+ | |||
+ | Enter this command: | ||
+ | |||
+ | < | ||
+ | |||
+ | < | ||
+ | //Securing the MySQL server deployment.// | ||
+ | |||
+ | // | ||
+ | |||
+ | //VALIDATE PASSWORD COMPONENT can be used to test passwords | ||
+ | and improve security. It checks the strength of password | ||
+ | and allows the users to set only those passwords which are | ||
+ | secure enough. Would you like to setup VALIDATE PASSWORD component?// | ||
+ | |||
+ | **Press y|Y for Yes, any other key for No: y** | ||
+ | |||
+ | //There are three levels of password validation policy:// | ||
+ | |||
+ | //LOW Length >= 8// | ||
+ | |||
+ | //MEDIUM Length >= 8, numeric, mixed case, and special characters// | ||
+ | |||
+ | //STRONG Length >= 8, numeric, mixed case, special characters and dictionary file// | ||
+ | |||
+ | **Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 2** | ||
+ | |||
+ | //Please set the password for root here.// | ||
+ | |||
+ | **New password:** | ||
+ | |||
+ | **Re-enter new password:** | ||
+ | |||
+ | //Estimated strength of the password: 100// | ||
+ | |||
+ | **Do you wish to continue with the password provided? | ||
+ | |||
+ | //By default, a MySQL installation has an anonymous user, | ||
+ | allowing anyone to log into MySQL without having to have | ||
+ | a user account created for them. This is intended only for | ||
+ | testing, and to make the installation go a bit smoother. | ||
+ | You should remove them before moving into a production | ||
+ | environment.// | ||
+ | |||
+ | **Remove anonymous users? (Press y|Y for Yes, any other key for No) : y** | ||
+ | |||
+ | // | ||
+ | |||
+ | |||
+ | //Normally, root should only be allowed to connect from | ||
+ | ' | ||
+ | the root password from the network.// | ||
+ | |||
+ | **Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y** //(n should be considered)// | ||
+ | |||
+ | // | ||
+ | |||
+ | //By default, MySQL comes with a database named ' | ||
+ | anyone can access. This is also intended only for testing, | ||
+ | and should be removed before moving into a production | ||
+ | environment.// | ||
+ | |||
+ | |||
+ | **Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y** | ||
+ | |||
+ | // - Dropping test database...// | ||
+ | |||
+ | // | ||
+ | |||
+ | ** - Removing privileges on test database...** | ||
+ | |||
+ | // | ||
+ | |||
+ | //Reloading the privilege tables will ensure that all changes | ||
+ | made so far will take effect immediately.// | ||
+ | |||
+ | **Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y** | ||
+ | |||
+ | // | ||
+ | |||
+ | </ | ||
install_apache_mysql_php_linux_ubuntu_server.txt · Last modified: 2020/06/08 23:20 by wikiadmin