Sphinx Configuration error: Mysql2::Error (Can’t connect to MySQL server on ‘127.0.0.1’ (111))

While setting up a Rails project in my machine, I got this error. First I can’t understand why this error coming, because I am successfully using mysql database in this project, and mysql server is running in my system. The error line number shows near the Sphinx code ‘Model.search’, then I understood this is because of the wrong set up of my sphinx configuration. But why this error? I read some documents and understood that sphinx internally using mysql protocol, so showing this error. Anyway I am checking my sphinx configuration, and no yml config file of sphinx found! So I have some works to do now!

I followed these steps,
Configure Sphinx in Rails 3.2

And all works fine!!

Author: Abhilash

I'm Abhilash, a web developer who specializes in Ruby development. With years of experience working with various frameworks like Rails, Angular, Sinatra, Laravel, NodeJS, React and more, I am passionate about building robust and scalable web applications. Since 2010, I have been honing my skills and expertise in the Ruby on Rails platform. This blog is dedicated to sharing my knowledge and experience on topics related to Ruby, Ruby on Rails, and other subjects that I have worked with throughout my career. Join me on this journey to explore the exciting world of web development! View all posts by Abhilash