MySQL user database creation method

MySQL user database creation method

MySQL user database creation method:

Create a database bkjia, add a user named doiido with the password bkjia.com, and only have permissions on the bkjia database.

1. logon Method

# Mysql-u root-p

2. Create a database

Mysql> create database bkjia;

3. Add a remote user

Mysql> grant all privileges on bkjia. * TO doiido @ "%" identified by 'bkjia. com ';

-------------------------------------- Split line --------------------------------------

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

MySQL-5.5.38 universal binary Installation

-------------------------------------- Split line --------------------------------------

This article permanently updates the link address: