Home >Database >Mysql Tutorial >Mysql----创建新用户_MySQL
Mysql----创建新用户_MySQL
- WBOYOriginal
- 2016-05-31 08:47:06988browse
用途: 增加一个用户test1密码为abc，让他可以在本地主机上登录，并对所有数据库有查询、插入、修改、删除的权限。
步骤:
1. 以root用户连入MYSQL
2. 查看数据库
show databases;
3. 使用数据库mysql
use mysql;
3. 键入以下命令：
grant select,insert,update,delete on *.* to "test1"@“localhost” Identified by “abc”;
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数据库的自动备份与数据库被破坏后的恢复1Next article：快照方式备份MySQL数据库及举例