Add new comment

Create a MySQL database and a user

Submitted by Erik Wegner on Wed, 04/21/2010 - 10:39
Body

The following two commands create a database on a MySQL server and a user with full permissions inside this database.

Connect to your MySQL server:

mysql -uUSERNAME -hSERVERADDRESS -p

Geben Sie die folgenden zwei Befehle ein:

CREATE DATABASE dbname CHARACTER SET utf8;
GRANT ALL ON dbname.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
Database name:
User name:
User password:
Allow access from: