Author Topic: create command denied to user (Read 2451 times)

blofeld · « **on:** August 04, 2006, 01:41:45 am »

Ok,

Got the bot working by following the instructions in various posts.

All commands work except when starting it says:

CREATE command denied to user 'blofeld'@'localhost' for table ...

and goes down the list. Basically won't make any tables therefore it wont update members. recognizes who is online in the bot command window but lists them as non members and lists 0 when doing the !online command

like i said, commands such as !oe and !whois and such work fine but tells get a response of "i only listen to members of this bot"

Thanks, like the bots functionality so far.

Khalem · « **Reply #1 on:** August 04, 2006, 01:53:38 am »

This is an MySQL permission issue rather than a bot issue.

You need to make sure that your MySQL user blofeld is allowed to CREATE, ALTER and DELETE tables amongst other things. Either that or you need to manually create the tables for the bot using the root user or another user with the apropriate permissions.

blofeld · « **Reply #2 on:** August 04, 2006, 02:45:12 am »

ok figured something like that but how do i fix

noob in all things programming

i did the command in mysql bebot to:

GRANT ALL on databasename.* TO username@localhost;

dont know what else to do

Thanks

blofeld · « **Reply #3 on:** August 04, 2006, 02:46:33 am »

btw did substitute the right names for the generic ones in example above

blofeld · « **Reply #4 on:** August 04, 2006, 03:15:28 am »

okay think i got this licked now

grant for some reason wont work when i do bebot.* but if i just am within the bebot sql database and use * by itself that worked ok

thanks for the feedback and thanks for the cool bot and the great faqs

just making a little org for some young sons, nieces and nephews thats G rated this will make things so much easier and more fun

thanks again

Pharexys · « **Reply #5 on:** August 04, 2006, 11:06:39 am »

Well Enter the Mysql promt again,
enter ur db(with use bebot; )
then type the following line:

GRANT ALL PRIVILEGES ON bebot.* TO 'bebot'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

replace password, with w/e pass you want, be sure you put it on Mysql.conf same too