On 12/7/20 4:59 AM, Mark Hounschell wrote:
On 12/7/20 3:58 AM, Per Jessen wrote:
Mark Hounschell wrote:
And when I go there with my browser I get
Software error:
Can't connect to the database. Error: Access denied for user 'root'@'localhost' Is your database installed and up and running? Do you have the correct username and password selected in localconfig?
For help, please send mail to the webmaster (webmaster@compro.net), giving this error message and the time and date of the error.
I did use 'root' as user in my localconfig and also used the system's root password as the password.
Did you also grant access to root@localhost, in mysql ?
MariaDB [(none)]> GRANT ALL PRIVILEGES ON bugs.* TO 'root'@'localhost'; Query OK, 0 rows affected (0.004 sec)
Did not help.
I added a bugs user to mysql. Reconfigured localconfig for the bugs user and new password. smfg:/srv/www/bugzilla # mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 11 Server version: 10.4.14-MariaDB MariaDB package Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> CREATE USER 'bugs'@'localhost' IDENTIFIED BY 'bugs11'; Query OK, 0 rows affected (0.008 sec) MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'bugs'@'localhost'; Query OK, 0 rows affected (0.004 sec) MariaDB [(none)]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.001 sec) MariaDB [(none)]> quit; Bye Why does it keep saying "0 rows affected"? In any case switching from root/root-password to bugs/bugs-password I now get a bugzilla page in my browser. My admin login appears to be there. But none of the bugzilla settings are there. They must not be kept in the database. What file/files from the old bugzilla system do I need to copy over to get the old settings? Thanks Mark