Re: Access Denied When Trying to Create Database
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]
Re: Access Denied When Trying to Create Database
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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
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/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
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]
Re: Access Denied When Trying to Create Database
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]
RE: Access Denied When Trying to Create Database
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]
Re: Access Denied When Trying to Create Database
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]
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]
Re: Access Denied When Trying to Create Database
Hi, I think you need to log in as root and grant yourself some privileges then. If you have lost the root password or root doesn't have privileges anymore either, there is a chapter in the manual on how to do this: http://dev.mysql.com/ Cheers Baron untz 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/[EMAIL PROTECTED] --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Baron Schwartz http://www.xaprb.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
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/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
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/[EMAIL PROTECTED]
Re: Access Denied When Trying to Create Database
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/[EMAIL PROTECTED]
