rt indexes: Access denied for user 'root'@'localhost'

anonymous user

m_al_com Name: Al Donnelley Posts: 8	2012-08-07 05:53:17 \| reply! Hi, I've had success using rt indexes on my dev server (wamp on windows 7 64). On the dev server I've been connecting to sphinx in php with: $s = mysqli_connect('localhost', "", "", "", 9306) or die (mysqli_connect_error); The production server, however, throws: Access denied for user 'root'@'localhost' (using password: NO) at that line. I have successfully connected to sphinx on the production server with putty using: mysql -h localhost --port 9306 --protocol=tcp Which returns: Your MySQL connection id is 1 Server version: 2.0.4-release (r3135) and: mysql> show tables; gives: +-------+-------+ \| Index \| Type \| +-------+-------+ \| prod1 \| local \| \| rt \| rt \| +-------+-------+ So it looks like I've got searchd running and can connect to it through cli. Does anyone have any clues as to why I can't connect with mysqli_connect? (I don't think I can access my.cnf, unfortunately.) Cheers, m_al_com
aditirex Name: Adrian Nuta Posts: 292	to: m_al_com, 2012-08-07 18:42:12 \| reply! try with 127.0.0.1 instead of localhost
m_al_com Name: Al Donnelley Posts: 8	to: aditirex, 2012-08-07 23:56:27 \| reply! > try with 127.0.0.1 instead of localhost Thanks. That worked. probably should have thought of giving that a try myself.