add below mention lines in /etc/my.cnf file
__________________________
port=3306
bind-address=0.0.0.0
# skip-networking
_______________________
net references
old_passwords=1
#bind-address=10.233.137.233 #can skip this line
port=3306
# skip-networking
_________________
Create user sync to linux pc
CREATE USER 'sync'@'%' IDENTIFIED BY 'sync';
GRANT ALL PRIVILEGES ON *.* TO 'sync'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
systemctl restart mariadb.service
__________________________
port=3306
bind-address=0.0.0.0
# skip-networking
_______________________
net references
old_passwords=1
#bind-address=10.233.137.233 #can skip this line
port=3306
# skip-networking
_________________
Create user sync to linux pc
CREATE USER 'sync'@'%' IDENTIFIED BY 'sync';
GRANT ALL PRIVILEGES ON *.* TO 'sync'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
systemctl restart mariadb.service
restart mysql service and check with telnet port 3306 able to access
Comments
Post a Comment