Sql commands: Difference between revisions

Revision as of 00:33, 20 December 2021

SHOW DATABASES;

DROP DATABASE <database name>;

CREATE DATABASE <database name>;

CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';

Revision as of 00:31, 20 December 2021 (view source) Ractive (talk \| contribs) No edit summary ← Older edit		Revision as of 00:33, 20 December 2021 (view source) Ractive (talk \| contribs) No edit summary Newer edit →
Line 4:		Line 4:

	CREATE DATABASE <database name>;		CREATE DATABASE <database name>;

			CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';