竖立用户的语法:
Create user `username`@host [Identified by [password] `password`]; Username:用户名 Host:主机名,当地主机可以用localhost或许ip地点,然则其他电脑必须用ip地点登录长途主机用通配符 “%” Password:用户暗码
例:
create user `teacher`@`localhost` identified by ‘12345’, 或许 create user `teacher`@`localhost (无暗码)
实行grant(赋权限的同时) 竖立用户
语法:
Grant priv_type on 数据库或许数据表 to username@localhost(或许IP地点) identified by ‘123’;
运用mysql Admin修正root账户暗码
语法:
Mysqladmin –u root –p password “123”; Enter password:原暗码(root)
运用set密令修正普通用户暗码(mysql的敕令)
语法:
Set password=password(“000”); //修正当前用户暗码 Set password for teacher@localhost=password(“123”); //修正指定账户暗码
删除普通用户
Drop user `studentr` @localhost;
以上就是关于MySQL竖立新用户并受权的要领的细致内容,更多请关注ki4网别的相干文章!