xoops forums

TitaNs

Just popping in
Posted on: 2003/4/16 21:11
TitaNs
TitaNs (Show more)
Just popping in
Posts: 7
Since: 2003/4/11
#1

Database problem

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?

mbogosian

Just popping in
Posted on: 2003/4/16 22:25
mbogosian
mbogosian (Show more)
Just popping in
Posts: 53
Since: 2002/9/30
#2

Re: Database problem

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!

TitaNs

Just popping in
Posted on: 2003/4/18 13:30
TitaNs
TitaNs (Show more)
Just popping in
Posts: 7
Since: 2003/4/11
#3

Re: Database problem

thank you my friend I am triyng these things..

TitaNs

Just popping in
Posted on: 2003/4/21 18:20
TitaNs
TitaNs (Show more)
Just popping in
Posts: 7
Since: 2003/4/11
#4

Re: Database problem

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..

ndial

Just popping in
Posted on: 2003/4/21 18:53
ndial
ndial (Show more)
Just popping in
Posts: 29
Since: 2003/3/3 1
#5

Re: Database problem

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.

bjmartin

Just popping in
Posted on: 2003/4/21 20:08
bjmartin
bjmartin (Show more)
Just popping in
Posts: 1
Since: 2003/4/21
#6

Re: Database problem

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.

jlm69

Module Developer
Posted on: 2003/4/21 20:57
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#7

Re: Database problem

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.

ndial

Just popping in
Posted on: 2003/4/21 20:58
ndial
ndial (Show more)
Just popping in
Posts: 29
Since: 2003/3/3 1
#8

Re: Database problem

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).

TitaNs

Just popping in
Posted on: 2003/4/23 20:54
TitaNs
TitaNs (Show more)
Just popping in
Posts: 7
Since: 2003/4/11
#9

Re: Database problem

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..

TitaNs

Just popping in
Posted on: 2003/4/26 18:18
TitaNs
TitaNs (Show more)
Just popping in
Posts: 7
Since: 2003/4/11
#10

Re: Database problem

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?..