Guest_imported
New member
- Jan 1, 1970
- 0
Hi all,
I cannot seem to connect to MySQL with a user and pass.
In mysql I set up things in the MySQL user table according to the manual:
mysql>use mysql;
mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('secret'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
Then I exit and try and connect:
mysql -u monty -psecret
I get the following error:
Warning:Access denied for user 'monty@localhost'(using password:YES)
mysql -u monty works just fine. In fact mysql -u anyone works just fine.
Am I missing something? I'm on Win2k.
I cannot seem to connect to MySQL with a user and pass.
In mysql I set up things in the MySQL user table according to the manual:
mysql>use mysql;
mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('secret'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
Then I exit and try and connect:
mysql -u monty -psecret
I get the following error:
Warning:Access denied for user 'monty@localhost'(using password:YES)
mysql -u monty works just fine. In fact mysql -u anyone works just fine.
Am I missing something? I'm on Win2k.