funny thing: I thought maybe installation is not completed yet. Looking at the browser address bar it showed:
http://localhost/dolibarr/
So I just tried to type in the browser address bar:
http://localhost/dolibarr/install/
And now I am back on the installation page with a bunch of additional options for install. So that resolves the fact that I can no longer get to the install page.
However, now the original error is still present.
So to summarise:
- I created database dolibarr
- I created <user> for database dolibarr
- When I check the users vs database vs host it confirms what I have done.
On the installation page I have the following fields filled in:
- database name: dolibarr
- driver type: mysqli (MySQL or MariaDB >=5.0.3)
- Database server: localhost
- Port: 3306
- Database table prefix: llx_
- Create database: Checked/yes
- Login: <user>
- Password: <password>
- Create user account or grant user account permission on the Dolibarr database: checked/yes
- Database server - Superuser access
- Login: root (greyed out)
- password: blank
I know that since database is already created and user already exists I should uncheck these boxes. But want to show what happens when I click Next:
Access denied for user ‘root’@‘localhost’
The database connection failed: the host or super user parameters must be wrong.
Go back and check/correct the parameters.
So I go back and change the superuser parameters:
- database name: dolibarr
- driver type: mysqli (MySQL or MariaDB >=5.0.3)
- Database server: localhost
- Port: 3306
- Database table prefix: llx_
- Create database: Checked/yes
- Login: <user>
- Password: <password>
- Create user account or grant user account permission on the Dolibarr database: checked/yes
- Database server - Superuser access
- Login: root (greyed out)
- password: <password> --> at least the password I set at a very early stage. Might not be correct.
Resulting in the same error:
Access denied for user ‘root’@‘localhost’
The database connection failed: the host or super user parameters must be wrong.
Go back and check/correct the parameters.
So possibly wrong password.
Trying to reset root password using the following instructions:
Successfully changed password.
On the installation page still the same error.
So I suppose since database and user exist I could uncheck those boxes.
- database name: dolibarr
- driver type: mysqli (MySQL or MariaDB >=5.0.3)
- Database server: localhost
- Port: 3306
- Database table prefix: llx_
- Create database: UnChecked/No
- Login: <user>
- Password: <password>
- Create user account or grant user account permission on the Dolibarr database: unchecked/no
- root options disappear.
Now I can go on to the next step.
I guess I figured this part out by myself in the end. Not sure though where the whole thing went wrong in the first place.