MYODBC is not allowed to connect MYSQL??

chieh

I used myodbc to connect MYSQL wasn't allowed,
WHY?
error code is 1130, but i can't find the way to solve the problem?
Help!! Help!!

xgyxgy

check which user you use in your myodbc setting，and check the privileges of the user whether he has the right to connect to the database

chieh

I used root to login but still can't!
Mysql based on FreeBSD(MySql Version is 4.0)
Is MySql Problem?
Help!

xgyxgy

There is no problem with mysql.
for one thing,do not use root,that is dangerous,like unix,do you always use root?you should add a new user in mysql.use the command like:
grant select,insert,update,delete,create on *.* to username@'%' identified by 'your_passwd';
then you can use this user to connect to your mysql server.
for another thing,default privileges set root can only be connect in localhost or the host of your server,so that you cann't connect in your windows use myodbc to your freebsd.

chieh

Thanks your comments!
It's a key point!!!! I wl create new user to test!!
Thanks a lot!!!!

chieh

Hi XGYXGY,
I create new user and grant all privileges. but I still can't login via Myodbc, my host value is %, all be conneted from anywhere. and I create the same user but host value is localhost, I can login it from localhost.
pls help me!!!

xgyxgy

i just go to mysql.com to download a mysql4.0.20 for freebsd,and myodbc3.51.9,and setup mysql in freebsd 4.9 and setup myodbc3.51.9.when i finish install mysql in freebsd,i just login,and use this command:
mysql>;grant all privileges on *.* to xgy@'%' identified by '9527' with grant option;
mysql>;flush privileges;
then i use the user xgy in my odbc setting,the test is ok,there is not any problem that i encounter,all things seem to be right.
i don't know what is your problem,does your myodbc too old?older than 3.51?or is there any problem with the network?can you try:telnet your_freebsd_host 3306 and see whether you can connect it?i sugguest you setup mysql client in your windows, and try to connect.when you can connect to mysql server in freebsd in command line,then you can connect it in myodbc

chieh

Hi XGY,

I try to reinstall mySQL and grand a new user and reinstall MyODBC,
It work!!! Thanks God!
Thanks XGY!

xgyxgy

ha ha,sometimes there are some so many unexpected thing in *nix world,we must try all the possible ways to solve it.