Skip to content

Files

Latest commit

7a9dc72 · Nov 18, 2016

History

History
executable file
·
96 lines (62 loc) · 3.62 KB

create-mysql-database.md

File metadata and controls

executable file
·
96 lines (62 loc) · 3.62 KB
title date categories tags permalink keywords
How do I create a MySQL database?
2014-02-24 01:43:18 -0800
Install
Install
Technical
/create-mysql-database/
mysqli, install
This guide is only for Yclas Self Hosted!

If you want to install Yclas Self Hosted, besides the required PHP, you will need a MySQL server with a database and a user name.

100% of managed hosting providers come with some sort of automation for this. If yours doesn't, check our hosting offer.

To make your life easier, I am just collecting some videos, done by users, explaining this process in different panels.

CPanel

Create A MySQL Database with cPanel - EASY tutorial


**To set up a database using the MySQL Database Wizard:**
  1. In the New Database field, enter a name for the database.
  2. Click Next Step.
  3. In the Username field, enter a name for the user allowed to manage the database.
  4. In the Password field, type the user’s password.
  5. The password must be 7 letters or shorter.
  6. For help generating a strong password, click the Password Generator button.
  7. Retype the password in the Password (Again) field.
  8. Click Create User.
  9. Select the privileges you wish to grant the user, or select ALL PRIVILEGES.
  10. Click Next Step.
  11. Next, cPanel will display a message stating that the database and user account were successfully set up.

Plesk

How to create a MySQL database in Plesk 11


DirectAdmin

Creating a MySQL database in DirectAdmin


ISPConfig

Server Management - Creating Database


MySQL (advanced users)

Step 1: Login to MySQL ( you will need an account )

user@server:~$ mysql -u mysql_user -p
Enter password:

Step 2: Create the Database

mysql > create database db_name;

Step 3: Verify that it's there

mysql > show databases;

Step 4: Create the User

mysql > create user db_user;

Step 5: Grant privileges while assigning the password

mysql > grant all on db_name.* to 'db_user'@'localhost' identified by 'db_password';

*Note: The localhost field usually doesn't have to be edited, but you can set it to the specific address.

The above example grants All privileges, obviously. But you will likely want to limit privileges under many circumstances. These parameters include Select, Insert, and Delete.

Choose all that apply and separate by comma:

mysql > grant select, insert, delete on db_name.* to 'db_user'@'localhost' identified by 'db_password';

via lanexa.net

Hope that was useful! If you want to know, [how to use MySQLi]({{ site.baseurl }}/use-mysqli) properly read our article about this topic.