linux环境下,通过root 启动mysql:
[root@mysql237 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.1.58-log MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql
Database changed
mysql>
在该目录下用:
GRANT ALL PRIVILEGES ON optdb.* TO 'optuser'@'%' IDENTIFIED BY 'aaaaaaaa' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON optdb.* TO 'optuser'@'localhost' IDENTIFIED BY 'aaaaaaaa' WITH GRANT OPTION;
创建了optuser用户,则该用户可以在本机进行登录,并且访问optdb数据库。 但是无法通过该用户远程进行访问数据库。
我又用
CREATE USER testuser IDENTIFIED BY 'aa343411';
GRANT ALL PRIVILEGES ON *.* TO 'testuser';
创建了testuser用户,问题依然存在。
如下是mysql数据库中user表的相关信息:
| % | optuser | *FFC8C0A0ABDC086CCCD36CB5898DB11C0FCC8EC6 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 |
| localhost | optuser | *FFC8C0A0ABDC086CCCD36CB5898DB11C0FCC8EC6 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 |
| % | testuser | *017EC867CAC49A3B2F93038B20D75DD2A55D9921 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |
+-----------+----------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
8 rows in set (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)