What's user are you logged with when you're trying these commands? It looks like you specified no user when launching the mysql console. Try with user root if you have access to it. You don't have enough rights to perform your commands without a user specified.
Lian Sebe, M.Sc. Freelance Analyst-Programmer www.programEz.net > -----Original Message----- > From: Helen [mailto:[EMAIL PROTECTED] > Sent: Friday, July 18, 2003 4:57 AM > To: [EMAIL PROTECTED] > Subject: access denied > > > mysql> CREATE DATABASE csttrainrep > -> ; > ERROR 1044: Access denied for user: '@localhost' to database > 'csttrainrep' > mysql> GRANT ALL ON csttrainrep. TO helen > -> ; > ERROR 1064: You have an error in your SQL syntax. Check the manual > that corresponds to your MySQL server version for the right syntax to > use near 'TO helen' at line 1 > mysql> GRANT ALL ON csttrainrep.* TO helen; > ERROR 1044: Access denied for user: '@localhost' to database > 'csttrainrep' > mysql> > > > how do i change this? > > > -- > 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]
