Differences

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

--- installation:ubuntu [2024/02/08 19:48] – [2. Install MySQL] demiankatz
+++ installation:ubuntu [2024/02/08 19:51] – [Database Issues] demiankatz
@@ Line 74: / Line 74: @@
   * **Case 1 - MySQL:** If you wish to connect to the root account through the web-based installer in order to set up VuFind®'s database, you should follow these steps:
     - Disable the root account's "auth_socket" plugin, which prevents regular logins, by logging in with ''sudo mysql -uroot'' and then running ''<nowiki>UPDATE mysql.user SET plugin='mysql_native_password' WHERE User='root'; FLUSH PRIVILEGES;</nowiki>''
-    - Quit the MySQL tool and run ''sudo /usr/bin/mysql_secure_installation'' at the command line to set a root password.
+    - Quit the MySQL tool and run ''sudo /usr/bin/mysql_secure_installation'' at the command line to automatically improve some database security settings.
+    - If the mysql_secure_installation process does not automatically help you set a root password, you may wish to do so manually, by logging in with ''sudo mysql -uroot'' and then running ''<nowiki>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'your-password-here';''
     - Edit /etc/mysql/mysql.conf.d/mysqld.cnf, add the appropriate line for your Ubuntu version to the bottom of the file:
       * **Ubuntu 20/21**: default_authentication_plugin=mysql_native_password