Connection problem to MySQL, hot_gym_swarm test on Ubuntu 16.04LTS



Found it, its at:
I see that in the ‘support’ folder within nupic there’s a ‘nupic-default.xml’ file. Should I make a copy of the ‘nupic-default.xml’ file within ‘support’, rename it ‘nupic-site.xml’ and add in my password to the password field?


Yes try that.

You only need to provide XML in nupic-site.xml for overridden values, so yours should look something like this:


<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>


<!-- database credentials, used for swarming -->

  <description>Username for the MySQL database server </description>

  <description>Password for the MySQL database server </description>




I found and edit the nupic-site.xml file, but still did not work. I found this solution:

Basically you have to set the root (or any user) user to use the mysql_native_password plugin instead of auth_socket.



It really works. Thanks :slight_smile: