By JimF
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/ .
Thanks, Jim
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
This question was answered by @asb:
What kind of error are you getting? Is it connecting then failing on authorization, or does it fail immediately? Is there firewalling set up on the server? Try opening the port of MariaDB:
firewall-cmd --permanent --zone=public --add --port=3306/tcp
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.