Forum Index


Board index » All Posts (eye)




mysql create user and database
#1
Webmaster
Webmaster


CREATE database userdb ;

CREATE USER 'user'@'%' IDENTIFIED BY 'psdpsd';

grant all privileges on   userdb.* to  'user'@'%'



revoke all on db.* from  'user'@'%'



#################

show grants for  db_user

Posted on: 2022/12/18 20:25

Edited by eyex on 2023/8/20 19:08:12
Top


efwf
#2
Webmaster
Webmaster


ewfwaf

Attach file:



jpg  3232.jpg (48.74 KB)
1_59bfbf7531524.jpg 450X125 px

Posted on: 2017/9/18 20:41
Top


ok img
#3
Webmaster
Webmaster


ok img

Attach file:



jpg  u=3123491506,1077281282&fm=11&gp=0.jpg (30.41 KB)
1_59c0a7897c035.jpg 533X299 px

Posted on: 2017/9/18 11:47

Edited by eye on 2017/9/19 13:13:45
Edited by eye on 2019/4/6 8:46:29
Top



TopTop



Themes

(2 themes)
Login
Username:

Password:


Lost Password?
Register now!
Categories
Xoops (11)
--Modules (2)
--Themes (0)
Article (8)