Connect with database

[JunmingZhang]

Now we are trying to connect our data entry to database, so we can actually store something in the database.

[JunmingZhang]

Now I have make the basic connection (i.e., our app connects to the MySQL database), please use MySQL workbench or Navicat to check it.

To connect the database, you need to first install mysqlclient, and run

cp -r /usr/local/mysql/lib/* /usr/local/lib/

in terminal.

After that, we can begin. First, create schema and user by

mysql -u root -p < createDataBase.sql
You can find it in the sql folder. Then run python manage.py migration, now you can start the server.

[JunmingZhang]

Next step, enable table file (e.x., csv, xlsx) parsing to sql table format and upload it to database.

[WindBlowDickCool]

The authorization problem is solved.