|
clashbot
|
 |
« Reply #30 on: June 17, 2008, 02:26:42 PM » |
|
ok, somewhere that user got a little hosed, but you might be able to salvage it, if you configure you mysql.conf to match that....not sure if it will work, but wouldn't be the first time I've taken a sledghammer to a ten-penny nail..
|
|
|
|
|
Logged
|
|
|
|
darcek
Rookie
 Offline
Gender: 
Posts: 29
Dedicated User
|
|
« Reply #31 on: June 17, 2008, 02:32:04 PM » |
|
Seems like this can go on for days doh... after changing user to darcek insted of darcek@localhost i get the following error : Client does not support authentication protocol requested by the server ;consider upgrading MySQL client  |
|
|
|
|
Logged
|
|
|
|
|
clashbot
|
|
« Reply #32 on: June 17, 2008, 02:35:51 PM » |
|
lol..ok, well now you are heading into the realms of areas I am not good at...
|
|
|
|
|
Logged
|
|
|
|
darcek
Rookie
Offline
Gender:
Posts: 29
Dedicated User
|
|
« Reply #33 on: June 17, 2008, 02:38:46 PM » |
|
i dont want realms i just want to activate this bot doh  |
|
|
|
|
Logged
|
|
|
|
|
clashbot
|
|
« Reply #34 on: June 17, 2008, 02:41:37 PM » |
|
lol..hopefully one of the other guys here can lead you a little better from here...sorry I couldn't help more..but I am not familiar with that problem...
|
|
|
|
|
Logged
|
|
|
|
darcek
Rookie
Offline
Gender:
Posts: 29
Dedicated User
|
|
« Reply #35 on: June 17, 2008, 02:45:10 PM » |
|
also getting MySQL error (#0) on query:Cannot connect to the database server!
other stuff that might went wrong:
this line: Type GRANT ALL on databasename.* TO username@localhost;
i typed: GRANT ALL on ao.* TO darcek@localhost;
does that seem ok?
|
|
|
|
|
Logged
|
|
|
|
darcek
Rookie
Offline
Gender:
Posts: 29
Dedicated User
|
|
« Reply #36 on: June 17, 2008, 02:46:45 PM » |
|
well time to give up i guss...if anyone else have any insights ide appricate it..and thx clashbot for trying to help me...good night
|
|
|
|
|
Logged
|
|
|
|
|
clashbot
|
|
« Reply #37 on: June 17, 2008, 02:48:32 PM » |
|
yeah the grants look ok
|
|
|
|
|
Logged
|
|
|
|
|
clashbot
|
|
« Reply #38 on: June 17, 2008, 02:49:15 PM » |
|
as long as AO is the database name... and darcek is the user name...
|
|
|
|
|
Logged
|
|
|
|
|
Temar
|
|
« Reply #39 on: June 17, 2008, 04:41:14 PM » |
|
wat os?
|
|
|
|
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
|
Temar
|
|
« Reply #40 on: June 17, 2008, 04:43:59 PM » |
|
if windows
try putting the files inside php_extensions at c:/php5/
not the folder just the files inside
|
|
|
|
|
Logged
|
MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
|
|
|
darcek
Rookie
Offline
Gender:
Posts: 29
Dedicated User
|
|
« Reply #41 on: June 17, 2008, 10:35:05 PM » |
|
thx for the help but now my problem is not the PHP anymore but mysql...
only thing i can think of is mayby the sql version is too new..so will look for an older version.
the os btw is WIN XP SP3
|
|
|
|
|
Logged
|
|
|
|
darcek
Rookie
Offline
Gender:
Posts: 29
Dedicated User
|
|
« Reply #42 on: June 17, 2008, 11:19:36 PM » |
|
Amazing..the more i try the more problems show up....  Ive found an earlier version of MySQL v.4.1.9..earlier one i could find atm...started a fresh installation...when writing the line : CREATE USER darcek@localhost ; ive got an error telling me :ERROR 1064 (42000):you have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use. any ideas? |
|
|
|
|
Logged
|
|
|
|
|
Khalem
|
|
« Reply #43 on: June 19, 2008, 04:51:51 AM » |
|
Seems like this can go on for days doh... after changing user to darcek insted of darcek@localhost i get the following error : Client does not support authentication protocol requested by the server ;consider upgrading MySQL client This error is caused by the MySQL client (in this case, your PHP MySQL library) not supporting the newer authentication protocol of the MySQL server. http://dev.mysql.com/doc/refman/5.0/en/old-client.htmlIf you are going to downgrade the server, downgrade to 4.1.22, not older. If you are using the PHP files from BeBot's distribution, using MySQL 5.x should not be an issue at all. |
|
|
|
|
Logged
|
BeBot Founder and Fixer Kingpin
Madman coder and destroyer of good code
|
|
|
darcek
Rookie
Offline
Gender:
Posts: 29
Dedicated User
|
|
« Reply #44 on: June 19, 2008, 07:56:17 AM » |
|
Thx for the reply Khal... ok...so ill go back using te newest SQL... so i actually should use user only without the @local host? ill check the thread you posted indept when i reach home..im not giving up yet..and mayby with your help ill be able to pull this out...thx again  Will post again with update after i make all the changes.. |
|
|
|
|
Logged
|
|
|
|
|
Content
Total Members: 1246
