Rolando!
Yes, that worked! I did have to log into mysql as root, however...
BTW, for some odd reason someone's symantec virus checker is sending
me denied e-mail responses from Italy, whenever I try to post to the
MySQL mailing list.
Many, many thanks,
Unnsse
On Jun 11, 2007, at 1:41 PM, Rolando Edwards wrote:
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/mysql?
[EMAIL PROTECTED]
--
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]