After installing it and making sure that the service has started, open DOS prompt,
go to c:\mysql\bin
>mysql -u root (press enter)
Now you are logged on MySQL prompt. You can issue your queries there.
To avoid having to go to c:\mysql\bin dir every time you log on, add the same path to autoexec.bat (an entry would be something like SET PATH = C:\MYSQL\BIN)
The first thing you should do is GRANT correct rights for user root
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.