Login Page Linked With Signup Page: User Registration with MySQL | Python Tkinter GUI Project

Hey everyone, in this video you will learn how to store the user data from the sign-up page in the MySQL database.
In this project login and sign-up pages are linked with each other.
Here MySQL database is used to store the user data which the user will enter during sign up and with the help of that data user will be able to log in and change the password.
Watch how to download & Install MySQL database:
kzbin.info/www/bejne/bKnWZ2Cbmsx8fqM
Source Code:
faizan-er.myinstamojo.com/product/4085563/python-with-mysql-login-page-linked-with-sig/
Project Images: drive.google.com/drive/folders/15gBQsqOfGPpTKlK7UPxiTUhe815dCYq1?usp=sharing
Time Stamp:
(00:00:00) Intro
(00:04:35) download mysql
(00:04:52) install pymysql
(00:06:36) connect database
(00:17:19) creating database
(00:25:52) inserting data in database
(00:38:20) Ending
Terms related to this video:
login page using tkinter python
login page using tkinter in python
login page using tkinter github
signup page using tkinter
simple login page using tkinter
how to make login page in tkinter
login app using python
login form using python
how to create signin form using tkinter
how to create a registration form using python
login page python
python login page
python mysql
mysql project using python
Tags:
#loginpage #pythonmysql #pythonguiproject #pythontkinter #tkinterproject
★★★ Subscribe ★★★
kzbin.info/door/G6ztZE3zK2aZeJZKnvohkg
★★★ Follow ★★★
coding_lifestyle_4u
Thanks for watching.
Please Like, Subscribe & Share.
Stay tuned for upcoming projects 🙂

[@kalh-tg9wb]

thanks too much brother , note to those people who may get my errors : if i delete the table and try the code i got error says that table not exist , for that i changed the position of the code of creation the table to exception part and added '' IF NOT EXISTS " ,to not get an other error that says : 'table is already exists'

[@Sresta_Edits]

Brother I got some errors, whenever I entered the details in signup page it displays some errors like raise_for_error,raise_for_exception ,_read_packet

[@techievinod]

Very Informative

[@codinglifestyle4u]

Thanks 😊

[@gyampohenoch7529]

I have finally completed this project. Thanks very much

[@codinglifestyle4u]

Ur welcome

[@mansisharma6671]

Hey help me out with the connection to MySQL ...

[@codinglifestyle4u]

Ping me on instagram coding_lifestyle_4u

[@mansisharma6671]

@@codinglifestyle4u do u have telegram I don't use Instagram

[@chiedoziechibueze2885]

Pls can make a video on how to create the database from snatch..pls

[@anisbasyirah9586]

can it still works if i share the applications to the other users ?

[@codewithraj_690]

When I have run command pip install pymysql I am getting an error New connection error How can I fix it sir please reply fast I need this system for my website 🙏🙏🙏🙏🙏🙏🙏

[@harshitgupta2418]

Hi , I make a page consisting a button and give the command to open a new page without destroying the previous page it works but when I add image in second page and try to open it by first page without destroying first , then it doesn't show me that image that I add to second page But when I run the second page Individually it works properly and also shows that image which i add to it can you please help me to solve this problem

[@codinglifestyle4u]

Can u send me the pic on instagram coding_lifestyle_4u

[@naufalfadrians1384]

hai codinglifestyle. How do i connect the database via xampp, not mysql 8.0 command line client. I hope you respond to my response

[@codinglifestyle4u]

Please watch the tutorial on how to connect database via xampp

[@badgood8477]

if anyone is getting issue with connecting mysql database with python . You can try connecting the database with another method using 'mysql connector' method. You can refer youtube video of 'Tech with tim youtube channel' ..... video name is 'Python Mysql tutorial'.

[@codinglifestyle4u]

Thanks 👍

[@Universe18423]

mycursor.execute(query,(userentry.get())) in this what is happening? str(ashakarthikeyan), it must be of type list, tuple or dict Im getting this error

[@study_bros]

What did u do bro? I also got same error

[@shyamrajkhowa7067]

Did it get solve?

[@Universe18423]

@@shyamrajkhowa7067 yep

[@supriya__03]

At last 5 min you said about an error message that if username already existed in our database then it should show error that it has already existed. How can i set the error message like email already existed along with username existed condition error msg condition. Elif is not working for that.

[@codinglifestyle4u]

Ping me on instagram coding_lifetystyle_4u

[@umarameen5572]

Sir is it show the error when we do code in idle ? Bcz it’s throwing a error in the function def connect_database(): As object has no attribute get

[@codinglifestyle4u]

No it wont show error in idle, you must be making a mistake please rewatch that part

[@umarameen5572]

@@codinglifestyle4u ni bro everything is writing get function only is not working

[@safarsafarov2968]

Hi. Why u do not use MySQL work bench instead of Command line?

[@codinglifestyle4u]

U can use that too

[@prakashsachan2595]

sir i m facing error in python idle mysql.connector.errors.ProgrammingError: Could not process parameters: str(prakash), it must be of type list, tuple or dict

[@codinglifestyle4u]

Rewatch that part again and see if you are doing it correctly

