Connect to MYSQL database.

[slaw]

I want connect to my mysql base which is on another computer. Now i'm using phpmyadmin, but it takes too much time, and i'm often using it, and i know something about sql so its time waste.

I tried via command line, but doesnt work, server not responding.

mysql -u xxx -h 91.121.31.13 -p

I'm entering password, and getting this error after some seconds:

ERROR 2003 (HY000): Can't connect to MySQL server on '91.121.31.13' (10060)

 

[Cato]

Are you sure it is running? LOL

telnet 91.121.31.13 3306

I'm getting a connection refused.

 

[slaw]

What is running? Mysql server? Yes!

If you mean server, then yes too! Just check website. ;>

 

[Cato]

Any firewalls blocking port 3306?

 

[slaw]

Its possible, that windows blocking it. 2003 server. brb

 

[Cato]

Check if windows firewall is turned on. If it is. Turn it off.

 

[slaw]

No this, after port open:

ERROR 1130 (00000): Host 'MYIP' is not allowed to connect to this MySQL
server

 

[Cato]

Are you sure you are connecting with the right user to the host?
Or have added you@ip to the user table?

 

[slaw]

Are you sure you are connecting with the right user to the host?
Or have added you@ip to the user table?

yes, with right user. No, i not added. It will work without restart mysql?

#Edit

I see table "db", there is "Host" and is setted - "localhost" can i add more IP, or only 1 can be?

 

[Cato]

Maybe you have done something wrong. Check them again.

SQL> GRANT ALL PRIVILEGES ON database.* TO user@'ip' IDENTIFIED BY 'pw' WITH GRANT OPTION;

Comment out skip networking or try bind mysql to your global ip.

Edit:

You can add % which will work for all ip's.

 

[Pvls]

Change config of mysql, now your mysql allows only connection from localhost, fill this with "*" or leave empty ""