Here are the step by step procedure to use MySQL Command line in XAMPP
Before doing this make sure that mysql is installed on computer and its running successfully.
1. Go to start menu -> Run -> then type cmd to open command line
2. Go to the home directory of XAMPP (type cd C:\xampp in command line)
3. Go to the mysql bin directory (type cd mysql\bin in command line)
4. Now type mysql.exe --user=root --password = password (if you have changed the password)
5. Type mysql.exe --user=root --password = (if you didn't change the password)
6. If you properly do all the above steps then you will get mysql> in command line
7. Now go ahead with all your data base related quires to interact with your mysql server
No comments:
Post a Comment