CRUD-GUI-Simple-With-Python

Screenshoot Project

Tools yang digunakan

1. Visual Studio Code
   
2. QTdesigner

Bahasa: Python
Library
1. Pymysql
2. xlsxwriter
3. mysql-connector

How to install QtDesigner tool on ubuntu/ linux PyQt5

• pip3 install --user pyqt5
• sudo apt-get install python3-pyqt5
• sudo apt-get install pyqt5-dev-tools
• sudo apt-get install qttools5-dev-tools

Install beberapa library

pip3 install pymysql
pip3 install xlsxwriter
pip3 install mysql-connector

How to install MYSQL on ubuntu 20.04

1. sudo apt update

2. sudo apt upgrade

3. sudo apt install mysql-server

4. check mysql version mysql --version

5. sudo mysql_secure_installation

Securing the MySQL server deployment. Connecting to MySQL using a blank password. VALIDATE PASSWORD COMPONENT can be used to test passwords and improve security. It checks the strength of password and allows the users to set only those passwords which are secure enough. Would you like to setup VALIDATE PASSWORD component?

Press y| Y for Yes, any other key for No: y

These are three levels of password validation policy:

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 0 Please set the password for root here.

New password: Re-enter new password:

Estimated strength of the password: 0

Do you wish to continue with the password provided? : y Remove anonymous users?: y Disallow root login remotely?: y Remove test database and access to it?: y Reload privalege tables now?: y

All done!

ACCESS MYSQL

1. sudo mysql -u root
2. mysql> show databases;
3. mysql> create database namadatabase;
4. mysql> show databases;
5. mysql> quit
6. ENJOYYYYYY :)

THANK YOU