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" <untz786@stripped>
> Cc: mysql@stripped
> 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?
>> unsub=untz786@stripped
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?
> unsub=redwards@stripped
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?
> unsub=untz786@stripped
>
