Programming/MySQL - Revision history

Brodriguez: Correct link

2020-11-20T06:58:06Z

Correct link

← Older revision		Revision as of 06:58, 20 November 2020
Line 1:		Line 1:
	[[https://www.mysql.com/ MySQL]] is an open source database management system.		[https://www.mysql.com/ MySQL] is an open source database management system.

	It is one of the most commonly used database systems, designed to work with the SQL standard.		It is one of the most commonly used database systems, designed to work with the SQL standard.

Brodriguez: Update links

2020-11-20T06:57:34Z

Update links

← Older revision		Revision as of 06:57, 20 November 2020
Line 6:		Line 6:

	== Setup ==		== Setup ==
	* [[Programming/MySQL/Setup]]		* [[Programming/MySQL/Setup \| Setup]]

	== Syntax ==		== Syntax ==
	* [[Programming/MySQL/Databases]]		* [[Programming/MySQL/Databases \| Databases]]
	* [[MySQL/Queries]]		* [[MySQL/Queries \| Queries]]

Brodriguez: Move basic "shell access" to this page

2020-11-20T05:49:32Z

Move basic "shell access" to this page

← Older revision		Revision as of 05:49, 20 November 2020
Line 11:		Line 11:
	* [[Programming/MySQL/Databases]]		* [[Programming/MySQL/Databases]]
	* [[MySQL/Queries]]		* [[MySQL/Queries]]


			== Basics ==
			=== Accessing the MySQL Shell ===
			You can access the MySQL server from a terminal via the MySQL shell.

			If you have a fresh install with no setup yet, then this is likely done via:
			sudo mysql

			If you have done some setup, such as setting a password for the root account or creating a user to login with, then use:
			mysql -u <username> -p

			=== Exiting the MySQL Shell ===
			exit

			or
			\q

Brodriguez: Update links

2020-11-03T00:29:41Z

Update links

← Older revision		Revision as of 00:29, 3 November 2020
Line 6:		Line 6:

	== Setup ==		== Setup ==
	* [[MySQL/Setup]]		* [[Programming/MySQL/Setup]]

	== Syntax ==		== Syntax ==
	* [[MySQL/Databases]]		* [[Programming/MySQL/Databases]]
	* [[MySQL/Queries]]		* [[MySQL/Queries]]

Brodriguez: Export content to sub-pages

2020-11-02T20:36:22Z

Export content to sub-pages

← Older revision		Revision as of 20:36, 2 November 2020
Line 11:		Line 11:
	* [[MySQL/Databases]]		* [[MySQL/Databases]]
	* [[MySQL/Queries]]		* [[MySQL/Queries]]



	~~== Installation ==~~

	~~=== Ubuntu ===~~
	~~Basic installation can be performed with:~~
	~~{{ bc \| sudo apt install mysql-server }}~~

	~~From here, you can access MySQL via:~~
	~~{{ bc \| sudo mysql }}~~

	~~==== Securing the Installation ====~~
	~~Note that the above command alone is an insecure installation, and is not suitable for things like production, or instances where stored data is not just test data and thus should be stored securely.~~

	~~To configure MySQL for security also run:~~
	~~{{ bc \| sudo mysql_secure_installation }}~~


	~~== The MySQL Shell ==~~
	~~You can access the MySQL server from a terminal via the MySQL shell.~~

	~~If you have a fresh install with no setup yet, then this is likely done via {{ ic \|sudo mysql}}.~~

	~~If you have done some setup, such as setting a password for the root account or creating a user to login with, then use {{ ic \|mysql -u <username> -p}}.~~


	~~== User Accounts ==~~

	~~=== Connecting as Root ===~~
	~~{{ Warn \| Note that this is not recommended for any instances when the database should be secure. Use this only for development and testing instances, where security of data does not matter. }}~~


	For previous versions of MySQL, it was standard to default the root user as a login user with a password of {{ ic \|root}}. This is no longer the default, but can easily be set with a few commands. First, enter the MySQL shell. Then enter:
	~~{{ bc \| ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; }}~~
	* This will set the root user's password to "root".
	* Alternatively, alter the password to whatever you desire, if you want to add a tiny bit more security (setting root as a login-able password user is still not very recommended for security reasons).
	~~{{ bc \| FLUSH PRIVILEGES; }}~~
	* This ensures that changes will propagate through the server without a reboot.


	~~Once set, the {{ ic \|sudo mysql}} command will likely no longer work. Instead, login with root as {{ ic \| mysql -u root -p}}.~~

	~~=== Adding a New User Account ===~~
	~~Add a new user account with:~~
	~~{{ bc \| CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>'; }}~~

	~~Where {{ ic \|<username>}} and {{ic \|<password>}} are replaced by the desired username and password for the user account.~~


	~~=== User Permissions ===~~
	Once created, a user account needs to be given permission in order to be useful at all. Note that, from a security standpoint, it's always best to give the minimum possible permissions necessary for the user to do their job.

	~~==== Full Permissions ====~~
	~~{{ Warn \| Note that this is not recommended for any instances when the database should be secure. Use this only for development and testing instances, where security of data does not matter. }}~~

	~~To give a user full permissions (like the root account), launch the MySQL Shell, then run:~~
	~~{{ bc \| GRANT ALL PRIVILEGES ON . TO '<username>'@'localhost' WITH GRANT OPTION; }}~~
	* Where {{ ic \| username}} is replaced by the name of the user account to adjust.
	~~{{ bc \| FLUSH PRIVILEGES; }}~~
	* This ensures that changes will propagate through the server without a reboot.


	~~== Databases ==~~
	~~MySQL splits things up into individual "databases". Generally speaking, each database is a cohesive, separate project.~~

	~~=== Creating a New Database ===~~
	~~From the MySQL Shell:~~
	~~{{ bc \| CREATE DATABASE <database_name>; }}~~
	* Where {{ ic \|<database_name>}} is replaced by the desired name for the database. Must be unique from all other existing databases in the MySQL server.

	~~To specify the database character set:~~
	~~{{ bc \| CREATE DATABASE <database_name> DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_general_ci; }}~~
	~~Note that <code>utf8mb4</code> is the preferred character set for most situations. See [https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434 this link] for details.~~

	~~=== Loading a Database ===~~
	~~From the MySQL Shell:~~
	~~{{ bc \| USE <database_name>; }}~~
	* Where {{ ic \|<database_name>}} is replaced by the name of database you wish to select/load.
	* Note that only one database can be selected/loaded at a time.

	~~=== Deleting a Database ===~~
	~~From the MySQL Shell:~~
	~~{{ bc \| DROP DATABASE <database_name>; }}~~
	* Where {{ ic \|<database_name>}} is replaced by the name of the database to delete. Note that this action cannot be undone.


	~~== Database Commands ==~~
	~~The following commands will apply to whatever database is currently selected/loaded.~~
	~~{{ ToDo \| Document commands }}~~

Brodriguez: Update page format

2020-11-02T20:32:26Z

Update page format

← Older revision		Revision as of 20:32, 2 November 2020
Line 1:		Line 1:
			[[https://www.mysql.com/ MySQL]] is an open source database management system.

			It is one of the most commonly used database systems, designed to work with the SQL standard.

			Alternatives are [[Programming/MariaDB \| MariaDB]] and [[Programming/PostgreSQL \| PostgreSQL]].

			== Setup ==
			* [[MySQL/Setup]]

			== Syntax ==
			* [[MySQL/Databases]]
			* [[MySQL/Queries]]



	== Installation ==		== Installation ==

Brodriguez: Brodriguez moved page MySQL to Programming/MySQL

2020-10-25T17:27:32Z

Brodriguez moved page MySQL to Programming/MySQL

← Older revision

Revision as of 17:27, 25 October 2020

Brodriguez: Add character set command

2020-09-25T03:03:27Z

Add character set command

← Older revision		Revision as of 03:03, 25 September 2020
Line 67:		Line 67:
	{{ bc \| CREATE DATABASE <database_name>; }}		{{ bc \| CREATE DATABASE <database_name>; }}
	* Where {{ ic \|<database_name>}} is replaced by the desired name for the database. Must be unique from all other existing databases in the MySQL server.		* Where {{ ic \|<database_name>}} is replaced by the desired name for the database. Must be unique from all other existing databases in the MySQL server.

			To specify the database character set:
			{{ bc \| CREATE DATABASE <database_name> DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_general_ci; }}
			Note that <code>utf8mb4</code> is the preferred character set for most situations. See [https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434 this link] for details.

	=== Loading a Database ===		=== Loading a Database ===

Brodriguez: Add todo

2020-07-04T23:33:52Z

Add todo

← Older revision		Revision as of 23:33, 4 July 2020
Line 82:		Line 82:
	== Database Commands ==		== Database Commands ==
	The following commands will apply to whatever database is currently selected/loaded.		The following commands will apply to whatever database is currently selected/loaded.
			{{ ToDo \| Document commands }}

Brodriguez: Document core database commands

2020-07-04T23:32:50Z

Document core database commands

@@ Line 44: / Line 44: @@
 {{ bc | CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>'; }}
-Where {{ ic |username}} and {{ic |password}} are replaced by the desired username and password for the user account.
+Where {{ ic |<username>}} and {{ic |<password>}} are replaced by the desired username and password for the user account.
@@ Line 58: / Line 58: @@
 {{ bc | FLUSH PRIVILEGES; }}
 * This ensures that changes will propagate through the server without a reboot.