Web based family history software

Question Unable to connect using this username and password

  • rickkumar
  • Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 11 months ago - 4 years 11 months ago #1 by rickkumar
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? Xvideos Xnxx Chaturbate
Last edit: 4 years 11 months ago by rickkumar.

Please Log in or Create an account to join the conversation.

More
4 years 11 months ago #2 by PeBu
Maybe the problem is your PHP version, I think you need at least PHP version 7.1

Please Log in or Create an account to join the conversation.

More
4 years 11 months ago #3 by fisharebest
Replied by fisharebest on topic Unable to connect using this username and password
> PHP 7.0.27

As PeBu says, the latest code requires PHP 7.1 or higher

> But username and password is OK. I tried it on CLI and successfully loggged in

I don't know about MariaDB, but the later versions of MySQL *only* allow root to connect from the CLI.
It can't be used for network/socket connections.

What "hostname" did you use for the connection details? "localhost"? "127.0.0.1"? etc.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

More
4 years 11 months ago #4 by xmlf
Don't use root connect database.
It is not safe, you can create a new user, connect to the database with a new user.
When creating a new user, be aware that the account's permission comes from the option.

Wang Family Website of Suining County, China
www.snwsjz.com
A family tree website that is customized, more humanized and convenient for users.

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum
}