[SOLVED] html Java python SQL database University of Connecticut CSE 4701 Principles of Databases

University of Connecticut CSE 4701 Principles of Databases
Computer Science and Engineering
Fall 2019 Project 2 Help
1. I forgot the password to my local MySQL Server. What do I do?
You can search online to find ways to reset password to your local MySQL server. Alternatively, if you do not have any important data in your local MySQL database, it would probably be easier to just uninstall everything and install again. You can set a new password this way.
2. Do I have to comment my codes?
Comments are NOT required throughout your program. However, it is required in any database transaction related parts of the code. Few words or a sentence should be enough to describe a function or block of code. Please try to make it comprehensive, but not too lengthy.
3. Considering our code will run on TAs machine, what would you like us to set our username and password to?
The database credentials (hostname, username, password & database name) should be easily configurable in your code. This part should be commented properly. For our convenience, you can set the following credentials in the version you submit to HuskyCT.
Hostname = localhost
Database = cse4701f19_project2 Username = root
Password =
4. Any guidance regarding how to invoke SQL from various host languages?
There are plenty of resources available online on how to use embedded SQL on various languages.
To use python refer to
https://dev.mysql.com/doc/connector-python/en/connector-python-examples.html
To use Java refer to https://www.javatpoint.com/example-to-connect-to-the-mysql-database
To use PHP refer to https://www.w3schools.com/php/php_mysql_connect.asp
5. What do I do if I cant install MySQL library in python?
There are alternate libraries to connect to MySQL database. You can use any other library that you can find online. One example is PyMySQL available here. https://github.com/PyMySQL/PyMySQL
6. Can I use the LOCK TABLES MySQL features to lock my records?
Please refer to Deliverables Section 4(iv) of Project description document. Information on MySQL locks are available at https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
For example, see next page showing the beginning of MySQL 8.0 Reference Manual.

University of Connecticut CSE 4701 Principles of Databases Computer Science and Engineering Fall 2019 Project 2 Help
Continue reading!