MySQL(Linux)用户管理之总结

首页 | 图形图象 | 编程开发 | 操作系统 | 数据库 | 服务器 | 网络安全 | 人才酷 | 招聘 | 资源 | 酷站 | 顶尖周刊 |

热门文章

编辑推荐

相关文章
简单三步走堵死SQLServer注入漏洞黑客攻破SQL服务器系统的十种方法透明防火墙架设的完全攻略（brid linux定时备份mysql数据库 DNS (domain Name System) 系统的 qmail+vpopmail+sqwebmail的安装 qmail Vpopmail And sqwebmail H qmail Vpopmail And sqwebmail H qmail Vpopmail And sqwebmail H qmail Vpopmail And sqwebmail H

您现在的位置：顶尖设计 >> IT学院 >> 数据库 >> MySQL >> 文章正文

MySQL(Linux)用户管理之总结

作者：ITRunner 来源：CSDN 点击：更新：2006-12-20

简介：

用root登录（仅限本地） [root@np3 bin]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 344 to server version: 4.1.10a-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>　增加或修改用户权限---本地 mysql>　GRANT all on *.* to globus@'localhost' identified by "123456"; 增加或修改用户权限---远程 mysql>　GRANT all on *.* to globus@'%' identified by "123456"; 关键是此句中的%号要加' ',否则说语法错误，这是4.1.1的新规则。害的我到www.mysql.com上找了文档看了一下。下面是官方的文档 shell> mysql --user=root mysql If you have assigned a password to the root account, you'll also need to supply a --password or -p option for this mysql command and also for those later in this section. After connecting to the server as root, you can add new accounts. The following statements use GRANT to set up four new accounts: mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost'; mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';