Create an MySQL DB in 2 mins

In order to create a workable database in MySQL you will need to do the following. Firstly create a new database while logged into either MySql or some kind of control panel such as CPanel.

Once you have done this you will then need to create a new DB user (in order to access your newly created database). Create a user and then set a password for this user.

You will know need to grant this user some rights in order to use the database you have just set-up. The easiest and least in-secure method is to grant all privileges to this user, with the most secure being only to grant those privileges that are specifically required by this user.

Once you have created the database, create a new user, and then set-up the privileges for this user within the databases you can now go about actually using your database.

You would now populate your database with tables, triggers, stored procedures, and so on. What ever your analysis and design called for.

Tags:  DB, MySQL, SQL