- Open MySQL command line interface
-u parameter defines the user (in this case
root) while the blank
-p triggers user input for the associated password. Below is a a primer for common SQL operations.
Note: SQL commands are terminated by a semi-colon character
- Create a table with defined columns
- Note that various data types can be defined for each column. These are oulined in the official MySQL reference documentation.
- Delete a table from current database
- Select a database for table operations
- List all tables in current database
- List all entries in a table
- Grant all privileges for
More advanced operations and SQL server settings are outlined below.
This allows database access from outside of the installation localhost environment