{"id":3137,"date":"2018-07-24T11:35:45","date_gmt":"2018-07-24T09:35:45","guid":{"rendered":"https:\/\/assistance.groupemagiconline.com\/?post_type=ht_kb&p=3137"},"modified":"2019-08-22T16:34:17","modified_gmt":"2019-08-22T14:34:17","slug":"plesk-ajouter-une-base-de-donnees-mysql","status":"publish","type":"ht_kb","link":"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/plesk-ajouter-une-base-de-donnees-mysql\/","title":{"rendered":"Plesk: Add a MySQL database"},"content":{"rendered":"

In this guide, we will see how to create a database on the Plesk interface.<\/p>\n \t\t

\r\n \t\t\tNote<\/span> \t\t\t \t\t\t\t

\r\n \t\t\t\t\tThis guide is dedicated only to our subscribers who have subscribed to the former Plesk shared hosting packages (SMART, DISCOUNT, PRO and SECURE). \t\t\t\t<\/p>\r\n \t\t\t \t\t\t\r\n \t\t<\/div>\r\n \t\t\n

You need to start by going to your customer interface, the link to which can be found on our showcase site. Once there, click on Plesk > My Plesk (Manage my subscription) > menu\u00a0Databases<\/strong>.<\/p>\n

Click on the button\u00a0Add a database<\/strong>.<\/p>\n

If this button does not appear, it means that you have reached the limit of the number of databases in your hosting package\u00a0shared<\/strong>. If in doubt, consult our mutualized offers on\u00a0this link<\/a>.<\/p>\n

\"\"<\/a><\/p>\n

Put the name of the database, as well as the site that will use it.<\/p>\n

It is advisable to use a meaningful database name. Avoid empty spaces and special characters.<\/p>\n

Create a database user and a password for the user.<\/p>\n

Make sure that the password is of security level\u00a0Fort<\/strong>\u00a0so that the system can accept it. Use the two buttons\u00a0Generate\u00a0<\/strong>and\u00a0View<\/strong>\u00a0to have Plesk help you set a reliable password.<\/p>\n

\"\"<\/a><\/p>\n

Click on\u00a0OK<\/strong>\u00a0for the creation to be successful.<\/p>\n

\"\"<\/a><\/p>\n

Warning: If you uncheck the\u00a0Create a database user<\/strong>and you do not assign a user to your database, you will be presented with the following display and you will be deprived of the link\u00a0phpMyAdmin<\/strong>\u00a0which is used to go to the database. Moreover, you will not be able to use it in your scripts either.<\/p>\n

\"\"<\/a><\/p>\n

NOTE:<\/em><\/p>\n