MySQL - Revision history

Tinker: /* Notes about accessing the database remotely */

2022-12-03T07:18:44Z

Notes about accessing the database remotely

← Older revision		Revision as of 03:18, 3 December 2022
Line 93:		Line 93:

	bind-address = 000.000.000.000		bind-address = 000.000.000.000
			Where '''000.000.000.000''' can either be left as is or replaced with the actual IP of the server OR the '''FQDN''' of the server.

	(replacing the bind-address line that might already be there...)<br>		(replacing the bind-address line that might already be there...)<br>
			<span style="color: rgb(185, 106, 217);">(TGON needs to remind me to update this page with a thing about setting up user access...)</span>
	<span style="color: rgb(185, 106, 217);" >(TGON needs to remind me to update this page with a thing about setting up user access...)</span>

	On the remote machine(s), it'll be handy to install <code>mysql-client</code> (at minimum, for testing...).		On the remote machine(s), it'll be handy to install <code>mysql-client</code> (at minimum, for testing...).

Tinker: /* Notes about accessing the database remotely */

2022-12-03T07:00:19Z

Notes about accessing the database remotely

← Older revision		Revision as of 03:00, 3 December 2022
Line 90:		Line 90:

	* <code>sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf</code>		* <code>sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf</code>

	and add in the line:		and add in the line:

	bind-address = 000.000.000.000		bind-address = 000.000.000.000
	(replacing the bind-address line that might already be there...)<br>		(replacing the bind-address line that might already be there...)<br>

			<span style="color: rgb(185, 106, 217);" >(TGON needs to remind me to update this page with a thing about setting up user access...)</span>

	On the remote machine(s), it'll be handy to install <code>mysql-client</code> (at minimum, for testing...).		On the remote machine(s), it'll be handy to install <code>mysql-client</code> (at minimum, for testing...).

Tinker: /* Notes about accessing the database remotely */

2022-01-28T05:36:50Z

Notes about accessing the database remotely

← Older revision		Revision as of 01:36, 28 January 2022
Line 93:		Line 93:
	and add in the line:		and add in the line:

	bind-address = 0.0.0.0		bind-address = 000.000.000.000
	(replacing the bind-address line that might already be there...)<br>		(replacing the bind-address line that might already be there...)<br>

Tinker: /* Notes about accessing the database remotely */

2022-01-28T05:35:45Z

Notes about accessing the database remotely

