PHP/MySQL - Revision history

Stuart at 16:28, 21 May 2018

2018-05-21T16:28:38Z

2018-05-21T16:20:56Z

2017-07-30T18:43:38Z

‎Force user logout if session is inactive for a certain period of time

2017-07-30T18:40:33Z

2015-01-31T23:51:20Z

‎Reset a forgotten MySQL root password

2015-01-31T23:50:58Z

‎Reset a forgotten MySQL root password

2015-01-31T23:50:41Z

‎Reset a forgotten MySQL root password

2015-01-31T23:24:58Z

‎Reset a forgotten MySQL root password

2015-01-31T23:15:10Z

2015-01-31T00:20:38Z

@@ Line 1: / Line 1: @@
-* [https://github.com/mevdschee/php-crud-api Self-contained REST API in PHP]
+* [https://github.com/mevdschee/php-crud-api Self-contained REST API in PHP - github.com/mevdschee]
 ===Excellent tutorial on Object Oriented PHP===
 [http://www.killerphp.com/tutorials/object-oriented-php/ www.killerphp.com]

← Older revision		Revision as of 16:20, 21 May 2018
Line 1:		Line 1:
		+	* [https://github.com/mevdschee/php-crud-api Self-contained REST API in PHP]
	===Excellent tutorial on Object Oriented PHP===		===Excellent tutorial on Object Oriented PHP===
	[http://www.killerphp.com/tutorials/object-oriented-php/ www.killerphp.com]		[http://www.killerphp.com/tutorials/object-oriented-php/ www.killerphp.com]

@@ Line 52: / Line 52: @@
 onscroll="reset_interval()"
 </pre>
 ===Run a shell script with an html button===
 <pre>

@@ Line 13: / Line 13: @@
 [[CSV tables - equivalent of External tables in Oracle]]
 ===Run a shell script with an html button===
 <pre>

@@ Line 46: / Line 46: @@
 ===Reset a forgotten MySQL root password===
 * [http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html mysql.com]
-[https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password debian-administration.org]
+* [https://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password debian-administration.org]
 Stop mysqld and restart it with the --skip-grant-tables option. This enables anyone to connect without a password and with all privileges. Because this is insecure, you might want to use --skip-grant-tables in conjunction with --skip-networking to prevent remote clients from connecting.<br />
 Connect to the mysqld server with this command:

← Older revision		Revision as of 23:24, 31 January 2015
Line 46:		Line 46:
	===Reset a forgotten MySQL root password===		===Reset a forgotten MySQL root password===
	* [http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html mysql.com]		* [http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html mysql.com]
		+	Stop mysqld and restart it with the --skip-grant-tables option. This enables anyone to connect without a password and with all privileges. Because this is insecure, you might want to use --skip-grant-tables in conjunction with --skip-networking to prevent remote clients from connecting.<br />
		+	Connect to the mysqld server with this command:
		+	<pre>
		+	shell> mysql
		+	</pre>
		+	Issue the following statements in the mysql client. Replace the password with the password that you want to use.
		+	<pre>
		+	mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
		+	mysql> FLUSH PRIVILEGES;
		+	</pre>
		+	The FLUSH statement tells the server to reload the grant tables into memory so that it notices the password change.<br />
		+	You should now be able to connect to the MySQL server as root using the new password. Stop the server, then restart it normally (without the --skip-grant-tables and --skip-networking options).

← Older revision		Revision as of 23:15, 31 January 2015
Line 44:		Line 44:
	cd /usr/mysql-test ; perl mysql-test-run.pl		cd /usr/mysql-test ; perl mysql-test-run.pl
	</pre>		</pre>
		+	===Reset a forgotten MySQL root password===
		+	* [http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html mysql.com]

@@ Line 23: / Line 23: @@
 <!-- This link will add ?run=true to your URL, myfilename.php?run=true -->
 <button type="button" onclick="?run=true">Click Me!</button>
 </pre>