0
  Login
  1. Home
  2. Docs
  3. Food Delivery Management ...
  4. Create Database

Create Database

Create Database

Go to MySQL Databases to create a new database, for example, multi_restaurants and new user and assign this database to the user created (remember the password used in this step we will use it in the installation step.)

How to Create a Database?

In the New Database text box, enter a name for the database.

Note:

If your hosting provider has enabled database prefixing, a prefix based on your account username and underscore character ( _ ) will precede the New Database text box. The system automatically prepends this prefix to the database name.

Click Create Database. A new interface will appear.
Click Go Back. The new database appears in the Current Database table.

How to Add a MySQL user?

After you create a database, add users to the database and configure their privileges.

Note:

You must create MySQL user accounts separately from mail and web administrator accounts.
You must create a user before you can add the user to an existing database.
To create a new user account, perform the following steps:

Enter a username in the Username text box.

Enter and confirm the new password in the appropriate text boxes.

Note:

The system evaluates the password that you enter on a scale of 100 points. 0 indicates a weak password, while 100 indicates a very secure password.
Some web hosts require a minimum password strength. A green Strength meter indicates that the password is equal to or greater than the required password strength.
Click Password Generator to generate a strong password. For more information, read our Password & Security documentation.

Click Create User.
Click Go Back to return to the main interface.

How to Add a user to a database?

To add a user to a database, perform the following steps:

In the Add User To Database section of the interface, select the desired user and database from the menus.
Click Add. The MySQL Account Maintenance interface will appear.
Select the checkboxes that correspond to the privileges that you wish to grant to the user.

Note:

To grant all of the available privileges to the user, select the ALL PRIVILEGES checkbox.

Click Make Changes.
Click Go Back to return to the main interface.

Facebook Comments

How can we help?