Sunday, August 19, 2012

mysql : connecting to mysql database from windows command shell

in this code i connect to a mysql database using the command shell and xamp virtual server. Once i have xamp and the path to mysql.exe in my system path I can use:
mysql -h localhost -u oladitan
to connect my localhost database with the user name "oladitan". From here I can perform various operations including database selection and querying.

No comments:

Post a Comment