1
huwboy
New to XOOPS
  • 2005/3/29 12:08

  • huwboy

  • Just popping in

  • Posts: 7

  • Since: 2005/3/29


Hi I'm new to Xoops.
I'm just trying to install it locally on my laptop.

I have a copy of SQL Server but not MySQL.

Is this a problem ?
If so where can I get MySQL from ?
How much is it going to cost me to buy MySQL ?

2
Mithrandir
Re: New to XOOPS

MySQL is available for free download on mysql.com

XOOPS does not run with a MS SQL server

3
huwboy
Re: New to XOOPS
  • 2005/3/29 16:45

  • huwboy

  • Just popping in

  • Posts: 7

  • Since: 2005/3/29


Thanks, getting somewhere now,
Can you recommend a good gui front end for MySQL ?

4
ddevore
Re: New to XOOPS
  • 2005/3/29 18:33

  • ddevore

  • Just popping in

  • Posts: 47

  • Since: 2005/3/8 1


The best interface for it is phpMyAdmin available at:
http://www.phpmyadmin.net/home_page/index.php

It runs through the browser and uses php, hence the name.

5
huwboy
Re: New to XOOPS
  • 2005/3/30 17:07

  • huwboy

  • Just popping in

  • Posts: 7

  • Since: 2005/3/29


Thanks for you help,
I'm running through the XOOPS installation wizard and I'm getting stuck on the last screen

Checking the Database screen
I get the message Could not connect to the database server

I have MySQL installed and the service is running
I have entered the following database information

Database Hostname: localhost
Database Username: root
Datapase Password: rootpass

Do you have any ideas of possable things I could try

6
mactoeknee
Re: New to XOOPS
  • 2005/3/30 18:05

  • mactoeknee

  • Just popping in

  • Posts: 75

  • Since: 2005/2/26


I just went through that-- I think you're better off preserving your root login just in case XOOPS is compromised.

You created a new MySQL database, and you then have to create a user AND give that user permission to access the database (I suppose root would work, but you still would have to give user "root" permissions for that database. See why 'root' is too confusing-- just create a new user for it).

I did that via Cpanel, not PHPMyAdmin. So how you do it may vary, but that last step is what I have forgotten on the two installations I did-- assigning the user to the database. Once I did that, install script was able to find it without problem.

Mac T

7
huwboy
Re: New to XOOPS
  • 2005/3/31 10:58

  • huwboy

  • Just popping in

  • Posts: 7

  • Since: 2005/3/29


Firstly, Thanks for your help with this
Otherwise I would be feeling very alone !!

OK - I have a MySQL database called class
I have added a new user calles Huw
and also added a host from which the user can connect called Huw@localhost
I have assigned all of the Schema privileges for the class database to Huw@localhost and to Huw
So all of the options like SELECT, INSERT etc are in the column on the left hand side of the User Administration screen in MySQL Administrator

Yet I still get stuck at the last screen on the XOOPS install wizard

Checking the Database screen
I get the message Could not connect to the database server

Is my user account still not assigned to the database class somehow ?? Can somebody tell me how to make sure my user account has access to my database. ?

I'm using MySQL Administrator as my front end.

8
huwboy
Re: New to XOOPS
  • 2005/4/1 10:46

  • huwboy

  • Just popping in

  • Posts: 7

  • Since: 2005/3/29


I really need some help with this guys,
I can't get passed the last screen of the XOOPS install wizard.

I've been all over the net to check that I have my database set up correctly, and my user account has the correct schema priveliges.

I'm sure my WAMP environment is fine as I can run other web applications just fine.

I need some help from some experienced Xoopers.

9
davidtillyer
Re: New to XOOPS

Hi I have just had a look at this MySQL admin front page, looks good.

Have you used it? As I have a question:

I have a database that I want to move into MySQL db. I'm using xoops2.

My question is if I upload the data I have using this SW to my current MySQL DB will ALL the fileds match up with what I currently have on xoops2 interface.

DT

10
huwboy
Re: New to XOOPS
  • 2005/4/1 11:47

  • huwboy

  • Just popping in

  • Posts: 7

  • Since: 2005/3/29


David,
I don't think I'm able to help you,
I am using MySQL Administrator as my front end to my database, but as you can see from my previous posts I still can't install xoops.

Can you help with that ?

Huw.

Login

Who's Online

215 user(s) are online (186 user(s) are browsing Support Forums)


Members: 0


Guests: 215


more...

Donat-O-Meter

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

Latest GitHub Commits