MySQL user database creation method: Create a database linuxidc, add a user doiido, the password is linuxidc.com, and only have permissions on the linuxidc database.
MySQL user database creation method: Create a database linuxidc, add a user doiido, the password is linuxidc.com, and only have permissions on the linuxidc database.
Homepage → Database Technology
Background:
Read News
MySQL user database creation method
[Date:] Source: Linux community Author: doiido [Font:]
MySQL user database creation method:
Create a database linuxidcs, add a user doiido with the password linuxidc.com, and only have permissions on the linuxidc database.
1. logon Method
# Mysql-u root-p
2. Create a database
Mysql> create database linuxidc;
3. Add a remote user
Mysql> grant all privileges on linuxidc. * TO doiido @ "%" identified by 'linuxidc. 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 --------------------------------------
0
MySQL error: master and slave have equal MySQL server UUIDs
Install and optimize MySQL in Linux
Related information MySQL database creation
Image Information
View All comments in this article (0)
Comments
Latest Information
Popular this week
Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.
Copyright©2006-2015 Linux community All rights reserved Shanghai ICP filing no. 15008072-1