Checking my Mysql server config file
- Status: Closed
- Hadiah: $10
- Penyertaan diterima: 2
- Pemenang: hieunghiemba
I can not connect to my mysql server from locally my network.
have contact server with ping and nmap
nmap [login to view URL] -p3306
Nmap scan report for [login to view URL] ([login to view URL])
Host is up (0.018s latency).
PORT STATE SERVICE
3306 / tcp open mysql
Host A = mysql server [login to view URL]
Host B = Client [login to view URL] I'm trying to connect me on Host A from Host B
I have changed to bind-address = 0.0.0.0 in my config file.
ERROR 1130 (HY000): Host '' is not allowed two connect to this MySQL server
Will start by checking config file
Important illumination. locally with localhost coves all good. the local Web server running on the same server as the mysql user I host localhost and user root. everything seems fine.
Now I will add data from [login to view URL] to [login to view URL] (only LAN) an
you can see my config file here: [login to view URL]
Maklum balas Majikan
“Quickly working and a good administrator, Thank you for your help”