Hi, Changying Li wrote: > I want to use hdbc to connect my mysql test db. so I set up my > /etc/odbcinst.ini : > [MySQL] > Description = ODBC Driver for MySQL > Driver = /usr/lib/libmyodbc.so > Setup = /usr/lib/libodbcmyS.so > FileUsage = 1 > > and /etc/odbc.ini: > [test] > Description = MySQL database test > Driver = MySQL > Server = localhost > Database = test > Port = 3306 > User = root > Socket = /tmp/mysql.sock > Option = > Stmt = > > user [EMAIL PROTECTED] must use password to connect mysql. other users > needn't. > I connect db like this: > Prelude Database.HDBC.ODBC Database.HDBC> handleSqlError (connectODBC > "DSN=test") > *** Exception: user error (SQL error: SqlError {seState = "[\"HY000\"]", > seNativeError = -1, seErrorMsg = "connectODBC/sqlDriverConnect: [\"1045: > [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user > 'chylli'@'localhost' (using password: NO)\"]"}) > Prelude Database.HDBC.ODBC Database.HDBC> handleSqlError (connectODBC > "DSN=test;UID=chylli") > Prelude Database.HDBC.ODBC Database.HDBC> > > in another term: > mysql> show processlist; > +----+-------------+-----------+------+---------+------+-------+------------------+ > | Id | User | Host | db | Command | Time | State | Info > | > +----+-------------+-----------+------+---------+------+-------+------------------+ > | 31 | chylli¶è | localhost | test | Sleep | 1483 | | NULL > | > | 43 | root | localhost | test | Sleep | 116 | | NULL > | > > my question is: > 1. why not HDBC.ODBC use configuration in /etc/odbc.ini ? if is use, > then connectODBC "DSN=test" should use root as user without password and > it should succeed.
Are you sure it is a HDBC and not a ODBC-library problem? It seems that you use unixODBC and can then try the command: isql test which will connect though unixODBC without involving HDBC. If you still have the same problems, then it must be unrelated to HDBC. > > 2. when using UID=chylli, why the user in 'show processlist' is not > chylli but 'chylli¶è' ? if it use account 'chylli', that connection > should fail. but in fact it succeed !!! > > > Greetings, Mads Lindstrøm _______________________________________________ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe