SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:35 AM
| ||||
| ||||
 Access Denied When Trying to Create Database 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> What could I be possibly be doing wrong? Many, many thanks, untz      |
|
02-28-2008, 06:35 AM
| |||
| |||
| 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 |
|
02-28-2008, 06:35 AM
| |||
| |||
| 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 untz@localhost | +----------------------------------------------------------------------- --------------------------------------+ | 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? > unsub=untz786@yahoo.com > |
|
02-28-2008, 06:35 AM
| |||
| |||
| 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 <untz786@yahoo.com> 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 > untz@localhost > | > +----------------------------------------------------------------------- > --------------------------------------+ > | 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? > > unsub=untz786@yahoo.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=anandkl@gmail.com > > |
|
02-28-2008, 06:35 AM
| |||
| |||
| 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 > untz@localhost > | > +-------------------------------------------------------------------------------------------------------------+ > > | 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?unsub=untz786@yahoo.com >> > > > --MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=baron@xaprb.com > -- Baron Schwartz http://www.xaprb.com/ |
|
02-28-2008, 06:35 AM
| |||
| |||
| 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 untz@localhost 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 <untz786@yahoo.com> 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 >> untz@localhost >> | >> +-------------------------------------------------------------------- >> --- >> --------------------------------------+ >> | 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? >> > unsub=untz786@yahoo.com >> > >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql? >> unsub=anandkl@gmail.com >> >> |
|
02-28-2008, 06:35 AM
| |||
| |||
| 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 untz@localhost 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 <untz786@yahoo.com> 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 >>>> untz@localhost >>>> | >>>> +------------------------------------------------------------------ >>>> -- --- >>>> --------------------------------------+ >>>> | 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? >>>> > unsub=untz786@yahoo.com >>>> > >>>> >>>> >>>> -- >>>> MySQL General Mailing List >>>> For list archives: http://lists.mysql.com/mysql >>>> To unsubscribe: http://lists.mysql.com/mysql? >>>> unsub=anandkl@gmail.com >>>> >>>> > The show grants you ran shows you the proper syntax. > > -- > Gerald L. Clark > Supplier Systems Corporation |
|
02-28-2008, 06:35 AM
| |||
| |||
| 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 untz@localhost 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 <untz786@yahoo.com> 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 >>> untz@localhost >>> | >>> +-------------------------------------------------------------------- >>> --- >>> --------------------------------------+ >>> | 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? >>> > unsub=untz786@yahoo.com >>> > >>> >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: http://lists.mysql.com/mysql? unsub=anandkl@gmail.com >>> >>> > > The show grants you ran shows you the proper syntax. -- Gerald L. Clark Supplier Systems Corporation |
|
02-28-2008, 06:35 AM
| |||
| |||
| 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:untz786@yahoo.com] 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 untz@localhost 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 <untz786@yahoo.com> 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 >> untz@localhost >> | >> +-------------------------------------------------------------------- >> --- >> --------------------------------------+ >> | 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? >> > unsub=untz786@yahoo.com >> > >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql? >> unsub=anandkl@gmail.com >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mberman@ivesinc.com |
|
02-28-2008, 06:35 AM
| ||||
| ||||
| 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:untz786@yahoo.com] > 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 untz@localhost 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 <untz786@yahoo.com> 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 >>> untz@localhost >>> | >>> +------------------------------------------------------------------- >>> - > >>> --- >>> --------------------------------------+ >>> | 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? >>>> unsub=untz786@yahoo.com >>>> >>> >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: http://lists.mysql.com/mysql? >>> unsub=anandkl@gmail.com >>> >>> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=mberman@ivesinc.com > |
 |
« Re: Symantec Mail Security detected prohibited content in a message sent from your address (SYM:24166981753914768421)
|
Building RPMs with ICC »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 06:31 PM.
