When I connect through odbc I get a succes with info, when I look at the
info I have a sql state of s1000, native error 0. If I try to query the
database I get an error and the sql state is s1000 with native error code of
1142. Everything I read on the internet says it's some kind of permissions
thing. I have tried the mysql commands
GRANT ALL PRIVILEGES ON fr6 TO "Devore"@"jdevore-02";
INSERT INTO user (Host, User, Password, Select_priv, Insert_priv,
Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv,
Index_priv, Alter_priv) VALUES ("jdevore-02", "Devore@jdevore-02", "", "Y",
"Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y");
GRANT ALL PRIVILEGES ON fr6 TO "%"@"%";
And when I used these it let me connect but I got all those errors. Before
I started adding people to the user table I couldn't even connect. Does
anyone know what I'm doing wrong or is the odbc driver not recommended?
Thanks,
jake
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
