Don't you mean this ? grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog';
----- Original Message ----- From: "untz" <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Monday, June 11, 2007 4:36:33 PM (GMT-0500) America/New_York Subject: Re: Access Denied When Trying to Create Database Gerald, I tried this and it still didn't work! Raven:~ untz$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 223 to server version: 5.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant super privileges on *.* to 'untz'@'localhost' identified by 'maddog'; ERROR 1064 (42000): 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 'privileges on *.* to 'untz'@'localhost' identified by 'maddog'' at line 1 mysql> :( Kindest regards, Unnsse On Jun 11, 2007, at 1:28 PM, Gerald L. Clark wrote: > untz wrote: >> Gerald, >> I tried this and still got an error! >> mysql> grant all privileges on *.* to 'untz'@'localhost' >> identified by 'maddog'; >> ERROR 1045 (28000): Access denied for user >> 'untz'@'localhost' (using password: YES) >> mysql> >> Can anyone please help me? I am unable to use MySQL at all, at >> this point... >> -untz > You have to be logged-in to mysql as a privileged user to grant > permissions to others. > Logout, and login as root. > > > > > -- > Gerald L. Clark > Supplier Systems Corporation > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql? > [EMAIL PROTECTED] > -- 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]
