English Czech
Add New Rule to Firewalld
After changing this line, save and close the file and then restart the MySQL service:
Allow Access
bind-address = 0.0.0.0
Configuration files:
Connecting
CREATE USER 'your_username'@'host_ip_addr' IDENTIFIED BY 'your_password';
Creating a USER
Editing Conf. Files:
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.100.%'
IDENTIFIED BY 'my-new-password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'your_username'@'%';
IDENTIFIED BY 'my-new-password' WITH GRANT OPTION;
How To Allow Remote Access MYSQL/MariaDB/MYSQL Community
It is common for people to want to create a "root" user that can connect from anywhere, so as an example, we'll do just that, but to improve on it we'll create a root user that can connect from anywhere on the local area network (LAN)
MariaDB -> `/etc/my.conf`
MySql Community -> `/etc/my.cnf.d/community-mysql-server.cnf`
MySql -> `/etc/my.cnf/`
mysql -u [USER] -h [IP] -p
Navigate to the line that begins with the bind-address directive. It will look like this: you could set this directive to a wildcard IP address, either *, ::, or 0.0.0.0:
Open SQL port (3306) on FireWalld: