Accessing MySQL from the shell without any trouble

[Frederic Gillot]

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



Edited 1 time(s). Last edit at 08/25/2007 01:37PM by Frederic Gillot.