- Posts: 1
Question Unable to connect using this username and password
- rickkumar
- Topic Author
- Offline
- New Member
Less
More
4 years 11 months ago - 4 years 11 months ago #1
by rickkumar
Unable to connect using this username and password was created 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
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.
- PeBu
- Offline
- New Member
4 years 11 months ago #2
by PeBu
Replied by PeBu on topic Unable to connect using this username and password
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.
- fisharebest
- Offline
- Administrator
4 years 11 months ago #3
by fisharebest
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
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.
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.
- xmlf
- Offline
- Junior Member
4 years 11 months ago #4
by xmlf
Wang Family Website of Suining County, China
www.snwsjz.com
A family tree website that is customized, more humanized and convenient for users.
Replied by xmlf on topic Unable to connect using this username and password
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.
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.