おはようございます。井上です。

＞竹形様

rootで試してみましたが、同様にpasswordが与えられません。

以下に作業logを貼り付けます。

−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\Documents and Settings\Administrator>f:\crm\mysql\bin\mysql mysql -h
localhost -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.13-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select user, password, host from user;
+--------+------------------+-----------+
| user   | password         | host      |
+--------+------------------+-----------+
| root   |                  | localhost |
| root   |                  | %         |
| thanks | 6067188d6665bffe | localhost |
| thanks | 6067188d6665bffe | %         |
+--------+------------------+-----------+
4 rows in set (0.01 sec)

mysql> grant all on root to thanks@'%' IDENTIFIED BY 'r';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on root to thanks@localhost IDENTIFIED BY 'r';
Query OK, 0 rows affected (0.00 sec)

mysql> select user, password, host from user;
+--------+------------------+-----------+
| user   | password         | host      |
+--------+------------------+-----------+
| root   |                  | localhost |
| root   |                  | %         |
| thanks | 6067188d6665bffe | localhost |
| thanks | 6067188d6665bffe | %         |
+--------+------------------+-----------+
4 rows in set (0.00 sec)

mysql> set password for root@"%" = password('r');
Query OK, 0 rows affected (0.05 sec)

mysql> Aborted

C:\Documents and Settings\Administrator>f:\crm\mysql\bin\mysql mysql -h
localhost -u root -p
Enter password: *
ERROR 1045: Access denied for user: 'root@xxxxxxxxxx' (Using password: YES)

C:\Documents and Settings\Administrator>f:\crm\mysql\bin\mysql mysql -h
localhost -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.13-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>  Aborted


＃＃ここでサービスを再起動＃＃


C:\Documents and Settings\Administrator>f:\crm\mysql\bin\mysql mysql -h
localhost -u root -p
Enter password: *
ERROR 1045: Access denied for user: 'root@xxxxxxxxxx' (Using password: YES)

C:\Documents and Settings\Administrator>f:\crm\mysql\bin\mysql mysql -h
localhost -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.13-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on root to thanks@'%' IDENTIFIED BY 'r';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on root to thanks@localhost IDENTIFIED BY 'r';
Query OK, 0 rows affected (0.02 sec)

mysql>
mysql> flush privileges;
Query OK, 0 rows affected (0.05 sec)

mysql> Aborted

C:\Documents and Settings\Administrator>f:\crm\mysql\bin\mysql mysql -h
localhost -u root -p
Enter password: *
ERROR 1045: Access denied for user: 'root@xxxxxxxxxx' (Using password: YES)

C:\Documents and Settings\Administrator>f:\crm\mysql\bin\mysql mysql -h
localhost -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.13-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

−−−−−−−−−−以上−−−−−−−−−−−−