MariaDB: Host is not allowed to connect to this MariaDB

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

MariaDB: Host is not allowed to connect to this MariaDB

Postby skirka » 21. October 2017 18:47

I installed on my new Mac latest XAMPP-VM 7.1.10. When I want to connect to Mysql, I always get this error. I have same error in DataGrip and Sequal Pro. Photo https://i.stack.imgur.com/abHGh.png
skirka
 
Posts: 1
Joined: 21. October 2017 18:44
XAMPP version: 7.1.10
Operating System: MAC OS

Re: MariaDB: Host is not allowed to connect to this MariaDB

Postby Beltran » 24. October 2017 08:56

Hi,

MariaDB is configured to not accept external connections for security reasons. You can use the XAMPP UI to create a tunnel for MariaDB: Network -> localhost:3306 -> 3306. That way you are able to access using 127.0.0.1 as host.

I hope it helps.

$ mysql -u root -h 127.0.0.1
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.5.5-10.1.25-MariaDB Source distribution
User avatar
Beltran
Power-User
 
Posts: 138
Joined: 22. March 2013 12:29
Operating System: Windows, Linux, OS X


Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 3 guests