Step 2.<\/strong> Select PHP as the language and choose Ubuntu 22.04 elastic VPS. Click on install.<\/p>\n Step 1.<\/strong> Navigate to \u2018Web SSH\u2019<\/a> of your elastic VPS.<\/p>\n Step 2.<\/strong> Update the package list to get the latest information on available packages:<\/p>\n Step 3.<\/strong> Install the Apache web server and automatically confirm the installation:<\/p>\n Step 4.<\/strong> Enable Apache to start on boot:<\/p>\n Step 5. <\/strong>Check the current status of the Apache service:<\/p>\n Step 6. <\/strong>Start the Apache web server:<\/p>\n Step 7. <\/strong>Verify that the Apache web server is running:<\/p>\n Step 1.<\/strong> Navigate to \u2018Web SSH\u2019<\/strong> of your Elastic VPS.<\/p>\n Step 1. <\/strong>Installing MySQL<\/p>\n Step 3.<\/strong> Then, start the MySQL service:<\/p>\n Step 4.<\/strong>\u00a0Configuring MySQL<\/p>\n Step 5.<\/strong> Change the root user password:<\/p>\n Sep 6.<\/strong> Exit the MySQL shell:<\/p>\n Sep 7.<\/strong> Secure the MySQL installation:<\/p>\n Step 8.<\/strong> Log in to MySQL again:<\/p>\n Step 9.<\/strong> Change the root user authentication method:<\/p>\n Step 10.<\/strong> Creating a Dedicated MySQL User and Granting Privileges<\/p>\n Step 1.<\/strong> To check your databases, use:<\/p>\n Step 2.<\/strong> To see all the tables:<\/p>\n This guide outlines the steps to install and configure MySQL, create a dedicated user, and grant appropriate privileges.<\/p>\n Step 1.<\/strong> Go to the \u2018setting\u2019<\/strong> of your environment and choose the Firewall tab.<\/p>\n Step 2. <\/strong>Select the \u2018inbound rules\u2019<\/strong> tab and click on \u2018Add\u2019<\/strong> to add a new inbound rule.<\/p>\n Step 3. <\/strong>Enter the name \u2018HTTPS\u2019.<\/strong> For the port range, enter port 80.<\/p>\n Step 4. <\/strong>The new inbound rule is added to the firewall.<\/p>\n Step 5. <\/strong>Now, navigate to \u2018Web SSH\u2019<\/strong> of your elastic VPS.<\/p>\n![\"New](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/New-Environment-01-1.png\" "\\"New")
<\/a><\/p>\n<\/a><\/p>\nManual installation of Apache<\/h2>\n
<\/a><\/p>\n\r\n`sudo apt update`<\/code><\/pre>\n<\/a><\/p>\n\r\n`sudo apt install apache2 -y`<\/code><\/pre>\n<\/a><\/p>\n\r\n`sudo systemctl enable apache2`<\/code><\/pre>\n\r\n`sudo systemctl status apache2`<\/code><\/pre>\n\r\n`sudo systemctl start apache2`<\/code><\/pre>\n\r\n`sudo systemctl status apache2`<\/code><\/pre>\n<\/a><\/p>\nManual Installation of MySQL<\/h2>\n
<\/a><\/p>\n\n
\n
\r\n \t<\/a><\/p>\n\r\nsudo systemctl start mysql.service\r\nsudo systemctl status mysql.service<\/code><\/pre>\n<\/a><\/p>\n\n
\n
\r\n \t\n
\r\n \t<\/a><\/p>\n\n
\n
\r\n \t<\/a><\/p>\n<\/a><\/p>\n\n
\r\n \t<\/a><\/p>\n\n
\r\n \t<\/a><\/p>\n\n
\n
\r\n \t\n
\r\n \t\n
\r\n \t<\/a><\/p>\nGrant the necessary privileges to the new user:<\/h3>\n
\r\nGRANT CREATE, ALTER, DROP, INSERT, UPDATE, INDEX, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'sammy'@'localhost' WITH GRANT OPTION;<\/code><\/pre>\n\r\nGRANT ALL PRIVILEGES ON *.* TO 'sammy'@'localhost' WITH GRANT OPTION;<\/code><\/pre>\n<\/a><\/p>\n\n
\r\n \t<\/a><\/p>\n\n
\r\n \t<\/a><\/p>\nManual Installation of php<\/h2>\n
<\/a><\/p>\n