Re: Access Denied When Trying to Create Database

[untz]

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


On Jun 11, 2007, at 1:06 PM, Gerald L. Clark wrote:

untz wrote:
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql> grant super *.* to 'untz'@'localhost' identified by  
'password';
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 '*.* to [EMAIL PROTECTED] identified by  
password' at  line 1
Can anyone please help me?
I am not a DBA....
Kindest regards,
untz
On Jun 11, 2007, at 4:36 AM, Ananda Kumar wrote:
Is this a user "untz" going to do even the "create procedure",  
if  yes then
you need to grant "super" previliege to this user.

grant super on *.* to 'untz'@'localhost' identified by 'password';

regards
anandkl

On 6/11/07, untz <[EMAIL PROTECTED]> wrote:


Baron & Prathima,

Thank for the information!

What happened is that I hadn't used MySQL for a long time and  
looked
up on the Internet on how to change my root and individual users'
passwords.

The last command the URL had me type was "flush privileges;" and  
once
I did that, I think it created a problem for everything else.

Here's what I got when I ran SHOW GRANTS:

mysql> show GRANTS;
+------------------------------------------------------------------ 
-- ---
--------------------------------------+
| Grants for
[EMAIL PROTECTED]
                         |
+------------------------------------------------------------------ 
-- ---
--------------------------------------+
| GRANT USAGE ON *.* TO 'untz'@'localhost' IDENTIFIED BY PASSWORD
'*55C1BF0D7E49AB5343925CDD17F2F5F923B5248C'
| GRANT ALL PRIVILEGES ON `depot_development`.* TO  
'untz'@'localhost'
| GRANT ALL PRIVILEGES ON `depot_test`.* TO 'untz'@'localhost'
| GRANT ALL PRIVILEGES ON `depot_production`.* TO  
'untz'@'localhost'
| GRANT ALL PRIVILEGES ON `music_development`.* TO  
'untz'@'localhost'
| GRANT ALL PRIVILEGES ON `music_test`.* TO 'untz'@'localhost'
| GRANT ALL PRIVILEGES ON `music_production`.* TO  
'untz'@'localhost'
+------------------------------------------------------------------ 
-- ---
--------------------------------------+
7 rows in set (0.00 sec)

What am I supposed to do? I can not run queries or even create   
tables...

I also tried using a MySQL client (CocoaMySQL) and it displayed the
same error as in the previous e-mail (see below).

Am really stuck on this so any help, suggestions, etc. would be
greatly appreciated!

Sincerely yours,

untz

On Jun 10, 2007, at 5:44 AM, Baron Schwartz wrote:

> Hi untz,
>
> untz wrote:
>> Hello there,
>> I am using MySQL 5 on OS X Tiger...
>> After starting the server, I tried to create a sample  
database and
>> this is what what happened:
>> $ mysql -u untz -p
>> Enter password:
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 4 to server version: 5.0.16-standard
>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>> mysql> create database people_development;
>> ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to
>> database 'people_development'
>> mysql>
>
> Try running SHOW GRANTS while logged in, and see what privileges
> you have.  You probably need to grant your user some additional
> privileges.
>
> Cheers
> Baron
>
> --
> 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]


The show grants you ran shows you the proper syntax.

--
Gerald L. Clark
Supplier Systems Corporation


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]