Browsing this Thread:   1 Anonymous Users






mysql create user and database
#1
Webmaster
Webmaster


See User information
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








friend links
Themes

(2 themes)
Login
Username:

Password:


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