# Installing SQLite3 To SQL with Python3 Package To Convert SQL-Lite DB to MySQL for import

<span style="color: rgb(0, 0, 0);">Start off with **pip3 install sqlite3-to-mysql**, making sure **apt install python3-pip** is installed. Once done, upgrade pip3 with **pip3 install --upgrade pip** then **pip3 install packaging**. You can now run **sqlite3mysql --help**.</span>

<span style="color: rgb(0, 0, 0);">For simple syntax, it is:</span>  
**<span style="color: rgb(0, 0, 0);">sqlite3mysql -f &lt;file-of-sqllitedb.db&gt; -d &lt;database-to-import-to&gt; -u &lt;sql-user-to-import-with&gt; -p</span>**

<span style="color: rgb(0, 0, 0);">When I tried using -u root, it didn’t work and said access denied even with correct password. Use a SQL user which has access to that particular database or a global admin. *No idea why.*</span>

<span style="color: rgb(0, 0, 0);">Works fairly well and have had no reports of issues.</span>

**<span style="color: rgb(0, 0, 0);">An example below:</span>**

<span style="color: rgb(0, 0, 0);">![](https://docs.jasmeow.systems/uploads/images/gallery/2024-02/fy0hobRMbkUIv0pn-embedded-image-krrsbnrr.png)</span>