首頁猿問 mysql創(chuàng)建用戶并給與一個完整的...

mysql創(chuàng)建用戶并給與一個完整的數(shù)據(jù)庫，怎么寫語句

MySQL

牧羊人nacy 2019-03-12 13:09:29

查看完整描述

4 回答

繁星coding

TA貢獻1797條經(jīng)驗獲得超4個贊

1、用管理員登陸mysql
2、創(chuàng)建數(shù)據(jù)庫create database db01;
3、創(chuàng)建用戶
user01只能本地訪問
CREATE USER user01@'localhost' IDENTIFIED BY 'password1';
user02可以遠程訪問
CREATE USER user02@'%' IDENTIFIED BY 'password1';
4、修改user01密碼
SET PASSWORD FOR 'user01'@'localhost' = PASSWORD('password2');
5、授權
a)、user01管理db01全部權限
GRANT ALL PRIVILEGES ON db01.* TO user01;
b)、user02查看權限，并修改密碼
GRANT SELECT ON *.* TO 'user02'@'%' IDENTIFIED by 'password2';

反對回復 2019-03-17

千萬里不及你

TA貢獻1784條經(jīng)驗獲得超9個贊

新建普通用戶：CREATE USER 'test1'@'localhost' IDENTIFIED BY 'test1'
數(shù)據(jù)庫創(chuàng)建：CREATE DATABASE example
表的創(chuàng)建：CREATE TABLE example0(id INT,
name VARCHAR(20),
sex BOOLEAN
)

反對回復 2019-03-17

Cats萌萌

TA貢獻1805條經(jīng)驗獲得超9個贊

DROP DATABASE IF EXISTS userdb;
CREATE DATABASE userdb;
USE userdb;
CREATE TABLE user(
id int(11)NOT NULL AUTO_INCREMENT,
userName varchar(20) DEFAULT NULL,
userPwd varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO user(id,userName,userPwd)VALUES(1,'admin','admin');