MySQL database creeëren in Direct Admin

Database management systems like MySQL provide means for many users within a network to access a number of databases. Many projects that need to have some form of database management system often make use of MySQL. Many web applications have utilized MySQL in their systems.

This tutorial will teach you how to create a MySQL database for your account using Direct Admin:

Klik hier voor de video

1. Log in to Direct Admin.

2. Under the “Your Account” tool, look for the “MySQL Management” link.

3. Click the “MySQL Management” link to access the main MySQL database screen. Here you can create new databases or manage your existing ones.

4. On the upper portion of the screen, you will find the “Create new Database” link. Click this link to start creating a new database.

5. Create a name for your new database by entering a database name on the space provided.

6. Set a database username for your new database too. Just enter a database username on the blank provided.

7. Enter your desired database username password on the space allotted for it.

8. Confirm your password by entering it again on the space given.

9. If you are done setting up the previous information, you may now click the “Create” button at the lower left portion of the form.

10. You have now successfully created your new database. Within this page, you will also find the values you need to connect to the database through a program or script.

11. Go back to the database page by clicking “HERE” found at the bottom of the page. This will take you to the database page where you can create new databases or modify existing ones.

12. Your newly created database will be shown in this page. Click on your new database to access it.

13. After choosing the database, click the “modify privileges” link found on the page of your new database. The link will take you to the page where you can limit access to specific users and modify some settings for your database. However, these settings usually don’t need further modifications.

14. Go through the specifications found on the page but leave everything unchanged for now. Once your done, click the “Save” button.

15. Go back to your Direct Admin main page. You now know how to create mySQL databases and modify user preferences for each database.

16. Thank you for watching this demo on how to create a MySQL database in Direct Admin.

Our Solutions

Service

Social Link