GChester
(G Chester)
June 21, 2021, 4:08am
1
A while back I had problems installing on Windows and setting up MySQL. It seems the config file does not get read and it uses some default mysql@localhost, but that username is not in the config file anywhere.
Error 1045: Access denied for mysql@localhost
I’ve seen 3 other theads with the same issue but no resolution. It just seems to work after a bit.
I’m having to set up a new server and our config file looks like this;
"DriverName": "mysql",
"DataSource": "mysql://custom_mmuser:Password@tcp(127.0.0.1:3306)/custom_mattermost_db?sslmode=disable\u0026connect_timeout=10",
I’m getting this error when we run the server;
Failed to ping DB","error":"Error 1045: Access denied for user 'mysql'@'localhost' (using password: YES)","retrying in seconds":10}
The odd thing is the username “mysql@localhost” does not match and nothing I do in the config …
https://forum.mattermost.com/t/error-failed-to-ping-db-retrying-in-10-seconds-err-error-1045-access-denied-for-user-mmuser-localhost-using-password-yes/3676
Summary
In my configuration, the DB host is on the remote host
root@public:/opt/mattermost# ./bin/mattermost config get "SqlSettings"
DataSource: "mattermost:password@tcp(192.168.1.200:3306)/mattermost?charset=utf8mb4,utf8&readTimeout=30s&writeTimeout=30s"
DataSourceReplicas: "[]"
MaxIdleConns: "20"
MaxOpenConns: "300"
AtRestEncryptKey: "ezw39cnq7rjafxegq4nguk3rgzy3audp"
QueryTimeout: "30"
DriverName: "mysql"
DataSourceSearchReplicas: "[]"
ConnMaxLifetimeMilliseconds: "3600000"
Trace: "false"
B…