Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Anonymous on January 31, 2004, 11:15:53 AM

Title: XOOPS install on SME 6
Post by: Anonymous on January 31, 2004, 11:15:53 AM

Hi,

I've followed the steps from see at bottom to create mysql db and everytime it comes up with

"Could not connect to the database server."

I've looked at logs and can find nothing, please help me!

Cheers

Stevehttp://forums.contribs.org/index.php?topic=20268.0

Title: XOOPS install on SME 6
Post by: Rien on February 02, 2004, 02:18:40 PM

Are you sure you filled in the correct names:

user = xoops
databasename =xoops
etc.

I agree with Boris that the permissions are to excessive.

Rien

Title: Re: XOOPS install on SME 6
Post by: kaokao on February 02, 2004, 07:58:51 PM

1. Create a database ( ej: xoops2 ):

root# mysqladmin create xoops2 (intro)

2. Verify that you have created it:

>mysql ( intro )
then you will be in line commandos of mysql
mysql>
mysql> show databases; ( ";" is very important )

3. Create a user and permissions: ( ej: kaokao  :-) )
mysql> grant all on xoops2.* to kaokao identified by 'pw'; ( ";" is very important, pw is the password )