Can't remote connect to Mariadb even following the setup guides.
I’m not sure if you can help here but I followed your page on how to install mariadb on centos 7 https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-centos-7 and I seem to have an issue. I can access the database only if I’m logged directly into the VM it’s running on. It won’t allow me access via ssh or mysql workbench 6.2. I have double checked the port. and added myself as a user using the “GRANT ALL PRIVILEGES ON . TO testuser@‘address’ IDENTIFIED BY 'secretpassword’;” and then flushed privileges and restarted mariadb. Nothing seems to work. Do you have any ideas as to why this might be? I did check the my.cnf file and it seems to be different than the one shows on the official mariadb site. https://mariadb.com/kb/en/mariadb/documentation/getting-started/configuring-mariadb-for-remote-client-access/ .
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×