← Older revision		Revision as of 01:35, 28 January 2022
Line 86:		Line 86:

	If this is a Database server, you'll be doing the user setup again but replacing '''localhost''' with '''MachineName''' (where '''MachineName''' is the name of any remote machines that need access to your databases).		If this is a Database server, you'll be doing the user setup again but replacing '''localhost''' with '''MachineName''' (where '''MachineName''' is the name of any remote machines that need access to your databases).

			You'll also need to tell mySQL to bind to the actual network interface (or a wildcard "'''*'''").

			* <code>sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf</code>

			and add in the line:

			bind-address = 0.0.0.0
			(replacing the bind-address line that might already be there...)<br>

	On the remote machine(s), it'll be handy to install <code>mysql-client</code> (at minimum, for testing...).		On the remote machine(s), it'll be handy to install <code>mysql-client</code> (at minimum, for testing...).

Tinker: /* Notes about accessing the database remotely */

2022-01-28T05:30:24Z

Notes about accessing the database remotely

← Older revision		Revision as of 01:30, 28 January 2022
Line 95:		Line 95:
	On systems with '''mySQL''' in the repositories:		On systems with '''mySQL''' in the repositories:
	* <code>sudo apt install mysql-client</code>		* <code>sudo apt install mysql-client</code>
			Either way, the command to access your database is:
			* <code>mysql -h '''DatabaseServer''' -u '''USERNAME''' -p</code> <code></code>
	[[Category:ServerBuilding]]		[[Category:ServerBuilding]]
	[[Category:WebServers]]		[[Category:WebServers]]
	[[Category:DBServers]]		[[Category:DBServers]]

Tinker: /* Set up at least one user in mysql */

2022-01-28T05:27:41Z

Set up at least one user in mysql

← Older revision		Revision as of 01:27, 28 January 2022
Line 81:		Line 81:
	('''Hint:''' This'd be a good time to create yourself as that user with your non-admin password of choice...)		('''Hint:''' This'd be a good time to create yourself as that user with your non-admin password of choice...)

	~~If this is a Database server~~, ~~you'll be doing the same again but replacing '''localhost''' with~~ '''~~MachineName~~''' ~~(where '''MachineName''' is the name of any remote machines that need access to your databases).~~		<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>

			= Notes about accessing the database remotely =

	<~~span style="color: rgb~~(~~255~~, ~~0, 0~~);">'''~~[[Now Do A Backup!{{!}}Now Do A Backup!]]~~'''</~~span~~>		If this is a Database server, you'll be doing the user setup again but replacing '''localhost''' with '''MachineName''' (where '''MachineName''' is the name of any remote machines that need access to your databases).

			On the remote machine(s), it'll be handy to install <code>mysql-client</code> (at minimum, for testing...).

			On Debian:
			* <code>sudo apt install default-mysql-client</code>
			(which gets you the '''MariaDB''' version, but it works just fine.

			On systems with '''mySQL''' in the repositories:
			* <code>sudo apt install mysql-client</code>

	[[Category:ServerBuilding]]		[[Category:ServerBuilding]]
	[[Category:WebServers]]		[[Category:WebServers]]
	[[Category:DBServers]]		[[Category:DBServers]]

Tinker: /* MySQL on Debian */

2022-01-28T04:57:32Z

MySQL on Debian

← Older revision		Revision as of 00:57, 28 January 2022
Line 46:		Line 46:
	Now you can go ahead & pretend they haven't dropped MySQL from the Debian repos...		Now you can go ahead & pretend they haven't dropped MySQL from the Debian repos...

	* <code>sudo apt install mysql-server mysql-client ~~php-mysql~~</code>		* <code>sudo apt install mysql-server mysql-client</code>

	<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>		<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>

Tinker: /* MySQL on Debian */

2022-01-28T04:56:35Z

MySQL on Debian

← Older revision		Revision as of 00:56, 28 January 2022
Line 40:		Line 40:
	*I tend to select '''Use Legacy Authentication Method''' because '''Use Strong Password Encryption''' is annoying as hell. (Your choice here...)		*I tend to select '''Use Legacy Authentication Method''' because '''Use Strong Password Encryption''' is annoying as hell. (Your choice here...)
	Update & Upgrade everything now...		Update & Upgrade everything now...

	* <code>sudo apt update</code>		* <code>sudo apt update</code>
	* <code>sudo apt upgrade</code>		* <code>sudo apt upgrade</code>

	Now you can go ahead & pretend they haven't dropped MySQL from the Debian repos...		Now you can go ahead & pretend they haven't dropped MySQL from the Debian repos...

			* <code>sudo apt install mysql-server mysql-client php-mysql</code>

	<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>		<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>

Tinker: /* Set up at least one user in mysql */

2022-01-28T04:53:49Z

Set up at least one user in mysql

← Older revision		Revision as of 00:53, 28 January 2022
Line 76:		Line 76:
	EXIT;		EXIT;
	('''Hint:''' This'd be a good time to create yourself as that user with your non-admin password of choice...)		('''Hint:''' This'd be a good time to create yourself as that user with your non-admin password of choice...)

			If this is a Database server, you'll be doing the same again but replacing '''localhost''' with '''MachineName''' (where '''MachineName''' is the name of any remote machines that need access to your databases).


	<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>		<span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>

Tinker: /* Configure MySQL */

2022-01-28T04:47:34Z

Configure MySQL

@@ Line 66: / Line 66: @@
 ***<span style="color: rgb(22, 145, 121);" >Yes</span>
 *([[MySQL - Initial Configuration{{!}}Extra Instructions if you've never configured MySQL before]])
 <span style="color: rgb(255, 0, 0);">'''[[Now Do A Backup!{{!}}Now Do A Backup!]]'''</span>