常用myslq命令

    xiaoxiao2022-07-13  161

    1.在root用户下操作

    删库语句:DROP DATABASE IF EXISTS dev_teller9;

    删除用户:DROP USER dev_teller9;

    建库语句:  CREATE DATABASE dev_teller9 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 建立用户:create user 'dev_teller9'@'%' IDENTIFIED by 'dev_teller9'; 为用户授权GRANT ALL PRIVILEGES on `dev_teller9`.* to 'dev_teller9'@'%'; FLUSH PRIVILEGES; COMMIT ;

     

    最新回复(0)