[ILUG] MySQL

[John P. Looney]

 Ack. How do I add a user to Mysql. I've a user;

mysql> use mysql;
Database changed
mysql> select User,Host,Password from user where User = 'xenocide';
+----------+------+------------------+
| User     | Host | Password         |
+----------+------+------------------+
| username | %    | 26104295728005ca |
+----------+------+------------------+
1 row in set (0.00 sec)

mysql>  update user set Password = password('testpass') where user = 'username';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

xena [0]  mysql -u username -p
Enter password:             <-- I put in testpass
ERROR 1045: Access denied for user: 'username at localhost' (Using password: YES)

 Any idea what could be wrong ?

Kate

-- 
"The fool must be beaten with a stick, for an intelligent person 
the merest hint is sufficient"                -- Zen Master Greg