Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
PHP Databases Using PHP in conjunction with databases. PHP questions not specific to databases should be directed to one of the other PHP forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 13th, 2005, 01:03 AM
Registered User
 
Join Date: Apr 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cant Connect


Code:
mysql_connect("localhost","user","pass") or  
die("Could not connect!!^_^" . mysql_error());
----------------------------------------------------------------------



the error msg i received is this.....
-----------------------------------------------------------------------------
Client does not support authentication protocol requested by server; consider upgrading MySQL client
-----------------------------------------------------------------------------

Thanks guys.

My configuration is

IIS
Win 2K
MySQL 4.1.7
PHP Version 4.3.11

 
Old April 13th, 2005, 09:22 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 101
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via AIM to Moharo
Default

try doing just this:

mysql_connect("localhost");

do not specify username and password....

www.campusgrind.com -college portal
 
Old April 16th, 2005, 03:25 PM
Registered User
 
Join Date: Apr 2005
Location: miami, fl, USA.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I did set up my password by using :
"set password for root@loacalhost=password('your_password');
log out "\q", and then log back with:
mysql -u root -p,
prompts for password! 'your_password'
and then I get the wellcome monitor screen.
then I make sure I place the same password in my PHP script, at hte
mysql_connect () function.
and I now get : Can't create database 'wiley'. Database exists.
My hole next week will be dvoted to this message NOW..




Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect to internet jameel SharePoint Admin 0 December 6th, 2007 03:04 AM
how to connect database madu Java GUI 1 December 3rd, 2007 11:54 PM
can't connect to localhost dmlocke Beginning PHP 1 October 16th, 2006 01:29 PM
connect to a URL Shasur Pro VB 6 1 November 25th, 2005 07:05 AM
Trying to connect to Mysql tp194 Classic ASP Databases 4 November 11th, 2004 12:12 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.