Python-Project-ComputerScience-XII

Library Management System using Python(code) And MySQL(database)

First Thing to be done is to install python and MySQL

• Python: https://www.python.org/downloads/
• MySQL : https://dev.mysql.com/downloads/installer/

Installation Video

• Python : https://www.youtube.com/watch?v=uDbDIhR76H4
• MySQL : https://youtu.be/IqYfmckxeyE

then using command prompt run the following

1. pip install tk
2. pip install mysql-connector-python
3. open mysql in cmd by typing >mysql -u root -p(enter and enter mysql password)
4. CREATE USER 'sqluser'@'localhost' IDENTIFIED BY 'password';
5. GRANT ALL PRIVILEGES ON . TO 'sqluser'@'localhost';
6. FLUSH PRIVILEGES;
7. exit (twice) then start coding