Access denied for user 'xxx'@'localhost' (using password: YES) (DSN=mysql://xxx:***@localhost:3306/xxx).

gerroon commented 6 years ago

Still trying to install it.

I am sure my sql user and pass is right. I am even trying the roo/password for mysql.

 indexer slimpdmain slimpdsuggest
Sphinx 2.2.11-id64-release (95ae9a6)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'slimpdmain'...
ERROR: index 'slimpdmain': sql_connect: Access denied for user 'xxx'@'localhost' (using password: YES) (DSN=mysql://xxx:***@localhost:3306/xxx).
total 0 docs, 0 bytes
total 0.014 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'slimpdsuggest'...
ERROR: index 'slimpdsuggest': sql_connect: Access denied for user 'xxx'@'localhost' (using password: YES) (DSN=mysql://xxx:***@localhost:3306/xxx).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg

othmar52 commented 6 years ago

are you able to connect to mysql directly from the terminal?

othmar52@mymachine ~ $ mysql -p -uxxx -hlocalhost
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
mysql> quit
Bye
othmar52@mymachine ~ $

gerroon commented 6 years ago

Yes I can with root or regular mysql user

othmar52 / slimpd

Access denied for user 'xxx'@'localhost' (using password: YES) (DSN=mysql://xxx:***@localhost:3306/xxx). #74