MySQL Forums
Forum List  »  Newbie

Re: can't connect to db with mysql++
Posted by: Chris Stubben
Date: March 25, 2005 11:59AM

Hi,

I never use windows, but you probably have to create an ODBC user with the grant command.


Login to the mysql client as root, and then do this command

GRANT ALL on *.* to 'ODBC'@'localhost';

If you want to assign a password, add this.

GRANT ALL on *.* to 'ODBC'@'localhost' identified by 'password';


You may want to limit the privileges by speficying each one (grant select, update, delete, insert, create on ...) and also which databases ODBC can connect to.


Chris

Options: ReplyQuote


Subject
Written By
Posted
March 23, 2005 09:00PM
March 24, 2005 11:18AM
March 25, 2005 11:49AM
Re: can't connect to db with mysql++
March 25, 2005 11:59AM
March 25, 2005 12:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.