Database: MySQL Rough Notes

[Needs much more here]

Starting the MySQL server

C:\>mysqld [-u username]

Starting the MySQL command line interface

C:\>mysql --user=username --password=passwd dbname
MySQL will prompt for a password if the password is omitted.
C:\>mysql --user=username --password dbname
A short form may be used.
C:\>mysql -u username -p dbname

Shutting down MySQL

C:\>mysqladmin -u root shutdown

Some MySQL Commands

MySQL Commands