おはようございます。井上です。
＞竹形様
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@127.0.0.1' (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@127.0.0.1' (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@127.0.0.1' (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>
−−−−−−−−−−以上−−−−−−−−−−−−