1. 请先用root登录到mysql,方法: c:\mysql\bin\mysql -uroot -p 2.创建一个用户为javauser, 口令为javadude ,拥有权限:可在任意主机上对数据库javatest进行任意操作 mysql> GRANT ALL PRIVILEGES ON javatest.* TO 'javauser'@'localhost' -> IDENTIFIED BY "javadude" ; mysql> GRANT ALL PRIVILEGES ON javatest.* TO javauser@"%" -> IDENTIFIED BY "javadude" ; mysql> GRANT ALL PRIVILEGES ON javatest.* TO 'javauser'@'localhost' ; 百度找一找 有很多~
首先,使用MySQL程式以MySQL root用戶來連接伺服器:shell> MySQL --user=root MySQL 如果您為root帳號指定了密碼,還需要為該MySQL命令和本節中的其它命令提供--password或-p選項。以root連接到伺服器上後,可以新增新帳號。下面的語句使用GRANT來設置四個新帳號: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';
c:\mysql\bin\mysql -uroot -p
2.创建一个用户为javauser, 口令为javadude ,拥有权限:可在任意主机上对数据库javatest进行任意操作
mysql> GRANT ALL PRIVILEGES ON javatest.* TO 'javauser'@'localhost'
-> IDENTIFIED BY "javadude" ; mysql> GRANT ALL PRIVILEGES ON javatest.* TO javauser@"%"
-> IDENTIFIED BY "javadude" ; mysql> GRANT ALL PRIVILEGES ON javatest.* TO 'javauser'@'localhost' ;
百度找一找 有很多~
http://twpug.net/docs/mysql-5.1/database-administration.html#adding-users
如果您為root帳號指定了密碼,還需要為該MySQL命令和本節中的其它命令提供--password或-p選項。以root連接到伺服器上後,可以新增新帳號。下面的語句使用GRANT來設置四個新帳號: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';