Telnet / DB help

Anon

I was given a page to be redone, specifically changing from CGI - which was on a old host DB - to a PHP version.

For the connection info to the new host (I cant use the stuff from the old scripts as it deals with the old host), I was originally given:

command line access: telnet.HOST.com
database name: *NAMEHERE

username and password is the same as given to me earlier

Plugging that info into the standard mysql_connect I got:

MySQL Connection Failed: Can't connect to MySQL server

SO I wrote the admin and received this reply:

The SQL server is running on sql.HOST.com. you can run the mysql program from telnet.HOST.com and have it connect to that sql.HOST.com server. You
cannot directly connect to sql.HOST .com from a windows machine. The other
thing that you can look at is the man page for mysql once you are connected to telnet.HOST.com.

so I subsituted sql.HOST.com into my connection string to give:

$connection = mysql_connect("sql.HOST.com" , "USERNAME" , "PASSWORD") or die ("Couldn't connect to server.");

This yields the following error:

Warning: MySQL Connection Failed: Access denied for user: USERNAME@*HOST.com (Using password: YES) Cannot connect to database

So right now I'm stuck as to what is wrong. Am I missing something (I've done DBs before and have always connected the same way) or is the host just not set up right? Or both?

Thanks!

Anon

use telnet

then run this command on the shell

mysql - u username - p password (enter)

then u should get the MYSQL prompt in the telnet if have a valid username and password in the database MYSQL

cheers
kalyan

Anon

OK thanks, I'll see what I can do with that. But the next part is, how do I then connect my PHP files (such as index.php) to the database, and then run queries, retreieve info , etc.

Normally I'd just use something like

$sql = "Select * from Users";
$sql_result = mysql_query($sql, $connection) or die ("Couldn't execute query in DB");

Thanks!

Anon

Evidently I managed to track down the problem ( I say track lightly ) to a bad password given to me. I had asked before, and had been assured that the old one was right, but it wasn't! Bleh!

Its all better now tho 🙂