email info@codeaffairs.com
Code Affairs Web Technologies!

widgets Create a database via MySQL console


Login to MySQL console in terminal use:

mysql -u=root -p

Create a database:

Create Database DATABASENAME Character Set utf8mb4 Collate utf8mb4_unicode_ci;

Define a user for the database:

Grant All Privileges ON DATABASENAME.* to 'USER_NAME'@'localhost' Identified By 'YOUR_PASSWORD';

Refresh the permissions:

Flush Privileges;

bubble_chart Short Description

None
history_toggle_off Created: March 13, 2019, 9 a.m.

category Related Categories

visibility Total Read: 6