[@prakashsachan2595]

@@codinglifestyle4u sir error is resolved i was using " mycursor.execute(query,(usernameEntry.get())) " this but now i used [ ] instead of ( ) " mycursor.execute(query,[usernameEntry.get()]) " but Thank you sir..

[@study_bros]

​@@prakashsachan2595bro if your code is crt ,can you please share here? SIGNUP!

[@raghavendrakudari5017]

Can we not switch over to windows multiple times by using destroy method?

[@codinglifestyle4u]

Yes please try to find the solution For this

[@GoDnCRAFT]

for that you'll have to overlap the windows this method is much convinient

[@priyaveeran]

Getting error of pymysql . Programming Error:(1146,"Table 'pd.pd' doesn't exist") Please help me out from this issue asap Thanks.

[@codinglifestyle4u]

Make sure you are using the correct table name and the table exists in the database

[@DR-ke3sd]

I had this issue too. Make the table separately in another python program and it should work

[@nitronjoe6233]

I had this issue - had to drop the drop the database 'userdata' in MySQL workbench then when I ran the code and it recreated the database it could then create the table fine.

[@chiedoziechibueze2885]

Pls have created all GUI and install database but I know how to create the database

[@codinglifestyle4u]

Please watch the tutorial and follow the steps

[@krajeshwari6799]

Bro I have a error pymysql.err.ProgrammingError: (1146, "Table 'sr.asr' doesn't exist")

[@codinglifestyle4u]

Please check the code you are making mistake

[@josleck]

Exactly the same error I had, how did you rectify it please?

[@krajeshwari6799]

Bro we are doing a project banking system pls help me to save transaction history in database please bro

[@codinglifestyle4u]

Please learn how to store the data there from google or youtube

[@danieljohncanedacatudio5072]

Hi Coding Lifestyle, may I ask a favor please? Can you please recreate this program or at least the part where you connect your python to MySQL, but this time please, use PostgreSQL database please?

[@codinglifestyle4u]

Sure

[@danieljohncanedacatudio5072]

@@codinglifestyle4u please include the part where you use fetchone. Thank you

[@harshdeepkaur5460]

How to solve the "connectivity issue" in sing up page? Nd the data base is not shown in mysql command line client how to resolve it?

[@codinglifestyle4u]

Open mysql workbench once before running the code Recreate the database and table at once and then run the code

[@codinglifestyle4u]

Can you show me if there is any error on instagram coding_lifestyle_4u

[@harshdeepkaur5460]

if emailEntry.get()=='' or usernameEntry.get()=='' or passwordEntry.get()=='' or confirmEntry.get()=='': messagebox.showerror('Error','All Fields Are Required') elif passwordEntry.get() != confirmEntry.get(): messagebox.showerror('Error', 'Password Mismatch') elif check.get()==0: messagebox.showerror('Error', 'Please accept Terms & Condition') else: try: con=pymysql.connect(host='localhost',user='root',password='1234') mycursor=con.cursor() except: messagebox.showerror('Error', 'Database Connectivity Issue, Please Try Again') return try: query = 'create database userdata' mycursor.execute(query) query = 'use userdata' mycursor.execute(query) query = 'create tabel data(id int auto_increment primary key not null,email varchar(50),username varchar(100),password varchar(50))' mycursor.execute(query) ## All work has been done smoothly but after the return [create data base ] is not working properly.. Showing Error =Database Connectivity Issue, Please Try Again')

[@noons186]

@@codinglifestyle4u how to create the database and table at once exactly?

[@Jo-bf2hf]

heyyy is there a video where u use inbuilt sql lite

[@codinglifestyle4u]

Yes have a look kzbin.info/www/bejne/eaa4iWuNqMl8oK8si=zTQduLa0fvDoJ4VW

[@sankaranradhakrishnan7905]

Good morning sir Can we create separate table each email id?

[@codinglifestyle4u]

Yes you can

[@krajeshwari6799]

Or can we insert text file to sql

[@codinglifestyle4u]

Yes check on google how to do it

[@prathmeshgulhane6351]

Bro bro from where you get the eye button image of perfect

[@codinglifestyle4u]

From Flaticon website

[@prathmeshgulhane6351]

@@codinglifestyle4u thanks brother ❤

[@chetanabansal9298]

what should i do if it shows database connectivity issue

[@codinglifestyle4u]

Can U send me the issue pic on instagram coding_lifestyle_4u

[@noons186]

how did u fix it

[@chetanabansal9298]

@@noons186 it can be because of password encryption for which you have to import modules like hashlib, cryptography, credentials(in python) you should also grant permission to user from database cmd for that you search on google because i have forgotten the command😅😅 according to me this will solve the issue and also take care that you are importing right module for database you are using ( like mysql for mysql db etc) create proper cursor and check the statements thoroughly once again. i hope this will solve your issue.

[@iansibonga7428]

Why is name of database not appear

[@codinglifestyle4u]

Plz rewatch that part you must have made some mistake

[@Sresta_Edits]

How to add validation rules for email here

[@codinglifestyle4u]

