> > mysql> grant all on radiant_cms_development.* to root@'%' identified by > 'root'; > ERROR 1044 (42000): Access denied for user ''@'localhost' to database > 'radiant_cms_development'
Does the user you are using to issue this command have appropriate permissions to GRANT permissions to others? On Mon, Dec 22, 2008 at 4:30 PM, Ryan Ororie < [email protected]> wrote: > > * Trying * (hard) to get Radiant CMS to work for me here. Based on these > instructions: > > http://wiki.radiantcms.org/Database_Configuration > > I created my development database, but when I try to use the 'grant all' > command to tell it the user name and pass this is what I get: > > mysql> grant all on radiant_cms_development.* to root@'%' identified by > 'root'; > ERROR 1044 (42000): Access denied for user ''@'localhost' to database > 'radiant_cms_development' > > I am assuming that I created it properly based on this: > > bio4054059:radiant_cms rmorourk$ > /Applications/MAMP/Library/bin/mysqladmin -u root -proot create > radiant_cms_development > bio4054059:radiant_cms rmorourk$ > > This is what the development portion of my database.yml file looks like > after I edited it: > > development: > adapter: mysql > database: radiant_cms_development > username: root > password: root > host: localhost > socket: /Applications/MAMP/tmp/mysql/mysql.sock > > So I don't know why I am getting an "accessed denied for user" ping > back, clearly those are the user name and password. Can I set the host > on this file to anything localhost:3006 ? > > I know I have been posting a lot, but you guys have been a big help so > far - hoping the charity of knowledge continues. Thanks! > > I feel like I got my rails setup off on the wrong foot - my mySQL stuff > is buried under the MAMP installation, I'm using locomotive which as far > as I can tell stops the terminal from setting up servers at the normal > local host. (it must all be done via locomotive). Any other advise on > how to "start-over" so to speak and use the proper way of doing things > with nice default-esc paths? > -- > Posted via http://www.ruby-forum.com/. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
