List:General Discussion« Previous MessageNext Message »
From:untz Date:June 11 2007 8:55pm
Subject:Re: Access Denied When Trying to Create Database
View as plain text  
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
>

Thread
Access Denied When Trying to Create Databaseuntz10 Jun
  • Re: Access Denied When Trying to Create DatabaseBaron Schwartz10 Jun
    • Re: Access Denied When Trying to Create Databaseuntz11 Jun
      • Re: Access Denied When Trying to Create DatabaseAnanda Kumar11 Jun
        • Re: Access Denied When Trying to Create Databaseuntz11 Jun
          • Re: Access Denied When Trying to Create DatabaseGerald L. Clark11 Jun
            • Re: Access Denied When Trying to Create Databaseuntz11 Jun
              • Re: Access Denied When Trying to Create DatabaseGerald L. Clark11 Jun
                • Re: Access Denied When Trying to Create Databaseuntz11 Jun
                  • Re: Access Denied When Trying to Create DatabaseRolando Edwards11 Jun
                    • Re: Access Denied When Trying to Create Databaseuntz11 Jun
          • RE: Access Denied When Trying to Create DatabaseMikhail Berman11 Jun
            • Re: Access Denied When Trying to Create Databaseuntz11 Jun
      • Re: Access Denied When Trying to Create DatabaseBaron Schwartz11 Jun