On 18 April 2011 08:23, amrit pal pathak <amritpalpath...@gmail.com> wrote: > > > On Apr 17, 9:02 pm, Peter De Berdt <peter.de.be...@pandora.be> wrote: >> On 17 Apr 2011, at 17:04, amrit pal pathak wrote: >> >> >> >> > On Apr 17, 7:27 am, Chris Kottom <ch...@chriskottom.com> wrote: >> >> Are you planning to continue using sqlite in the production >> >> environment? >> >> Most people don't, but it's not a problem to do so. >> >> >> If not or if the default sqlite settings aren't right for you, then >> >> you'll >> >> need to make some changes, but those will depend on the environment >> >> you're >> >> deploying into. But what those should be isn't a question the >> >> mailing list >> >> can answer for you without more information. >> >> > The production environment setting with sqllite are by >> > default .I want to use mysql for production too.So i changed the >> > production enviornment settings to >> > production: >> > adapter: mysql >> > database: blog >> > username: root >> > password: 12345 >> > pool: 5 >> > timeout: 5000 >> >> > Is it enough?? >> >> If you're running Rails 3, you're better off using "mysql2" as the >> adapter and you have to make sure you include the mysql2 gem in your >> Gemfile too. Also, you might want to use a more secure password for >> MySQL on your production server ;-) > I am running rails 2.3.5.Now view following > adapter: mysql > database: blog > username: root > password: (will take a strong password ) > pool: 5 > timeout: 5000 > socket: /var/run/mysqld/mysqld.sock > Is it ok > now?
Does it work? Don't forget to make the production database and to start the server in production mode. I would advise against using your mysql root user for rails access, better to make a rails user and give it just the permissions it needs. Colin -- 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 rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.