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