mysql创建新用户并赋予权限_MySQL
- WBOYOriginal
- 2016-06-01 13:40:361155browse
bitsCN.com
mysql创建新用户并赋予权限 1、以管理员身份登录mysql mysql -u root -p 2、选择mysql数据库 use mysql 3、创建用户并设定密码 insert into user (Host,User,Password) values ('localhost', 'test',password('1234')) 4、使操作生效 flush privileges 5、为用户创建数据库 create database testdb 6、为用户赋予操作数据库testdb的所有权限 grant all privileges on testdb.* to test@localhost identified '1234' 7、使操作生效 flush privileges 8、用新用户登录 mysql -u test -p
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySql里的IFNULL、NULLIF和ISNULL用法_MySQLNext article：xp安装2个mysql-5.5.23-win32.zip解压版_MySQL