The Ultimate Guide to High Availability with MariaDB

Login Question

I'm trying to log into a remote MairaDB and keep getting Host [IP] is not allowed to connect to this mariadb server.

{client side} tried both

mysql -p --port=3307 -h [hostname]
mysql -p --port=3307 -h [hostname.domain.xxx]

{server side} mysql login accounts tried

user/root @ %.domain.xxx
user/root @ hostname%

Both client and server are in DNS and resolvable.

What or how does mariadb determine when to use an IP vs hostname with connection security ?

Answer Answered by Ian Gilfillan in this comment.

A common issue is the bind_address. Check your my.cnf configuration to make sure it's not limiting you to local only. If so, comment it out and restart the server.

Otherwise take a look at: http://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server and https://dev.mysql.com/doc/refman/5.6/en/problems-connecting.html for other common issues.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.