section IIMysqlAdd new users
1. The show databases command is used to display all databases.
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/50/D9/wKioL1RiwuCBB7dFAADZWsCudZc837.jpg "title=" 1. PNG "alt=" wkiol1riwucbb7dfaadzwscudzc837.jpg "/>
2. The grant on command is used to add new users and control their permissions.
Mode one: Have all permissions on a database
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/50/DA/wKiom1RiwpmClVPwAABDPyjjA2Y608.jpg "title=" 2.png " alt= "Wkiom1riwpmclvpwaabdpyjja2y608.jpg"/>
You can then log in with a new user
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/50/D9/wKioL1RiwzLS-h1fAAF_39dr_1A648.jpg "title=" 3.png " alt= "Wkiol1riwzls-h1faaf_39dr_1a648.jpg"/>
Mode two: Have partial permissions on a database
650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M02/50/DA/wKioL1Riw0ny7_mMAAA-sWFbO-Y327.jpg " Title= "4.png" alt= "Wkiol1riw0ny7_mmaaa-swfbo-y327.jpg"/>
This article is from "Cloud Ice xia Kiss" blog, make sure to keep this source http://sz1409024.blog.51cto.com/7007696/1575585
Section II MySQL Add new user