MySQL - Revision history

Admin: /* Binding */

2018-03-07T13:14:05Z

Binding

← Older revision		Revision as of 13:14, 7 March 2018
Line 67:		Line 67:
	Using a Linux-installed MySQL will put the configuration file in <code>/etc/mysql/my.cnf</code>. Check your version's documentation for more information if you can't find it.		Using a Linux-installed MySQL will put the configuration file in <code>/etc/mysql/my.cnf</code>. Check your version's documentation for more information if you can't find it.

	==~~Binding~~==		==Bind to IP==

	~~You can set up binding for your MySQL~~ server~~, meaning it will be~~ accessible to the outside world. ~~Note that before~~ you ~~do this~~, ~~your password should~~ be ~~very strong, otherwise others can hack your MySQL database~~.		Binding to an IP address means the server is accessible to the outside world through that interface and IP address only. If you bind MySQL to a VPN IP address, only other computers on the VPN will be able to access the server.

	In your MySQL configuration file (probably called my.cnf), change the line:		In your MySQL configuration file (probably called my.cnf), change the line:

Admin at 23:23, 12 September 2017

2017-09-12T23:23:20Z

← Older revision		Revision as of 23:23, 12 September 2017
Line 154:		Line 154:
	{{Programs}}		{{Programs}}
	{{Languages}}		{{Languages}}

			[[Category:Databases]]
			[[Category:SQL]]
			[[Category:MySQL]]

Admin: /* Get a Remote MySQL Shell */

2017-09-12T00:43:43Z

Get a Remote MySQL Shell

← Older revision		Revision as of 00:43, 12 September 2017
Line 113:		Line 113:
	this will, by default, connect to the host localhost. If no database is specified, it will not connect to a default database.		this will, by default, connect to the host localhost. If no database is specified, it will not connect to a default database.

	==Get a ~~Remote~~ MySQL ~~Shell~~==		==Get a remote MySQL shell==

	If our MySQL server is running on a remote host like 1.2.3.4, we can specify the host using the --host or -h flags:		If our MySQL server is running on a remote host like 1.2.3.4, we can specify the host using the --host or -h flags:

Admin: /* Basic Operations */

2017-09-12T00:43:27Z

Basic Operations

@@ Line 103: / Line 103: @@
 =Basic Operations=
-Start by logging in:
+==Get a Local MySQL Shell==
 <pre>
 $ mysql --user=root --password
 </pre>
 ==Show running threads and connections==
@@ Line 124: / Line 146: @@
 mysql> SELECT User, Host, Password FROM mysql.user;
 </pre>
 =References=

Admin: /* References */

2017-09-12T00:29:14Z

References

@@ Line 97: / Line 97: @@
 <pre>
 port        = 3306
 </pre>

Admin at 08:02, 7 July 2015

2015-07-07T08:02:33Z

← Older revision		Revision as of 08:02, 7 July 2015
Line 50:		Line 50:

	One really cool way to test this out and make sure it works as expected is to dump your MediaWiki databases, then load it up into a MySQL database on a virtual computer using software like [[VirtualBox]]. You can load the database before ''or'' after you create/set up MediaWiki - if MediaWiki tries to set up a database and finds one already there, it will just use that one. That means that if you load the MySQL database, then install MediaWiki, your articles will all show up intact.		One really cool way to test this out and make sure it works as expected is to dump your MediaWiki databases, then load it up into a MySQL database on a virtual computer using software like [[VirtualBox]]. You can load the database before ''or'' after you create/set up MediaWiki - if MediaWiki tries to set up a database and finds one already there, it will just use that one. That means that if you load the MySQL database, then install MediaWiki, your articles will all show up intact.

	~~More information over at the [[MediaWiki]] page.~~

	==phpMyAdmin==		==phpMyAdmin==

	You can also backup your MySQL databases from phpMyAdmin, which is a handy piece of software that provides a nice GUI interface to dealing with your MySQL databases.		You can also backup your MySQL databases from phpMyAdmin, which is a handy piece of software that provides a nice GUI interface to dealing with your MySQL databases.


			=Nuking Your Databases=




	=MySQL Server=		=MySQL Server=

Admin: /* MediaWiki */

2015-07-07T07:59:47Z

MediaWiki

← Older revision		Revision as of 07:59, 7 July 2015
Line 50:		Line 50:

	One really cool way to test this out and make sure it works as expected is to dump your MediaWiki databases, then load it up into a MySQL database on a virtual computer using software like [[VirtualBox]]. You can load the database before ''or'' after you create/set up MediaWiki - if MediaWiki tries to set up a database and finds one already there, it will just use that one. That means that if you load the MySQL database, then install MediaWiki, your articles will all show up intact.		One really cool way to test this out and make sure it works as expected is to dump your MediaWiki databases, then load it up into a MySQL database on a virtual computer using software like [[VirtualBox]]. You can load the database before ''or'' after you create/set up MediaWiki - if MediaWiki tries to set up a database and finds one already there, it will just use that one. That means that if you load the MySQL database, then install MediaWiki, your articles will all show up intact.

			More information over at the [[MediaWiki]] page.

	==phpMyAdmin==		==phpMyAdmin==

Admin: /* phpMyAdmin */

2013-12-16T22:59:34Z

phpMyAdmin

← Older revision		Revision as of 22:59, 16 December 2013
Line 53:		Line 53:
	==phpMyAdmin==		==phpMyAdmin==

	~~{{Main\|phpMyAdmin}}~~		You can also backup your MySQL databases from phpMyAdmin, which is a handy piece of software that provides a nice GUI interface to dealing with your MySQL databases.

	You can also backup your MySQL databases from [[phpMyAdmin]], which is a handy piece of software that provides a nice GUI interface to dealing with your MySQL databases.



	=MySQL Server=		=MySQL Server=

Admin at 16:27, 28 May 2011

2011-05-28T16:27:23Z

← Older revision		Revision as of 16:27, 28 May 2011
Line 104:		Line 104:


	~~[[Category:Computers]]~~		{{Programs}}
	~~[[Category:Programs]]~~		{{Languages}}

Admin at 05:10, 29 April 2011

2011-04-29T05:10:12Z

← Older revision		Revision as of 05:10, 29 April 2011
Line 44:		Line 44:

	Note that this requires the remote host's MySQL to have a bind address, meaning, it should be bound to an IP address instead of the localhost. Otherwise it won't be accessible to the outside world.		Note that this requires the remote host's MySQL to have a bind address, meaning, it should be bound to an IP address instead of the localhost. Otherwise it won't be accessible to the outside world.

			==MediaWiki==

			In case you did not already think of it, this provides an extremely simple and handy way to backup your MediaWiki server. You can use mysqldump to output the entire contents of your wiki (minus extensions and skins/stylesheets) to a single SQL file. This will be modest in size, typically a few MB or (in cases of extremely large wikis) maybe 100 MB.

			One really cool way to test this out and make sure it works as expected is to dump your MediaWiki databases, then load it up into a MySQL database on a virtual computer using software like [[VirtualBox]]. You can load the database before ''or'' after you create/set up MediaWiki - if MediaWiki tries to set up a database and finds one already there, it will just use that one. That means that if you load the MySQL database, then install MediaWiki, your articles will all show up intact.

			==phpMyAdmin==

			{{Main\|phpMyAdmin}}

			You can also backup your MySQL databases from [[phpMyAdmin]], which is a handy piece of software that provides a nice GUI interface to dealing with your MySQL databases.



	=MySQL Server=		=MySQL Server=