BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.2 support => Topic started by: yardleyto on June 20, 2006, 04:45:47 am

Title: i need MySql help with 0.2.5
Post by: yardleyto on June 20, 2006, 04:45:47 am

i recieve Acess denied for user 'ODBC' @' localhost' (using password: NO) in C:\php\BeBot_v0.2.5\MySQL.php on line 63
MySQL error (# 0) in query: Cannot connect to the database server!
Access denied for user 'ODBC'@'localhost' (using password: NO)

i followed all of the steps in the noob guide. what am i doing wrong???? i apperciate the help.

i also canot find the items.sql file anywhere

Title: Re: i need MySql help with 0.2.5
Post by: lonillen on June 20, 2006, 08:39:40 am

You did set (correct) username/password as well as server/database name in bebot/conf/MySQL.conf right?

You dont need the items.sql file as you're using bebot ver 0.2.5

Title: Re: i need MySql help with 0.2.5
Post by: Malosar on June 20, 2006, 04:16:49 pm

As mentioned you should have a username and password specified in the bot.conf, which should match the username/password you allocated to access the mysql database.

Title: Re: i need MySql help with 0.2.5
Post by: yardleyto on June 21, 2006, 12:45:15 am

both are identical i checked and re-checked

Title: Re: i need MySql help with 0.2.5
Post by: yardleyto on June 21, 2006, 03:04:28 pm

used localhost as server is that correct?

Title: Re: i need MySql help with 0.2.5
Post by: Khalem on June 22, 2006, 01:16:02 am

Quote from: yardleyto on June 20, 2006, 04:45:47 am

i recieve Acess denied for user 'ODBC' @' localhost' (using password: NO) in C:\php\BeBot_v0.2.5\MySQL.php on line 63
MySQL error (# 0) in query: Cannot connect to the database server!
Access denied for user 'ODBC'@'localhost' (using password: NO)

This looks dangerously like missing MySQL.conf entries.
ODBC sounds like a default fallback user, and the main clue is that its not being provided with a password.

Title: Re: i need MySql help with 0.2.5
Post by: Mephistobane on June 22, 2006, 03:20:19 am

i had a prob with that a while back,i logged into the root and that fixed it.i looked at the permissions my non-root user had,and he had none. so i went and gave the non-root user all the access and stuff,and it fixed things right up.