Meeting Room Booking System - MRBS

[pmassingham]

This is a request for help from any PHP/Mysql novice who has managed to set up MRBS. I have installed WAMP (latest) and followed the MRBS set up documentation but I cannot connect to the database - 'fatal error - cannot connect to database'. I am using login=root and password=' ' as I cannot find any passwords in the mysql documentation. If I leave the config.inc.php unchanged, the error is even longer and refers to a mysql function error. Also, if I run the tables.my.sql query in sqladminlite to create the tables, that fails with errors and does not create the tables. I was hoping for an easy install but my hopes were dashed! Thanks.

[tsky]

You're getting the error because it can't log on to the database engine - probably because there are no users in the system for it.

Best thing to do is get yourself a copy of PHPMyAdmin - this is a web-based control engine for MySQL.
From there you can generate usernames and passwords and set privileges to your databases, rather than having to worry about the command-line stuff.
the other thng you can do is to get the GUI toolkit if you're on Windows if you prefer to use that over a web-based toolkit.

Ideally you want to set a password for your root account - it's not a good idea to run without one.
you'll want to set usernames and passwords for your individual databases. I've not looked at MRBS before, but I should imagine there would be a setup script page you could configure from - anyone else out there with more info on it that can help pmassingham?

[tsky]

Just had a quick look for you... seems you need to pre-populate MySQL with a database and user before it runs:


From the MRBS documentation:
( MRBS: Documentation : INSTALL )

--------------------
For a new install:

creating the DB
===============
You can place the MRBS database tables in an existing database or
create a new database with the following:

mysqladmin create mrbs
mysql mrbs < tables.my.sql


Application Setup
=================
First, select your database system. Define one of the following:

$dbsys = "mysql";

Then define your database connection parameters. Set the values for:

$db_host = The hostname that the database server is running on.
$db_database = The name of the database containing the MRBS tables.
$db_login = The database login username
$db_password = The database login password for the above login username

---------------------



Links
=====
PHPMyAdmin
phpMyAdmin - Download

MySQL GUI Toolkit
MySQL :: MySQL GUI Tools Downloads

[pmassingham]

Thanks for the replies. I have tried to comprehend the documentation but have to admit that I do not have the required skills in PHP nor Mysql. I will try another scratch install to see if I can make progress. The dblogin and password are where I could not find guidance. I will try PhpMydmin to change the authentication.

[HodgeHi]

I used the MySQL GUI tools to do mine. I found it be be a lot easier using the tools. Possibly because i am totally naff at scripting