Question: In Python 3, use the tkinter module to create an interface like the one below. It should ask the user for their username and password

In Python 3, use the tkinter module to create an interface like the one below. It should ask the user for their username and password to connect to a remote MySQL database(using pymysql) and the interface should ask the user to enter in their SQL query and then another text box that shows the results. Keep it simple, tkinter and pymysql are the only modules needed.

tk Password Enter SQL User name: ips5a Login SELECTfrom actor , 1 , , , PENELOPE , , , GUINESS , , , 2006-02-15 4: 34: 33 , 2" "NICK, WAHLBERG, 2006-02-1 04:34:33 3, "ED, "CHASE, 2006-02-15 04:34:33 4 JENNIFERDAVIS, 2096-92-15 04:34:33" . 5 . , . JOHNNY' , . LOL LOBRIGIDA , , , 2006-02-15 04: 34: 33 . '6', 'BETTE', 'NICHOLSON', '2996-92-15 4:34:33. 7GRACE "MOSTEL, 2006-02-15 04:34:33" 8, MATTHEW JOHANSSON, 2006-02-15 04:34:33 '9", "JOE', 'SWANK', "2006-02-1564:34 : 33' 10', 'CHRISTIAN GABLE2006-02-15 04:34:33 11', "ZERO, "CAGE, 2006-02-15 04:34:33 12, KARL, 'BERRY, 2006-02-15 64:34:33 13, UMA, 'WO0D, 2006-02-15 04:34:33' 14, 'VIVIEN' BERGEN, 2006-02-15 04:34:33 15', "CUBA, OLIVIER,2006-02-15 04:34:33 16', 'FRED, "COSTNER, '2006-02-15 04:34:33' 17', 'HELEN, 'VOIGHT, '2006-02-15 04:34:33' 18, DAN, TORN, "2006-02-15 84:34:33 19 BOBFAWCETT, '2006-02-15 04:34:33' 20, LUCILLETRACY,2006-02-15 04:34:33 21, 'KIRSTEN, PALTROW "2006-02-15 04:34:33' . 22' , ELVIS' , 'HARX' . . 2006-02-15 04: 34: 33' 23, "SANDRA,"KILMER, 2006-02-15 04:34:33 24, "CAMERON', STREEP, 2006-02-15 04:34:33" 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

In Python 3, use the tkinter module to create an interface like the one below(keep it simple). It should connect to a remote MySQL database using pymysql by asking the user for their username and...

In Python 3, use the tkinter module to create an interface similar to the one below. Keep it simple, it just needs to ask the user for their username and password to connect to a remote MySQL...

In Python 3, use the tkinter module to create an interface similar to the one I posted below. It should ask the user for their username and password to connect to a remote MySQL database(using...

In Python 3, use the tkinter module to create an interface similar to the one I posted below. Basically, the interface should ask for a username and password to connect to a MySQL database(using...

In Python 3, use the tkinter module to create an interface that lets the user type in a SQL command and connect to a pymysql databse and then return the results of the query in the interface....

In Python 3, use the tkinter module to create a GUI that asks the user for their username and password to connect to a pymysql database. The GUI should have a text box to let the user type in a SQL...

This assignment involves the use of GUI widgets to create an OOP/Event-driven program. With Python 3. Use the tkinter module to write a program that calculates a cars gas mileage. The programs window...

Background Information This assignment tests your understanding of and ability to apply the programming concepts we have covered throughout the unit. The concepts covered in the second half of the...

Competencies In this project, you will demonstrate your mastery of the following competencies: Apply database systems concepts and principles in the development of a client/server application Create...

1. In the cloning procedure we used in the lab, it is possible, albeit unlikely, for multiple inserts to form a concatamer and be cloned into a single expression vector. If three egfp inserts were...

13. Consider a null hypothesis stating that the population mean is equal to 52, with the research hypothesis that the population mean isn't equal to 52. Assume you've collected 38 sample data from...

Income Statement TeaTime.com Income Statement Year Ended December 31, 2012 Cash Flow Sales Revenue ($20/box x 324 boxes per month) $77,760 Cost of Goods Sold ($8/box x 324 boxes per month) ($31,104)...

a. Compute the acid-test ratio for each of the separate cases above. b. Which company is in the best position to meet short-term obligations? Complete this question by entering your answers in the...

2. What do threats to validity have to do with training evaluation? Identify internal and external threats to validity. Are internal and external threats similar? Explain.

3. What are the strengths and weaknesses of each of the following designs: posttest-only, pretest/posttest with comparison group, and pretest/posttest only?

4. Trainees and their managers provide estimates of training benefits.