Additional info: the user is added to mysql.user with no privileges. the user is added to mysql.db with insert,update,delete,select privileges on phonewatch db.
When I try to connect to the db, "C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD", I get "ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)" please help > -----Ursprungligt meddelande----- > Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] > Skickat: den 23 oktober 2003 09:15 > Till: [EMAIL PROTECTED] > Ämne: GRANT problem > > > Hello > > I've created an account by using: > GRANT insert,update,select,delete on phonewatch.* to datatal > identified by 'MYPASSWORD' > > I cant connect(mysql.exe or myodbc) to the db with the new > account, and I did not receive any errormessages when > creating the account. Have I forgot something? > > Med vänlig hälsning/Best Regards > Datatal Utveckling AB > Jonas Gauffin > Tel direct: +46 (0) 498 25 30 16 > Tel Support: +46 (0) 498 25 30 30 > Fax: +46 (0) 498 25 30 99 > http://www.datatal.se > > "I try every day, but sometimes I fail" > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
