Advertisement:

Author Topic: Cannot connect to the database server with the supplied data.  (Read 517 times)

Offline KILLERMANTV

  • Newbie
  • *
  • Posts: 4
Hello,
I am trying to install smf forum (ver. 2.0.15) on my website hosted locally on my synology nas, i am using mariaDB 10 and phpmyadmin where i already created account (with password, all privileges) and database named "forum", but this happens "Cannot connect to the database server with the supplied data."
What can i do ?
Thanks for help.




Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,104
Re: Cannot connect to the database server with the supplied data.
« Reply #1 on: March 11, 2018, 12:55:02 PM »
are you sure the database user is correct along with the password for that username?

Offline KILLERMANTV

  • Newbie
  • *
  • Posts: 4
Re: Cannot connect to the database server with the supplied data.
« Reply #2 on: March 11, 2018, 01:39:56 PM »
are you sure the database user is correct along with the password for that username?
It is 100% correct.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,104
Re: Cannot connect to the database server with the supplied data.
« Reply #3 on: March 11, 2018, 01:45:36 PM »
is mysql running on localhost or some other server? somewhere you are entering something incorrectly.

Offline KILLERMANTV

  • Newbie
  • *
  • Posts: 4
Re: Cannot connect to the database server with the supplied data.
« Reply #4 on: March 11, 2018, 03:25:12 PM »
is mysql running on localhost or some other server? somewhere you are entering something incorrectly.
It's running locally.

Offline tinoest

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 234
Re: Cannot connect to the database server with the supplied data.
« Reply #5 on: March 11, 2018, 03:41:01 PM »
Try 127.0.0.1 as the IP.

Offline KILLERMANTV

  • Newbie
  • *
  • Posts: 4
Re: Cannot connect to the database server with the supplied data.
« Reply #6 on: March 11, 2018, 03:49:10 PM »
Try 127.0.0.1 as the IP.
Thanks that worked!

Offline tinoest

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 234
Re: Cannot connect to the database server with the supplied data.
« Reply #7 on: March 12, 2018, 04:59:25 PM »
Try 127.0.0.1 as the IP.
Thanks that worked!

I think your earlier permission with any, localhost, no password was being picked up first which is why you were being denied access. 127.0.0.1 wasn’t listed so would meet the % requirement on the other username.

Offline attlebax

  • Newbie
  • *
  • Posts: 4
Re: Cannot connect to the database server with the supplied data.
« Reply #8 on: May 11, 2018, 03:36:02 PM »
There is a bug in mariadb and you might find that you can log in without a password. This has a knock-on effect and causes this problem.

So sudo mysql -u root allows you to login without a password and it shouldn't.

You have to -

UPDATE mysql.user SET plugin = '' WHERE user = 'root' AND host = 'localhost';
FLUSH PRIVILEGES;

It's the plugin that is the problem.