MySQL Forums
Forum List  »  Install & Repo

First Time Install - Cannot Connect to mySQL.
Posted by: Seb Spiers
Date: December 15, 2006 05:03AM

Hi Guys,

I get the following error when trying to connect to mySQL from PHP.

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Inetpub\wwwroot\dbconnect.php on line 2

The code im using is as follows;

<?
$db = mysql_connect("localhost", "***user***", "***pass***");
?>

Ive setup mySQL from scratch using the installer for Windows and all of the default settings. I can login using the MySQL Command Line Client shortcut from the start menu on the Windows Server. I assume I just need to tell MySQL to accept TCP/IP connections but how do I do this?

Ive connected to my server using the Administration tool and have retreived the following information;

MySQL Server Information
--------------------------------------------------------------------------------
Connected to MySQL Server Instance
Username: root
Hostname: localhost
Port: 3306
--------------------------------------------------------------------------------
Server Information
MySQL Version: MySQL 5.0.27-community-nt via TCP/IP
Network Name: faithap.faithful.co.uk
IP: 127.0.0.1
--------------------------------------------------------------------------------
Client Information
Version: MySQL Client Version 5.1.11
Network Name: faithap
IP: 89.0.0.3
Operating System: Windows Server 2003/XP
Hardware: 2x Intel(R) Xeon(TM) CPU 3.20GHz, 1.0 GB RAM

When I install the Administration software on my client PC i get the following error when trying to connect;

Could not connect to the specific instance.
MySQL Error Number 1130
Host '89.0.0.112' is not allowed to connect to this MySQL server
If you want to check the network connction, please click the Ping button.

Pinging faithap
Reply from 89.0.0.3: Time=0ms TTL=128
Reply from 89.0.0.3: Time=0ms TTL=128
Reply from 89.0.0.3: Time=0ms TTL=128
Reply from 89.0.0.3: Time=0ms TTL=128
Reply from 89.0.0.3: Time=0ms TTL=128
Reply from 89.0.0.3: Time=0ms TTL=128
Reply from 89.0.0.3: Time=0ms TTL=128
Reply from 89.0.0.3: Time=0ms TTL=128

Thanks in advance and seasons greetings etc! :)



Edited 2 time(s). Last edit at 12/15/2006 08:49AM by Seb Spiers.

Options: ReplyQuote


Subject
Written By
Posted
First Time Install - Cannot Connect to mySQL.
December 15, 2006 05:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.