XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / Cannot Connect to DB
Register
1
snyperx
Cannot Connect to DB

  • 2004/12/30 0:15

  • snyperx

  • Just popping in

  • Posts: 4

  • Since: 2004/12/30


This is my current setup:

Apache 2.0.52
PHP 4.3.10
MySQL 4.1.8 Essentials
MySQL Administrator 1.0.18
Xoops 2.0.9.1
Windows XP Pro SP2

I have already verfied that the webserver and PHP are working correctly. I created a database called XOOPS and created a user called XOOPS with password of xoops. When I try to connect to the DB during the setup wizard I get the famous "Could not connect to database server." error message. I searched through these forums, but really could not find a concrete answer as to what the resolution is. I found a few posts that sort of address it, but not in a very clear manner. Any help woud be appreciated. I am hoping to use XOOPS for a corporate intranet site. Any help is greatly appreciated. TIA
2
m0nty
Re: Cannot Connect to DB

  • 2004/12/30 0:20

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


try using an IP address or computer name of the MySQL server as the host..

is MySQL compiled right? use a phpinfo() script on your server and call it from a browser to see if MySQL is listed.. just a thought
3
snyperx
Re: Cannot Connect to DB

  • 2004/12/30 0:32

  • snyperx

  • Just popping in

  • Posts: 4

  • Since: 2004/12/30


Ran a PHP info script and it seemed to detect MySQL fine. Responses from the script seemed normal.
4
Mithrandir
Re: Cannot Connect to DB

Can you connect to the database manually with the same credentials using a tool like phpMyAdmin or MySQL Maestro?
5
snyperx
Re: Cannot Connect to DB

  • 2004/12/30 0:41

  • snyperx

  • Just popping in

  • Posts: 4

  • Since: 2004/12/30


I am currently using MySQL Administrator 1.0.18 and connect fine. I am assuming that is basically the same as Maestro (GUI admin program for MySQL).
6
snyperx
Re: Cannot Connect to DB

  • 2004/12/30 0:57

  • snyperx

  • Just popping in

  • Posts: 4

  • Since: 2004/12/30


Ok I tried phpMyAdmin and I am getting the following error:

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


MySQL client? What exactly is that? I am using the latest verison of MySQL 4 (4.1.18).
7
m0nty
Re: Cannot Connect to DB

  • 2004/12/30 1:16

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


change the setting in the config.inc.php file in the phpmyadmin folder

set authentication method to cookie and try again..

i had this problem before, and couldn't quite solve it either.. so i switched to using Xampp 1.4.10 all in one server and have had no probs since..

are you running apache, & sql as a windows service or standalone program?
8
iktom
Re: Cannot Connect to DB

  • 2005/1/20 16:49

  • iktom

  • Just popping in

  • Posts: 1

  • Since: 2005/1/20


This helped me to solve my connection problem, I had something similar to you.

http://dev.mysql.com/doc/mysql/en/Old_client.html

Regards
Rick / http://www.TS2K.com

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

295 user(s) are online (246 user(s) are browsing Support Forums)

Members: 0

Guests: 295

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits