# Issue for q2a import

**URL:** <https://meta.discourse.org/t/issue-for-q2a-import/128529>\
**Category:** Migration\
**Created:** [September 14, 2019, 12:13am UTC](https://meta.discourse.org/t/issue-for-q2a-import/128529 "2019-09-14T00:13:58Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![INSTAR](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/instar/32/359540_2.png) [@INSTAR](https://meta.discourse.org/u/INSTAR)\
**Post date:** [October 31, 2019, 12:19pm UTC](https://meta.discourse.org/t/issue-for-q2a-import/128529/7 "2019-10-31T12:19:18Z")

</div>

Ok I am now a step closer into getting this to work. I was able to get the discourse user to connect.

1. Connect into the Discourse container as root.
2. Connect to the MariaDB Database

```plaintext
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:

```plaintext
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:

```plaintext
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)

---

_[View the full topic](https://meta.discourse.org/t/issue-for-q2a-import/128529)._