Can anyone show how to install my SQL database on windows computer. That means where I can download my SQL database and how can I install this and what are the configurations to set up. And with the example program to test whether my SQL database working fine on my computer.
How to install my SQL database on laptop with sample program
Share
shree
These are the easiest steps to download and install mysql on your windows laptop or computer. You can download Mysql for free and installation process is pretty easy.
**My SQL – Environment Setup:
you may go to official website: mysql database server:
…………………………………………..
https://dev.mysql.com/downloads/installer/
* mysql-installer-community-8.0.36.0.ms — download
* it is free of cost
* Windows (x86, 64-bit), MSI Installer.
1. First we need to download database sql server in your system which OS your using
example: im using windows 11 64bit. see sql access error denied for user root.
2. then we gohead and here we using MySQL workbench… download Mysql sample database: https://www.mysqltutorial.org/getting-started-with-mysql/mysql-sample-database/
* Mysql user: root and password: 1234
………………..
3. download MySQL Sample DataBase like in google sample database..
* Classic Models download this database its free of cost.
4.then we have to connect our database…
5. for example connect to database and go to server DATA IMPORT and import it.
6. and first of all create database for initialisation primary set up to continue create what we download sample database classic models.
* These are basic commands to create database (* All are lowercase letters):
1. create database classic models; –(for creating database)
2. use classic models; –(this command automatically connect to specific database )
3. show tables; (show you what are all tables available)