Issues when connecting to database?

[smuggler]

I attempted to use the following programs to view/edit my sql database, and none of them were able to connect to my database...

EQEmu Admin
Magoo's Item Editor
SQL Front

It's driving me insane because each of those programs have successfully worked for me before, and I haven't done anything differently (to my knowledge) than in previous situations.

The only clue any of the programs gives me is a vague message about serverside permissions. Basically, SQL Front told me that it does not allow connections to servers that screen connections (my PC was the server in question, and was protected by Zone Labs firewall software). That in itself is rather fucked up, but even after I shut down ZA, it continued to give the message. That's just plain bonkers.

Anyone experience this problem before?

[Monrezz]

You need to run the GRANT statement.

[smuggler]

I have attempted to run the grant line many a time, but to no avail. Is there some setting that I must reset before I am able to successfully grant myself the privilages to use my database?


mysql> grant all privilages on *.* to 'some_user'@localhost identified by 'some_pass' with grant option;
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 near 'privilages on *.* to 'some_user'@localhost identified by 'some_pass' with grant option' at line 1


of course, for security purposes, I substituted 'some_user' and 'some_pass' for my username and password. this has been the same message i've gotten every time I've used the grant command. no dice.

any advice? i knew that SQL was picky, but obviously it in league with my system is lord king of picky. i can't seem to resolve this problem...

[Derision]

privilages

should be privileges

[Monrezz]

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

[smuggler]

Thank you Monrezz, you made my day. =D

That worked like a charm!

Ah, yeah I did misspell privileges, but only on the forum, that wasn't the reason for the syntax error. Thanks anyways, Derision.

[smuggler]

EQEmu Admin still fails to connect to the database?? What the hell is going on?

I'm going to try the same grant command as above but with sql.* as well, to see if that helps

[Derision]

If you try mysql-front,

Specify 127.0.0.1 in the Hostname/IP box:

In the user and password boxes, put the user and password you have in c:\windows\my.ini

In the database, put eq (or whatever you called your EQEmu database).

What exact error do you get ?

[smuggler]

Exception: Can not connect to SQL server

The admin tool wasn't able to connect to database "eq" at host 127.0.0.1.
Please go to the Preferences dialog and set the username, password, database, and host values.


I've also tried "localhost" and my internal IP address as the host value. This is all with using EQEmu Admin, but I've tried a few others as well and I get the same message.

I'm using ODBC driver version 3.51, I think I might swap down to an earlier version. I recall someone saying that 3.51 is a bit glitchy.

[Derision]

Well, I don't know what your problem is, but if you are using EQEmu Admin, or mysql front, or any other program written to use the MYSql API, you don't need to use ODBC at all.

ODBC is a database abstraction layer. Developers can write their apps to talk to ODBC and if you install the ODBC driver for Oracle, DB2, MS SQL Server, MYSql, or whatever, then that app can talk to that Database.

FQAdmin and mysql-front are native MYSQL applications and don't need ODBC.

[smuggler]

I just assumed that it was necessary for those programs, but I suppose it doesn't really matter either way. I'm just gonna try a complete wipe of all Emu/SQL related material and hopefully that will take care of the problem.