1
TitaNs
Database problem
  • 2003/4/16 21:11

  • TitaNs

  • Just popping in

  • Posts: 7

  • Since: 2003/4/11


I have a prob. with database
there is a error message like this:

Could not connect to the database server.


Please check the database server and its configuration.


I have a php my admin control panel but I dunno how to create db.
what must I do?

2
mbogosian
Re: Database problem
  • 2003/4/16 22:25

  • mbogosian

  • Just popping in

  • Posts: 53

  • Since: 2002/9/30


You'll definitely want to take some time to read the MySQL documentation either that came with your installation or here. This might help as well.

Basically, you've got to do the following:

1. Install MySQL
2. Create a database user that XOOPS will use
3. Give access to log in to the database user
4. Create a database instance that XOOPS will use
5. Give access to the database instance to the database user

I think that just about covers everything, but I'm not sure. Good luck!

3
TitaNs
Re: Database problem
  • 2003/4/18 13:30

  • TitaNs

  • Just popping in

  • Posts: 7

  • Since: 2003/4/11


thank you my friend I am triyng these things..

4
TitaNs
Re: Database problem
  • 2003/4/21 18:20

  • TitaNs

  • Just popping in

  • Posts: 7

  • Since: 2003/4/11


which version of MySQL must i download?

MySQL database server & standard clients:
MySQL 4.0 -- Production release (recommended)
MySQL 4.1 -- Alpha release (use this for new development)
MySQL 5.0 -- Development tree (use this for previewing and testing new features)
MySQL 3.23 -- Older production release
Older releases -- older releases (only recommended for special needs)


I have already downloaded MySQL 4.0 but it is broken file..

5
ndial
Re: Database problem
  • 2003/4/21 18:53

  • ndial

  • Just popping in

  • Posts: 29

  • Since: 2003/3/3 1


Wait a minute -- you said you had a phpMyAdmin control panel. Do you mean you've got a hosting setup that provides a phpMyAdmin control panel, or just that you've downloaded the files? If you've got a phpMyAdmin control panel from your hosting company, then you've got a database from them, too. You just need to make sure you're using the right username and password, and pointing to the right place.

Or if your host has some special procedure for creating a database, you may have to fill out a form or something. Or, if you're managing your server yourself and you don't have a database server at all, you still have to install MySQL I'd go with the latest production release, though XOOPS will run just fine with 3.23.

6
bjmartin
Re: Database problem
  • 2003/4/21 20:08

  • bjmartin

  • Just popping in

  • Posts: 1

  • Since: 2003/4/21


I am relieved to see someone else having the same problem lol, ie; database creation.

I've read the answers, but it still sounds greek to me??
My host provides MySQL (but not the phpmyadmin).

I get the same error message about the inability to locate the database, and am absolutely stumped on creating one.

Any "Detailed" 4th grade tutorial would be very appreciated lol.


7
jlm69
Re: Database problem
  • 2003/4/21 20:57

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


You most likely have to have your hosting company create the database and they will give you info like :

database host
database username
database password
database name

Then you just fill in the blanks when you start XOOPS setup.

8
ndial
Re: Database problem
  • 2003/4/21 20:58

  • ndial

  • Just popping in

  • Posts: 29

  • Since: 2003/3/3 1


The problem with making a detailed non-technical tutorial is, it probably is different for different web hosts. (Unless you have your own co-located server, and if you're paying that much rent you really ought to know what you're doing or hire somebody who does )

If you get a "can't connect to database server" error and you're using settings that your hosting company told you to use to connect, you should probably contact them because it's probably a server problem.

If you get "unable to create table" it just means you don't have the permissions to create a database, and you'll have to either submit a request to your host to get an admin (or admin script) with more rights than you to make one, or you'll just have to add the tables to a database that you already have (which isn't so bad because XOOPS namespaces everything anyway).

9
TitaNs
Re: Database problem
  • 2003/4/23 20:54

  • TitaNs

  • Just popping in

  • Posts: 7

  • Since: 2003/4/11


I have a phpmyadmin control panel in my server(on the internet)
and I still get an error messagge "can not connect to database server"

if I have an username and password for database I dunno what are these and I can not see any database in my PMA control panel(I can log in my PMA control panel)


but in XOOPS I write my username and pass but it still error..

10
TitaNs
Re: Database problem
  • 2003/4/26 18:18

  • TitaNs

  • Just popping in

  • Posts: 7

  • Since: 2003/4/11


2. Create a database user that XOOPS will use
3. Give access to log in to the database user
4. Create a database instance that XOOPS will use


I dunno how to set database what XOOPS want?
can someone tell me the settings of xoop database?..

Login

Who's Online

244 user(s) are online (140 user(s) are browsing Support Forums)


Members: 0


Guests: 244


more...

Donat-O-Meter

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

Latest GitHub Commits