import re def is_valid_email(email): # Regular expression for email validation pattern = r'^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$' # Check if the email matches the pattern if re.match(pattern, email): return True else: return False # Test the function email_to_check = "[e-mail]" if is_valid_email(email_to_check): print("Valid email!") else: print("Invalid email!")

[@Sresta_Edits]

@@codinglifestyle4u sir where I have to write this code

[@hertz-2007]

this can work for other users or just my pc ?

[@codinglifestyle4u]

For other users as well

[@priyarani8397]

Can you provide source code/??

[@codinglifestyle4u]

It will be better to watch the tutorials and build this project, source code is paid

[@Parsaycho]

The last part , Where you check for an existing Username... 34:50 This specific line: mycursor.execute(query, (usernameEntry.get())) It's crazy that you don't get a ProgrammingError. That line lacks a Comma for me: mycursor.execute(query, (usernameEntry.get(),))

[@codinglifestyle4u]

But that is fine there is no issue 😀

[@garikas_777]

thank you very much!

[@mansisharma6671]

Plzz help me with databasee connectivity

[@codinglifestyle4u]

Ping me on instagram coding_lifestyle_4u

[@mannysokhi4203]

I am getting a database connectivity issue and do not know how to fix it

[@codinglifestyle4u]

What is the error?

[@mannysokhi4203]

@@codinglifestyle4u i have fixed it dont worry.

[@akhilanaidu348]

@@mannysokhi4203 can u help me to resolve this...

[@codinglifestyle4u]

Send me the error pic on instagram coding_lifestyle_4u

[@akhilanaidu348]

@@codinglifestyle4u yes i have sent it can you go through it...

[@aniebueisaac2125]

I want start the project

[@codinglifestyle4u]

Ok go ahead and start

[@akhilanaidu348]

Getting database connectivity issue, please try again... how to resolve it please help

[@codinglifestyle4u]

I hope it is fixed

[@aishwaryasutar289]

Have you solved this issue?

[@jeyasmakeover6252]

Same error how can i solve it

[@codinglifestyle4u]

Open mysql workspace once and then again try to run the code

[@noons186]

@@codinglifestyle4u what do you mean i opened my workbench but still? do i have to make something on the workbench

[@saranyakrishna2094]

How to clear the error in mysql Show tables; Empty set (0.00 sec)

[@codinglifestyle4u]

Recreate the new database and table at once and then rerun the code

[@saranyakrishna2094]

Yes I got it

[@saranyakrishna2094]

It's working

[@codinglifestyle4u]

What was the error?

[@saranyakrishna2094]

@@codinglifestyle4u after sign up Error 1054 unknown column password in field list

[@shyamrajkhowa7067]

31:00 after clicking the signup button, 🚫 no dialog box appears; 🚫 Entry field not get cleared; 🏳️ Database and table created, but with 0 table data. And, since I was executing the .py file through command prompt, it displays an exception like below 👇🏻 TypeError: 'str' object is not callable Please 🙏 help with this code Sir

[@shyamrajkhowa7067]

At last, I have found out the error. I forgot to put coma after query.. i.e. line number 39 on 31:36.

[@codinglifestyle4u]

Ok

[@FirstNameLastName-fv4eu]

hahahah hardcoding the password!!

[@codinglifestyle4u]

Where?

[@krajeshwari6799]

Bro source code please

[@codinglifestyle4u]

Please watch the tutorials and build it

[@krajeshwari6799]

Ok bro

[@ayodhyaramanhari7419]

mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%s' at line 1

[@codinglifestyle4u]

The error is clear that you have done mistake in sql syntax please rewatch that part once again.

[@GuestGorebox]

Help. I get these errors when trying to sign up: Exception in Tkinter callback Traceback (most recent call last): File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.1264.0_x64__qbz5n2kfra8p0\Lib\tkinter\__init__.py", line 1948, in __call__ return self.func(*args) ^^^^^^^^^^^^^^^^ File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\signup.py", line 42, in connect_database mycusrsor.execute(query,(email_Entry.get(),username_Entry.get(),password_Entry.get())) File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\cursors.py", line 153, in execute result = self._query(query) ^^^^^^^^^^^^^^^^^^ File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\cursors.py", line 322, in _query conn.query(q) File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 558, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 822, in _read_query_result result.read() File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 1200, in read first_packet = self.connection._read_packet() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\connections.py", line 772, in _read_packet packet.raise_for_error() File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "C:\Users\maksi\PycharmProjects\pythonProject\HelloWorld\venv\Lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'userdata.data' doesn't exist")

[@GuestGorebox]

now it only says connectivity issue please try again it wont fix

[@GuestGorebox]

i fixed it

[@codinglifestyle4u]

Ok great

[@pravarmishra7192]

how did you fix db connectivity error issue

[@Sresta_Edits]

@@GuestGorebox how to fix it , could you please help me bro ?

[@dhavalchavda160]

line 39, in connect_database mycursor.execute(query,(emailEntry.get(),usernameEntry.get(),passwordEntry.get())) line no.39->mycursor.execute(query,(emailEntry.get(),usernameEntry.get(),passwordEntry.get()))

[@shyamrajkhowa72]

Did it solve ?