Changes between Version 16 and Version 17 of Csle2022/Agenda/databaseandweb

Timestamp:

Nov 29, 2022, 11:15:12 AM (2 years ago)

Author:

admin

Comment:

--

Csle2022/Agenda/databaseandweb

@@ -305 +305 @@
 }}}
 
-Then create a user for the database.
-
-{{{
-CREATE USER 'wordpressuser'@'localhost' IDENTIFIED BY 'dala1234';
-}}}
-
-Next you need to grant permissions to user to do any operations on the database as below.
-
-{{{
-GRANT ALL ON wordpress.* TO 'wordpressuser'@'localhost';
+Next you need to grant permissions to user called wordpressuser to do any operations on the database as below.
+
+{{{
+grant all privileges on wordpress.* to 'wordpressuser'@'localhost' IDENTIFIED BY 'dala1234';
 }}}
 
@@ -320 +314 @@
 
 {{{
-UPDATE mysql.user set plugin = 'mysql_native_password' where User = 'wordpressuser';
+ALTER USER wordpressuser@localhost IDENTIFIED VIA mysql_native_password;
 }}}
 
@@ -389 +383 @@
 
 {{{
-touch wordpress/.htaccess
+sudo touch wordpress/.htaccess
 }}}
 
@@ -395 +389 @@
 
 {{{
-cp wordpress/wp-config-sample.php wordpress/wp-config.php
+sudo cp wordpress/wp-config-sample.php wordpress/wp-config.php
 }}}
 
@@ -401 +395 @@
 
 {{{
-mkdir -p wordpress/wp-content/upgrade
+sudo mkdir -p wordpress/wp-content/upgrade
 }}}
 
@@ -407 +401 @@
 
 {{{
-cp -a wordpress/. /var/www/wp.your_domain.com/public_html/
+sudo cp -a wordpress/. /var/www/wp.your_domain.com/public_html/
 }}}
 
@@ -413 +407 @@
 
 {{{
-chown -R www-data:www-data /var/www/wp.your_domain.com
+sudo chown -R www-data:www-data /var/www/wp.your_domain.com
 }}}
 
@@ -419 +413 @@
 
 {{{
-find wp.your_domain.com/public_html/  -type d -exec chmod 750 {} \;
-find wp.your_domain.com/public_html/  -type f -exec chmod 640 {} \;
+cd /var/www
+
+sudo find wp.your_domain.com/public_html/  -type d -exec chmod 750 {} \;
+sudo find wp.your_domain.com/public_html/  -type f -exec chmod 640 {} \;
+}}}
 
 Now we are going to modify the configuration file we have added earlier. Here we will configure WordPress security keys and database connection settings.
@@ -435 +432 @@
 
 {{{
-nano /var/www/wp.your_domain.com/public_html/wp-config.php
+sudo nano /var/www/wp.your_domain.com/public_html/wp-config.php
 }}}
 
@@ -463 +460 @@
 The other change we need to make is to set the method that WordPress should use to write to the filesystem. Since we’ve given the web server permission to write where it needs to, we can explicitly set the filesystem method to “direct”.
 
+{{{
 define('FS_METHOD', 'direct');
+}}}
 
 Now we are done with configuration of the WordPress.  To begin the installation you have to access the WordPress URL from the web browser. Enter the http://wp.your_domain.com/ on the browser and we need to follow the steps as below.