[ILUG] MySQL

[Colm Buckley]

>  Ack. How do I add a user to Mysql. I've a user;
> 
> mysql> use mysql;
> mysql> select User,Host,Password from user where User = 'xenocide';
> [...]
> 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 ?

'mysqladmin reload' to reload the mysql users database.

          Colm

-- 
Colm Buckley BA BF | NewWorld Commerce, 44 Westland Row, Dublin 2, Ireland
colm at tuatha.org (personal) | colm.buckley at nwcgroup.com (business)
+353 87 2469146 | whois cb3765 | http://www.tuatha.org/~colm/
A clear conscience is usually the sign of a bad memory.