MySQL Forums
Forum List  »  Connector/ODBC

Accessing MySQL from the shell without any trouble - SOLUTION
Posted by: Frederic Gillot
Date: August 25, 2007 01:31PM

Adding ODBC as a user with grant privileges allows to just type "mysql" from any prompt.

From the MySQL cmd, just enter:

CREATE USER ODBC ;
GRANT ALL PRIVILEGES ON *.* TO ODBC WITH OPTION;
FLUSH PRIVILEGES;

If ODBC already exist in the users table (SELECT user from user;) then, just delete it before applying the above command.

Hope this helps
Frederic

Options: ReplyQuote


Subject
Written By
Posted
Accessing MySQL from the shell without any trouble - SOLUTION
August 25, 2007 01:31PM
December 30, 2005 01:27PM
January 08, 2006 02:30PM
April 25, 2006 06:22PM


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.