BIG BIG PROBLEMS, with mysql remote connect

marconi8

i have founded this one !

Use the following outline to connect and begin querying the mySQL server from a Telnet. Remember that you cannot connect to your databases remotely due to security concerns, you can only connect from localhost.

security concerns - where ????, all people told me that i must to make in user table hosts for that users who trying to connect

all hosts i have type like - all hosts, but i still cannot connect

nnichols

the "host" entry in the user table of the mysql db must be set to "%" for that user to connect from any IP.

If you are the server admin then this is not a problem, but if you have only access to a single db (INSERT,SELECT, DELETE, CREATE) then you will be unable to change entries in the user table.

Hope this helps 😉

marconi8

in database mysql in tables user and db i have edited values host, i changed them to %, after this i stop mysql.server and start

nothing helps ??

marconi8

anybody , can help me 🙁

i have already readed all about user privileges and access denied on mysql.com, all is working on my webserwer, but i still cannot to connect

thanks

nnichols

Explain your situation and what does/does not happen.

Are you trying to connect to local or remote server?
What platform are you running / is the server on?
What code are you using to try to connect?
What errors do you receive?

Have you downloaded MySQL-Front yet?

marconi8

it is two pc, one pc is my pc, but second pc is remote server pc far from me, remote server is
- mandrake8.2 linux
- mysql 3.23.51

on remote server i can easly add/rem/del mysql users,db,privileges

on server side this two strings goes normally
shell>./mysqladmin -u USERNAME -p -h localhost ver
shell>./mysqladmin -u USERNAME -p -h SERVERIP ver

on server side i can check that mysqld is running
shell>./mysqladmin -u USERNAME -p ping

result will be = mysqld is alive

re>>
Are you trying to connect to local or remote server?

A:>>
on my pc i can easly connect to my mysql trough any program like delphi components, MyODBC, AdoConnection without any problems, i have xp, believe me on my os mysql is normally running, on my pc is installed virtual apache veb server and all works i think normally

re>>What code are you using to try to connect?

A:>>for example my code

    -PHP--------------------------

    belevie this code is taken(copied) from my server, 
    passsword and user adre correct...

    <?
      $link = mysql_connect   
      ("159.148.144.19", "username", "userpass")
      or die("Could not connect: " . mysql_error());
      print ("Connected successfully");
      mysql_close($link);
    ?>


    RESULT OF THIS SCRIPT IS


    Warning: Can't connect to MySQL server 
    on '159.148.144.19' (10061) in v:\a_connect\connect.php3 
    on line 2
    Warning: MySQL Connection Failed: Can't connect to MySQL 
    server on '159.148.144.19' (10061) in 
    v:\a_connect\connect.php3 on line 2
    Could not connect: Can't connect to MySQL server 
    on '159.148.144.19' (10061)

    -PHP--------------------------

next i trying to make this

IN far manager console string>mysqladmin -u USERNAME -p -h 159.148.144.19 ver

and i get the error like: check if your mysqld is running on 159.148.144.19, and also second error (10061)

re>>
Have you downloaded MySQL-Front yet?

A:>>
i dont now what is it, but i will try to download this one, you think this must help me, ok i go to look up on your link

also thanks for your help,

please send to me your questions, i will answer, maybe this helps me ?, i think

thanks,..........

marconi8

to localhost as root i can easly connect, but when i type
159.148.144.19
user = mysql root or mysql.db.user with password i get an error

2003 - Can't connect to MySQL server on '159.148.144.19' (10061)

cgraz

I think yo'ure missing the port number (that may or may not solve your problem)

mysql_connect('159.148.144.19:3306', 'user', 'pass) or die(mysql_error());

I've done it like that before and had no problem. (I just briefly skimmed over the post; hopefully I didn't miss anything important. 😉 )

Cgraz

marconi8

port number typing also dont helps, uehhh

marconi8

i conect to internet trough our company server, on this server is installed firewall, and i think that on this firewall are disabled some needed to me ports

nnichols

I can't think of anything else obvious. Do you have access to the firewall admin and the logs. If so, you should be able to find the problem pretty quick.

Good luck!