Author Topic: SQL system control panel: does it exist? (Read 1855 times)

Stark · « **on:** April 27, 2006, 09:07:57 pm »

Hi everyone. I'm trying to get Bebot running and failing miserably. I had no trouble with most steps of the guides on here except there is mention of using the system control panel to create a new user and set admin rights. I downloaded system administrater and can't get past the opening screen to create a new user. It won't accept my main SQL account name and password.

So presently a Bebot account has been created which I had to do manually at the client but when I run Start SQL won't recognise it. Anyone get any ideas? Thanks in advance for any help.

Dice · « **Reply #1 on:** April 27, 2006, 11:21:43 pm »

I'm not 100% sure what the problem is. Can you post the errormessages you get when you try running BeBot?

My guess is that you havn't set the right privileges for the BeBot MySQL database yet. When you have the Mysql.conf file looking like shown in this guide, ie: like this:

Code: [Select]

<?
    $dbase = "bebot";
    $user = "Bebot";
    $pass = "banana";
    $server = "localhost";
?>

you can set the priviligas manually within the MySQL client by using the following query:

Code: [Select]

GRANT ALL PRIVILEGES ON bebot.* TO 'Bebot'@'localhost'
  IDENTIFIED BY 'banana';

For this to work you must have already created a database called bebot first with:

Code: [Select]

CREATE DATABASE bebot;
Maybe this helps.

If it doesn't, please supply the errormessage you get when running BeBot.

Stark · « **Reply #2 on:** April 27, 2006, 11:41:19 pm »

Thanks Dice but I managed to solve the problem by rummaging through the SQL reference manaul for hours, though your reply would have solved the problem straight off had I seen it earlier. Thanks anyway