Differences

This shows you the differences between two versions of the page.

--- setuplampubuntu22 [2025/04/29 00:26] – tektinkers
+++ setuplampubuntu22 [2025/05/15 00:35] (current) – tektinkers
@@ Line 21: / Line 21: @@
 <code>exit</code>
 <code>sudo mysql_secure_installation</code>
+**MySQL: Creating Users and Databases**
+<code>sudo mysql -u root -p</code>
+//Change "example_database", "example_user" and "password" to whatever you want://
+<code>CREATE DATABASE example_database;</code>
+<code>CREATE USER 'example_user'@'%' IDENTIFIED BY 'password';</code>
+//OPTIONAL - Change password of users://
+<code>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';</code>
+<code>GRANT ALL ON example_database.* TO 'example_user'@'%';</code>
+<code>exit</code>
 **Installing PHP**
@@ Line 71: / Line 85: @@
 <code>sudo apache2ctl configtest</code>
 <code>sudo systemctl reload apache2</code>
-**MySQL: Creating Users and Databases**
-//Change "example_database", "example_user" and "password" to whatever you want://
-<code>CREATE DATABASE example_database;</code>
-<code>CREATE USER 'example_user'@'%' IDENTIFIED BY 'password';</code>
-//OPTIONAL - Change password of users://
-<code>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';</code>
-<code>GRANT ALL ON example_database.* TO 'example_user'@'%';</code>
-<code>exit</code>
 \\
 \\
 \\
 Credit to: [[https://www.digitalocean.com/community/tutorials/how-to-install-lamp-stack-on-ubuntu|https://www.digitalocean.com/community/tutorials/how-to-install-lamp-stack-on-ubuntu]]