Hi ppl! I've got a strange problem. I've created a user account with access to some concrete database using GRANT query (see below) but I cannot connect to the server using this usename only when connecting via mysql_real_connect() from C API. When using "mysql -u MY_USER" it works fine.
What's wrong? Initial action is: make_scrambled_password(passwd,MY_USER_PASSWD); sprintf(query,"grant insert,index,select,update on my_database.* to %s identified by password '%s'",MY_USER,passwd); mysql_query(db,query); all appropriate records are placed in privilege tables - I checked. But when trying: mysql_real_connect(db,"localhost",MY_USER,MY_USER_PASSWD,"my_database",0,"",0); I get and error message "Access denied to user MY_USER@localhost (Use password=YES)" What's going bad? Alex --------------------------------------------------------------------- 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
