I am having trouble getting the ball rolling here. The idea is that I would like to put mySQL commands into the command line, building a database on my server- fairly straightforward.
Comments
I assume that you have created a password for user root while installing the mysql on windows. Now to connect from DOS prompt to mysql. Go to mysql directory i.e.
C:\Program Files\Mysql\Mysql Server\Bin\mysql -u root -p
password:********
mysql>
type help to know the command used in the mysql.
If you have MySQL installed already why not use the graphical DB manager called My SQL Manager that comes bundled with the Windows release of MySQL? You don’t have to go through the command window to do anything, it’s all graphical user interface. You just configure it with the server IP or Name and the admin username/password. It creates DBs, tables, and users. You can run queries from it also. If you want to learn the command line stuff maybe you should start with the GUI first to get the hang of it. It’s a lot easier to understand that way.
There’s a root user with no password by default. Hopefully you have edited that account. If not, you won’t need a password to run queries on the server. Open the command window. You have to open mysql:
DRIVELETTER:\mysql\bin\mysql
The path to the mysql exe which is in the bin folder where mysql was installed. You’ll get a mysql prompt:
mysql>
Type in \h
For the help.
