MYSQL-notes - Revision history

Ted: Add short section "Restart server and invoke client".

2024-02-22T05:35:09Z

Add short section "Restart server and invoke client".

Ted: reorg.

2024-02-22T05:31:00Z

reorg.

Ted: minor formatting, remove white space

2024-02-12T14:44:41Z

minor formatting, remove white space

Ted: /* MYSQL logging config */

2019-11-13T17:47:38Z

MYSQL logging config

Ted at 17:39, 13 November 2019

2019-11-13T17:39:03Z

Ted: /* MYSQL logging config */

2019-11-13T16:33:36Z

MYSQL logging config

Ted: /* MYSQL logging config */

2019-11-13T16:33:26Z

MYSQL logging config

Ted at 15:56, 13 November 2019

2019-11-13T15:56:52Z

Ted at 01:12, 8 November 2019

2019-11-08T01:12:38Z

Ted: /* MYSQL Reset Root Password */

2019-10-08T19:02:22Z

MYSQL Reset Root Password

@@ Line 86: / Line 86: @@
 <!-- comment -->
-== [[#top|^]] MYSQL Reset Root Password ==
+== [[#top|^]] Restart Server and Invoke Client ==
 <i>Key phrases:  reset MYSQL password, reset mysql password, reset mysql passphrase</i>
 Once we are able to begin an interactive, command line session with local MYSQL server we may perform a check to see which databases are in place and visible to MYSQL's root user.  Should be all databases on the local server are visible to root.  At MYSQL's prompt:

@@ Line 5: / Line 5: @@
-== OVERVIEW ==
+== [[#top|^]] OVERVIEW ==
 <!-- comment -->
-== MYSQL logging config ==
+== [[#top|^]] MYSQL logging config ==
 Here are a couple of references which talk about how to enable MYSQL logging, which can take place on different levels.  Also can occur per session or persistently across MYSQL server restarts, and can occur directed to log files on disk or to internal database tables . . .
@@ Line 27: / Line 26: @@
 <!-- comment -->
-== MYSQL database dumps ==
+== [[#top|^]] MYSQL database dumps ==
 <ul>
@@ Line 33: / Line 32: @@
 </ul>
-<!-- comment, end of mysql database dumps -->
+<!-- comment -->
-== MYSQL Reset Root Password ==
+== [[#top|^]] First Steps ==
 <i>Key phrases:  reset MYSQL password, reset mysql password, reset mysql passphrase</i>
@@ Line 87: / Line 139: @@
 mysql>
 </pre>
 Commands to grant all privileges to a user and to show privileges of a MYSQL user:
 <pre>
 user@localhost:~/projects/database-back-ups$ mysql -u root -p
 Enter password:
@@ Line 115: / Line 165: @@
 +---------------------------------------------------------------------------------------------------------------------------------------+
 row in set (0.00 sec)
 </pre>
@@ Line 129: / Line 178: @@
 Reference to follow up:  https://serverfault.com/questions/235593/mysql-log-shows-3-root-users-2-without-passwords-why
 <!-- comment -->
-== MYSQL Multiple Servers On One Host ==
+== [[#top|^]] MYSQL Multiple Servers On One Host ==
 *  [https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html MYSQL 5.7 documentation - multiple servers]
@@ Line 192: / Line 188: @@
 <!-- comment -->
-== References ==
+== [[#top|^]] References ==
 - 2017-07-xx -

@@ Line 8: / Line 8: @@
 This wiki article holds Ted's notes on configuring, deploying, backing up and restoring MYSQL database servers and databases.
 <!-- comment -->
@@ Line 26: / Line 24: @@
     mysql> show variables like '%log%';
 <!-- comment -->
@@ Line 36: / Line 32: @@
 *  https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
 </ul>
 <!-- comment, end of mysql database dumps -->
@@ Line 55: / Line 49: @@
 There will be a lot of tables, but the table named 'user' is the one we must query to change MYSQL user passwords.
 <i>Excerpt x - query to see users of a given MYSQL installation</i>
@@ Line 190: / Line 182: @@
               ^^^^^^^^^^
 </pre>
 <!-- comment -->
 == MYSQL Multiple Servers On One Host ==
@@ Line 201: / Line 189: @@
 *  [https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html MYSQL 5.7 documentation - multiple servers]
 *  [https://dev.mysql.com/doc/refman/5.7/en/multiple-data-directories.html MYSQL multiple data directories]
 <!-- comment -->

@@ Line 19: / Line 19: @@
 *  https://stackoverflow.com/questions/9947822/mysql-revoke-root-privileges-carefully
 *  https://serverfault.com/questions/71071/how-to-enable-mysql-logging
 See also <code>/etc/mysql/my.cnf</code>, which may be a symbolic link to a default or fallback package maintainer's config file.

@@ Line 26: / Line 26: @@
     mysql> show variables like '%log%';
@@ Line 91: / Line 37: @@
 == MYSQL Reset Root Password ==
@@ Line 192: / Line 138: @@
 <!-- comment -->
 == MYSQL Multiple Servers On One Host ==

← Older revision		Revision as of 16:33, 13 November 2019
Line 24:		Line 24:
	At a MYSQL command prompt one may also investigate MYSQL server variable settings:		At a MYSQL command prompt one may also investigate MYSQL server variable settings:

−
	mysql> show variables like '%log%';		mysql> show variables like '%log%';

← Older revision		Revision as of 15:56, 13 November 2019
Line 12:		Line 12:

	<!-- comment -->		<!-- comment -->
		+
		+	== MYSQL logging config ==
		+
		+	* https://stackoverflow.com/questions/9947822/mysql-revoke-root-privileges-carefully
		+	* https://serverfault.com/questions/71071/how-to-enable-mysql-logging
		+
		+	See also <code>/etc/mysql/my.cnf</code>, which may be a symbolic link to a default or fallback package maintainer's config file.
		+

	== First Steps ==		== First Steps ==

← Older revision		Revision as of 01:12, 8 November 2019
Line 64:		Line 64:
	^^^^^^^^^^		^^^^^^^^^^
	</pre>		</pre>
		+
		+
		+	<!-- comment -->
		+
		+	== MYSQL database dumps ==
		+
		+	<ul>
		+	* https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
		+	</ul>

← Older revision		Revision as of 19:02, 8 October 2019
Line 159:		Line 159:
	.		.
	.		.
		+
		+
		+	2019-10-08 Tuesday:
		+
		+	Reference to follow up: https://serverfault.com/questions/235593/mysql-log-shows-3-root-users-2-without-passwords-why