Help with connecting to MySQL!!!

sjames · Post by **sjames** » Thu Mar 03, 2005 11:41 am

I can't seem to get phpbb to connect with the database - the database has def been created, but I think it has something to do with the host 'local' host - I actually want the host for my MySQL database to be 'pcol-webtest' as this is where i have set phpbb up to.

How do I change the host, do I have to set the database data directory onto that host?

Through MySQL Administrator its telling me the following:

Connected to MySQL Server Instance

Username: phpbbadmin (set this in command line)
Hostname: localhost
Port: 3306

Server Info

MySQL version: MySQL 4.1.10-nt via TCP/IP
Network Name: pcol-webtest
IP: 212.219.110.235
OS: Windows 2k

Can anyone help?

This is the error message

Warning: mysql_connect(): Access denied for user 'simon'@'localhost' (using password: YES) in C:\Inetpub\wwwroot04\phpbb2\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot04\phpbb2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot04\phpbb2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

Thanks

Sim

sjames · Post by **sjames** » Thu Mar 03, 2005 12:23 pm

Sorry!! this is the error message phpbb is giving me - this is when database (phpbbforum) exists and user and password

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Inetpub\wwwroot04\phpbb2\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot04\phpbb2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot04\phpbb2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

jabroni · Post by **jabroni** » Thu Mar 03, 2005 7:27 pm

sjames wrote: Sorry!! this is the error message phpbb is giving me - this is when database (phpbbforum) exists and user and password

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Inetpub\wwwroot04\phpbb2\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot04\phpbb2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot04\phpbb2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

I got the same errors when first installing. The only way I could get it to install was by using the ms_acess_primer.mdb file (located in the /install/schmas dir). Point your DSN to that db and PHPBB should install fine.
Personally, I would rather have used a mysql database, so I'm going to play with this some more. For me, using the ms_acess_primer.mdb file was a quick fix so I could start playing with phpbb.
I know this probably doesnt really solve your problem, but I'm just letting you know what I had to do.

jabroni · Post by **jabroni** » Thu Mar 03, 2005 8:01 pm

sjames,
Ok, I fixed the problem (for myself, anyway) to get around those error messages. I used MySQL Administrator and set up a user account called "ODBC" and no password. Give it full permissions.
In your install page, point to the database you want, and leave the username and password fields empty.
It will then let you install with no errors.
Hope this helps you.

espicom · Post by **espicom** » Thu Mar 03, 2005 9:51 pm

See the third link in my signature. MySQL 4.1 and later have, by default, an incompatible password scheme vs. PHP through 5.0, which requires you to set the passwords using the "old_password" function.

Jynks · Post by **Jynks** » Fri Mar 04, 2005 4:45 am

Thanks for this thread solved my probs... cheers

sjames · Post by **sjames** » Fri Mar 04, 2005 9:57 am

THanks, but i am not sure if i want to do that all the time, do you know of anywhere where I can get a version of MySQL that will run fine with my php?

Sim

Jizumonkey · Post by **Jizumonkey** » Fri Mar 04, 2005 11:56 am

Any chance someone can put this in laymans terms? That third page in your sig espicom requires mostly that you are on the machine that mysql is located on, for me that isn't the case, it's a hosted site and as such I do not have acces to c:/program files/blah!!!!

How do I run it from my home pc? I've tried putting the host in as my domain, the user is correct and the password is correct but it still fails to connect so I cant even get past the first hurdle.

Thanks

Jizumonkey · Post by **Jizumonkey** » Fri Mar 04, 2005 12:31 pm

OK I found the answer for me personally....with an error message like the below (not relating to permission one which is very similar):

Code: Select all

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/carlos/public_html/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/carlos/public_html/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/carlos/public_html/db/mysql4.php on line 331
phpBB : Critical Error 

Could not connect to the database

I entered phpmyadmin, selected my database, clicked the SQL tab and in the command box ran the following line obviously I've changed my password and username but you'd put your own...

Code: Select all

SET PASSWORD FOR username@localhost = OLD_PASSWORD('something');

advertisements