Donate to support site

MySQL. Install MySQL (Windows)
Author Nigel Rivett

Find an install package download site
	e.g. https://dev.mysql.com/downloads/installer/
	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-
	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
			show databases
	Create a database and table
		Create database Test
		use 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'