For issues related to the current stable release please use it's own Help forum.
IMPORTANT:Please read this before using an git or nightly build version: wiki.webtrees.net/en/GIT

Before asking for help please read "How to request help" by clicking on that tab above here.

TOPIC: Unable to connect using this username and password

Unable to connect using this username and password 9 months 1 day ago #1

  • nejman
  • nejman's Avatar
  • Offline
  • New
  • Posts: 15
Hi. I cannot connect to database. I'm receiving the following msg:

Unable to connect using this username and password. Your server gave the following error.
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
Check the settings and try again.

But username and password is OK. I tried it on CLI and successfully loggged in. I also tried to change localhost to socket (/var/run/mysqld/mysqld.sock), and I'm receiving the same error message.
MariaDB: 10.1.26-MariaDB-0+deb9u1 Debian 9.1
PHP 7.0.27
latest GIThub version, commit 21d3012

Any idea?
The administrator has disabled public write access.

Unable to connect using this username and password 9 months 1 day ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10615
Newer versions of MySQL (and I guess MariaDB) only allow the "root" user to be used at the command line.

Try creating a different user for your webtrees installation.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Unable to connect using this username and password 9 months 1 day ago #3

  • nejman
  • nejman's Avatar
  • Offline
  • New
  • Posts: 15
Perfect, another account is OK. You have right, it looks that a root account is allowed only from CLI. Now, I'm able to finish setup. Once again, thank you.
The administrator has disabled public write access.
Moderators: makitso
Powered by Kunena Forum