Ok I am now a step closer into getting this to work. I was able to get the discourse user to connect.
- Connect into the Discourse container as root.
- Connect to the MariaDB Database
mysql -u root -p
*enter your password*
update mysql.user set plugin = 'mysql_native_password' where User='root';
FLUSH PRIVILEGES;
EXIT;
Then switch to the discourse user and try to connect to the database with the root account:
su discourse
mysql -u root -p
Enter password: #password1234
And you should see the SQL shell, when before you were getting an access denied.
Now exit the discourse user and try to run the migration script again:
exit
su discourse -c 'bundle exec ruby script/import_scripts/vbulletin5.rb'
Now the script is running (but I am getting a vBulletin5 related error I have to figure out next)