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: 170
Joined: 22. March 2013 12:29
XAMPP version: 10
Operating System: Windows, Linux, OS X

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

Postby alfontenelle » 13. June 2018 15:22

Mr. Beltran,

Good Morning!

I'm using XAMPP VM 7.2.5 on MacOS High Sierra.
To connect local MariaDB using Workbench or Navicat, do I need use which configuration?

I'm using
Hostname: localhost
Port: 3306
usernome: root
password: (NULL)

And doesn't working.

Best Regards!
alfontenelle
 
Posts: 1
Joined: 13. June 2018 15:13
XAMPP version: 7.2.5
Operating System: MAC OS High Sierra


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 21 guests