- After installing mySQL launch MySQL Workbench.
- On the left pane of the welcome window or under Database->Manage Connections, choose a database to connect to under "Open Connection to Start Querying".
- The query window will open. On its left pane, there is a section titled "Object Browser", which shows the list of databases. (Side note: The terms "schema" and "database" are synonymous in this program.)
- Right-click on one of the existing databases and click "Create Schema...". This will launch a wizard that will help you create a database.
If you'd prefer to do it in SQL, enter this query into the query window:
mysql> CREATE database unicentadb
; Query OK, 1 row affected (0.00 sec) We allow user beagle to connect to the server from localhost using the password beaglepasswd: mysql> grant usage on *.* to [email protected] identified by 'beaglepasswd'; Query OK, 0 rows affected (0.00 sec) And finally we grant all privileges on the unicentadb database to this user: mysql> grant all privileges on unicentadb.* to [email protected] ; Query OK, 0 rows affected (0.00 sec) And that's it. You can now check that you can connect to the MySQL server using this command: $ mysql -u beagle -p'beaglepasswd' unicentadb