Mikhail,
I just tried what you suggested and got this:
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
Many, many thanks,
untz
On Jun 11, 2007, at 1:21 PM, Mikhail Berman wrote:
Looks like words "privileges on" are missing from GRANT statement you
used
Should be "grant super privileges on *.* to 'untz'@'localhost'
identified by 'password';
Not "grant super *.* to 'untz'@'localhost' identified by 'password';"
Regards,
Mikhail Berman
-----Original Message-----
From: untz [mailto:[EMAIL PROTECTED]
Sent: Monday, June 11, 2007 4:02 PM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: Access Denied When Trying to Create Database
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]
--
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]