MySQL. Install MySQL (Windows)
Author Nigel Rivett
Find an install package download site
Here there are two versions. A web installer (20 MB) and Community installer (500 MB).
The web installer retrieves downloades when needed. The community installer is a self contained package.
I would advise the Community installer to keep a record of the installation.
The file will be something like mysql-installer-community-220.127.116.11.msi
Copy this file into a folder. I have a folder called Install for all my downloaded installation software.
Install the product
Double click on the downloaded file
Choose the Developer Default installation
There may be some connectors unavailable depending on your installed products. Ignore this, it can be resilved later if needed.
Click on execute to instal.
Configure the product
Choose Standalone MySQL server
Select a password.
Add a DBAdmin user with password
Windows service - advise not starting automatically at startup, start and stop this manually.
Do not configure the router
Check the DBAdmin user you added earlier
The installer will then complete the installation and add some sample databases
On completion the server will be started and the workbench will be loaded
Using the product
From the worknech load window:
Add a new connection with the DBAdmin user and test the connection.
Click on tyhe connection and the query window will be opened.
Test the system - execute select * from information_schema.tables
Note: In MySQL a database is a Schema so these will return data from the same source
select * from information_schema.schemata
Create a database and table
Create database Test
create table Test1 (s varchar(20), i int, d datetime default current_timestamp)
insert Test1 (s,i) select 'me',1
select * from Test1
# s, i, d
'me', '1', '2019-11-02 20:20:29'