1

After upgrading my vps with Ubuntu 16.04 (and after a month or so) I need to use the MySQL server that was running there. Actually it was a MariaDB instance but it seems it's not making any difference. Since I couldn't connect with a ssh tunnel as I always did, I tried accessing from the remote shell directly and using the mysql cli interface it works. The matter is I need to use the MySQL server from the local IP (for remote tunneling or for mysqli on php). Trying to force the tcp connection with mysql --protocol tcp I get ERROR 1698 (28000): Access denied for user 'root'@'localhost', while php gives this warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost'.

I tried purging MariaDB, reinstalling it, trying with MySQL package itself, removing every mysql configuration and file, but with no results.

The configuration always includes bind-address = 127.0.0.1 and related port and it's not commented but it seems useless.

Any ideas?

Improve this question
1
  • Take a look at this Q&A Commented Sep 13, 2016 at 17:40

1 Answer 1

Reset to default
0

I found it out. There was an unix_socket plugin associated with the root account. I just ran update user set plugin=''; and restarted the mysql process and it worked.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.