Hi there! It sounds like you're experiencing an issue with adding data on localhost, and the error is related to password sharing. For a more detailed solution, please visit the following page: stackoverflow.com/questions/17975120/access-denied-for-user-rootlocalhost-using-password-yes-no-privileges. I hope you find the information helpful! If you have any further questions, feel free to ask.
OK! You need to install MySQL database server in your system. It's easy. You can find many videos on UA-cam "how to install MySQL server in Windows/Linux/Mac". After installing, you need to set a username and create a database and a table. Everything you'll find on UA-cam.
@@PARTHXD If you've installed MySQL server perfectly and set the root password also, then, you need to follow these steps: 1. Login to the MySQL Server: "mysql -u root -p" then type the root password you've set when you was installing the MySQL server, 2. "create database student_manager" 3. "use student_manager" 4. "create table student_register( f_name VARCHAR(50) NOT NULL, l_name VARCHAR(50) NOT NULL, course VARCHAR(30) NOT NULL, subject VARCHAR(50) NOT NULL, year Int(10) NOT NULL, age Int(10) NOT NULL, gender char(10) NOT NULL, birth DATE NOT NULL, contact VARCHAR(15) NOT NULL, email VARCHAR(100) NOT NULL, PRIMARY KEY ( contact ) );" After completing this task, you need to place your MySQL username and the password into the credentials.py file of the main project file.
Python modules are reusable collections of code that contain functions, classes, and variables, designed to perform specific tasks or provide certain functionality. The project directory holds three Python files, namely `main.py`, `custom.py`, and `credentials.py`, which can also be referred to as modules. The `main.py` file, responsible for the program's execution, incorporates various third-party modules, each serving a distinct purpose. Here is the project details also with the Source Code: pyseek.blogspot.com/2022/03/student-management-system-project-in-python.html
☛Source Code: pyseek.blogspot.com/2022/03/student-management-system-project-in-python.html
good work buddy
very good and clear thinks
Good information
Can you please share result and conclusions of the project
Here is the complete article: pyseek.blogspot.com/2022/03/student-management-system-project-in-python.html
please help ..
at last while we are adding data it is showing as cannot add the data local host password sharing is yes...
something in that way
Hi there! It sounds like you're experiencing an issue with adding data on localhost, and the error is related to password sharing. For a more detailed solution, please visit the following page: stackoverflow.com/questions/17975120/access-denied-for-user-rootlocalhost-using-password-yes-no-privileges.
I hope you find the information helpful! If you have any further questions, feel free to ask.
Sir this code can be run on vs code
How do I connect database and my code because whenever I try to run my code it says can't connect to database
OK!
You need to install MySQL database server in your system. It's easy. You can find many videos on UA-cam "how to install MySQL server in Windows/Linux/Mac".
After installing, you need to set a username and create a database and a table. Everything you'll find on UA-cam.
Make sure you create the database and table as per mentioned in the project file.
@@pyseek yeah I installed mysql through cmd but how do i create database in cmd commands won't work in cmd
Please don't be hesitate to let me know if you get any trouble in future. I'll reply to you soon.
@@PARTHXD If you've installed MySQL server perfectly and set the root password also, then, you need to follow these steps: 1. Login to the MySQL Server: "mysql -u root -p" then type the root password you've set when you was installing the MySQL server,
2. "create database student_manager"
3. "use student_manager"
4. "create table student_register(
f_name VARCHAR(50) NOT NULL,
l_name VARCHAR(50) NOT NULL,
course VARCHAR(30) NOT NULL,
subject VARCHAR(50) NOT NULL,
year Int(10) NOT NULL,
age Int(10) NOT NULL,
gender char(10) NOT NULL,
birth DATE NOT NULL,
contact VARCHAR(15) NOT NULL,
email VARCHAR(100) NOT NULL,
PRIMARY KEY ( contact )
);"
After completing this task, you need to place your MySQL username and the password into the credentials.py file of the main project file.
How to implement client server architecture. Like one is admin & other is employee then how to connect them in the same network.
It's completely different topic. You need to build a web based application for this.
can i use this code for class 12 IP project ??
Of course, you can and if you need any further assistance, let me know.
I run this code but they give an error no module named pymysql
Have you installed 'pymysql'?
Yes sir
What can I do now
@@dipalikashid7025 send me the screenshot of the error message at contact@pyseek.com
@@dipalikashid7025 Don’t worry, I will guide you
Sir i dont know how to connect to pymysql 😿
Read this article: pyseek.com/2021/01/how-to-connect-python-with-mysql-server/
How many python modules are there in this source code? What are they??
Python modules are reusable collections of code that contain functions, classes, and variables, designed to perform specific tasks or provide certain functionality.
The project directory holds three Python files, namely `main.py`, `custom.py`, and `credentials.py`, which can also be referred to as modules. The `main.py` file, responsible for the program's execution, incorporates various third-party modules, each serving a distinct purpose.
Here is the project details also with the Source Code: pyseek.blogspot.com/2022/03/student-management-system-project-in-python.html
How do i convert this into an application/webapp where anyone can access and use this
With admin having more control and users only the necessary ones
To do so, you have to have a server where you can create your database to manage admin login and all the related task.