How to create a MySQL database in Direct Admin

How to create a MySQL database in Direct Admin

Click the MySQL Management link

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to create a MySQL database

Let’s go ahead and create a new database… click this link

This is the main MySQL database screen where you can create new databases, or manage existing ones

Create a Database Name, and Database Username in the spaces provided

Then enter the database Username Password here…..

….. and again here

Then click the Create button

Scroll down…

The database has been successfully created

Now let’s return to the database page…. Click Here

Listed here are the values you’ll need if connecting to this database from a program or script

Let’s click on the database we just created

From this page you can create new databases, or modify existing ones

Now click the modify privileges link for this user

Let’s leave everything unchanged…. click the Save button

Although you’ll typically never have to modify any of these settings, this is where you would limit certain types of access for specific users

Click the Home icon here

This is the end of the tutorial. You now know how to create MySQL databases, and modify user preferences

Updated on September 7, 2018

Related Articles