connect to remote server

[janet24]

I see there are a few questions like this already but I didn't understand them.

I am very new at this. I installed MySQL and PHP on my Hard drive. I can connect to MySQL through localhost on my hard drive. We have a server at work at a remote location. He just installed MySQL and gave me a password on root. As far as I know there are no databases created. I need to connect to the remote server and create a new user and database.

I've downloaded Secure CRT but don't understand how to use it. I entered my ip addresss in a new session and it seems to connect but then it says session fails.

I put a test script up and just get an error message. Should this script at least not give me an error message. Should I contact the person in charge of the server?

<?

/**
* Connect to the mysql database.
*/
$conn = mysql_connect("localhost", "root", "password") or die(mysql_error());

?>

Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

[Kozusnik]

The server is probably configured to only allow root access from localhost see mysql.user table. The host either needs to be your IP (client) or % for all.

Mark