Problem with MySQL database

Hi,

Could someone please tell me what am I doing wrong. I made a free account to 100webspace.com but I just can't get MySQL to work. I'm trying to run the site locally.

This is what I have in setup_options.php ->
$DB='mysql';
$DBhost='mysql1.100ws.com';
$DBname='mydatabasename;
$DBusr='myusername';
$DBpwd='mypassword';

...and
$main_url='http://localhost/forum';


No matter what I do, I just keep getting "Database/configuration error". I have tried setting up MySQL database on 2 different servers and created tables using _install_mysql.sql. It seems that I just somehow can't connect to the server.

Board works fine if I run MySQL on my own computer ($DBhost='localhost';).

Oh I get it now. Site must be on the same domain as the database.

Peak
Site must be on the same domain as the database
- hmm, that isn't true... mysql database and the website could be on different servers, but you definitely must define the settings correctly...

It is possible that if you try to connect to mysql from localhost, while mysql is placed on different server (100webspace.com), it will be not allowed. But not because miniBB could not work with this, but because on the mysql server, it will be disallowed to connect from outside, as by regular security settings...

My forum is so slow.. I asked the server hosting..

they told me.. Your site just looks very MySQL intensive. If you can adjust your forum
software to enable any form of caching on your server, that may be the
best way to speed things up. As Im not sure what forum software you are
using, I cant really link you to any resources on it though.

so I didn't get.. is the problem from Mysql database?

anyone has idea?
thanks

If it's shared hosting, and you have a lot of traffic, you may surely experience kind of such reply from hoster.

Then you would need a VPS or even dedicated hosting, if your forums have many users - specially "in a second" visitors.

Actually, any hoster will tell you the bad is software, not their server's configuration. I've experienced this many times in my life.

What could I recommend? Improve the hosting plan or change the hoster. miniBB uses very native requests to mySQL, they are simplified as possible. But if there are too many requests, mySQL could start to handle up, but miniBB is not the reason here.

My advice is to change the host (or first remove any 3rd party heavy software that slows down the system ;).

Actually we have a battle with our hoster recently, that's why we have swapped the servers. When they have 600+ websites on the same server, and if a small miniBB makes 30 Gb of traffic each month, it's not the question of miniBB. Logically, you should either have smaller websites placed, or have your own server :-) but this of course is much expensive...

Thanks..

I also moved to the PS now.. and it's fast and ok now.. ;)