I install the MySQL from the Ubuntu server cd(15.04). When installation is finished, I found that the configure files under /etc/MySQL/, such as my.cnf and MySQL.cnf are all empty.
So I want access my database from other terminals, I did the following job:
(1) Created a user for host '%' with all privileges; (2) Made firewall utw allowing MySQL; (3) insert a line in the my.cnf with: bind-address = 0.0.0.0;
(4)restart the MySQL serverice.
it does no effect. Remote connect is still denied.
I checked the variables in MySQL, the bind_address variable shows binding with 127.0.0.1. And the netstat command shows that port 3306 is only binded with 127.0.0.1. I don't know why the configure information in my.cnf has no effect?
The configure file shows below:
[mysqld] bind-address = 0.0.0.0
Any one can help me?