MyBB Community Forums

Hi,

I have installed myBB 1.8.22 on a Windows Server 2019. I have also installed MySQL 8.0 on that server. I am able to successfully connect to MySQL using the MySQL Workbench.

When attempting the Database Configuration step, I get the following error:

__________________________
There seems to be one or more errors with the database configuration information that you supplied:

Could not connect to the database server at 'localhost' with the supplied username and password

__________________________

In addition to localhost, I tried the following with the same error:

127.0.0.1
MySQL80

MySQL was installed using the default port of 3306.

I am using the root account to connect and I know that works because I am able to connect through MySQL Workbench using the same credentials. Any ideas as to what might be happening and how to fix this?

Thanks in advance for any assistance.

---

I found the problem. You cannot use the root login. I created a new user account and it worked.

try using localhost:3306 for the database server ..

I'm not sure but maybe it's because how MySQL's root account is being authenticated.

On Linux, in some distributions, MySQL's root account's authentication is restricted to use system's root account by setting root user's plugin field to auth_socket. See https://stackoverflow.com/questions/3928...0#42742610 and https://askubuntu.com/questions/763336/c...08#1059308

In order to use root to login into MySQL here, one might need to change root user's plugin's value from auth_socket to mysql_native_password. Anyway, a second MySQL user with relevant privileges could be created for using.