- You have to create your service (which you can see by clicking right start menu bar and task manager). To create your service you have to open cmd as an adminstrator. Then write
cd where/your/ sql/bin/
. After that, writemysqld -install
– you should seeservice succesfully installed
. - Go to services from task manager, find mysql, right click it and click start.
- Go to cmd, write
cd where/your/ sql/bin/
, and press enter. - Write
mysql -u root
(if it is not protected with password, if so then add-p
).
Then you will be able to use SQL queries.
Please see the Mysql Manual page The MySQL Command-Line Tool for a reference.
1
solved I do not know how to use command prompt for mysql using [closed]