Host Your Own Mediawiki Online Ubuntu 22.04 - Revision history

AwesomO: /* Delete a User from MediaWiki Database */

2025-04-21T17:02:31Z

Delete a User from MediaWiki Database

← Older revision		Revision as of 17:02, 21 April 2025
Line 2,879:		Line 2,879:
	* '''Sessions''': Restart web server (<code>sudo systemctl restart apache2</code>) to end active sessions.		* '''Sessions''': Restart web server (<code>sudo systemctl restart apache2</code>) to end active sessions.

	~~[[Category:Admin Tools]]~~
	</div>		</div>
	</div>		</div>

AwesomO: /* Remove admin rights */

2025-04-21T17:02:05Z

Remove admin rights

← Older revision		Revision as of 17:02, 21 April 2025
Line 2,829:		Line 2,829:
	====Remove admin rights====		====Remove admin rights====
	Same thing, just untick admin rights!		Same thing, just untick admin rights!

			===Delete a User from MediaWiki Database===
			<div class="toccolours mw-collapsible mw-collapsed">
			'''MySQL Commands to Delete a User from MediaWiki Database'''
			<div class="mw-collapsible-content">
			Removes a user from the MediaWiki <code>user</code> table to prevent login. Use with caution and back up first.

			1. '''Log in to MySQL''':
			<syntaxhighlight lang="bash">
			mysql -u root -p
			</syntaxhighlight>

			2. '''Select Database''':
			<syntaxhighlight lang="sql">
			USE your_wiki_database;
			</syntaxhighlight>
			Replace <code>your_wiki_database</code> with your wiki’s database name (check <code>LocalSettings.php</code> for <code>$wgDBname</code>).

			3. '''Find User''':
			<syntaxhighlight lang="sql">
			SELECT user_id, user_name FROM user;
			</syntaxhighlight>
			Note the <code>user_id</code> or <code>user_name</code> of the bot user (e.g., <code>SpamBot123</code>, ID <code>123</code>).

			4. '''Delete User''':
			<syntaxhighlight lang="sql">
			DELETE FROM user WHERE user_name = 'SpamBot123';
			</syntaxhighlight>
			Or by ID:
			<syntaxhighlight lang="sql">
			DELETE FROM user WHERE user_id = 123;
			</syntaxhighlight>

			5. '''Verify Deletion''':
			<syntaxhighlight lang="sql">
			SELECT user_name FROM user WHERE user_name = 'SpamBot123';
			</syntaxhighlight>
			No rows means the user is deleted.

			6. '''Clear Cache (Optional)''':
			<syntaxhighlight lang="bash">
			php maintenance/rebuildall.php
			</syntaxhighlight>
			Run from MediaWiki root directory.

			'''Notes''':
			* '''Backup''': Run <code>mysqldump -u root -p your_wiki_database > backup.sql</code> before deleting.
			* '''Contributions''': User edits remain in <code>revision</code> table. Deleting them is complex.
			* '''Sessions''': Restart web server (<code>sudo systemctl restart apache2</code>) to end active sessions.

			[[Category:Admin Tools]]
			</div>
			</div>

Noob: /* EmbedVideo */

2023-05-04T17:06:37Z

EmbedVideo

← Older revision		Revision as of 17:06, 4 May 2023
Line 965:		Line 965:
	What you place in this page will be displayed at the top of every page created.		What you place in this page will be displayed at the top of every page created.

	===~~EmbedVideo~~===		===Youtube extension===
	https://www.mediawiki.org/wiki/Extension:~~EmbedVideo<br>~~		* needed to view embedded videos
	~~<code>apt install unzip</code><br>~~		https://www.mediawiki.org/wiki/Extension:YouTube
	<code>wget https://~~gitlab~~.~~com~~/~~hydrawiki~~/extensions/~~EmbedVideo/~~-~~/archive/v2.9.0/EmbedVideo~~-v2.9.~~0.zip~~</code>~~<br>~~
	<code>~~unzip EmbedVideo~~-~~v2.9~~.0.~~zip~~ -d /var/www/html/~~noobs~~/extensions/</code>~~<br>~~		<code>wget https://extdist.wmflabs.org/dist/extensions/YouTube-REL1_39-f272bb3.tar.gz</code>
	<br>
	<code>mv /~~var~~/www~~/html/noobs/extensions/EmbedVideo-v2~~.9.0 /~~var/www/html/noobs/extensions/EmbedVideo~~<~~/code~~><br>		<code>tar -xzf YouTube-REL1_39-f272bb3.tar.gz -C /var/www/html/mediawiki/extensions/</code>
	<br>
	<~~code~~>~~$EDITOR /var/www/html/noobs/LocalSettings.php~~<~~/code~~><br>		* Append to '''LocalSettings.php'''
	<~~pre~~>		<code>wfLoadExtension( 'YouTube' );</code>
	~~#Embed Video~~
	~~wfLoadExtension( 'EmbedVideo' );~~		* On wiki page can now embed youtube videos
	</~~pre~~>		** https://www.youtube.com/watch?v=wB4gvSgYmfY
			** After '''watch?v='''
			** <nowiki><youtube>wB4gvSgYmfY</youtube></nowiki>
			* Defaults '''width'''=640 pixels '''height'''=385 pixels
			* Change defaults <nowiki><youtube width="800" height="400">wB4gvSgYmfY</youtube></nowiki>

	===Syntax highlighting not working===		===Syntax highlighting not working===

AwesomO: /* Dump and gzip database for transport */

2023-04-28T20:29:47Z

Dump and gzip database for transport

← Older revision		Revision as of 20:29, 28 April 2023
Line 2,483:		Line 2,483:
	====Dump and gzip database for transport====		====Dump and gzip database for transport====

	~~will~~ be '''prompted''' for password:<br \>		:* Will be '''prompted''' for password:<br \>
			:** Note: If you forgot your Database details, you can find them on your LocalSettings.php file

	<code>mysqldump -h localhost --default-character-set=binary --no-tablespaces -u green -p mywiki_database \| gzip > /root/greenwiki.sql.gz</code><br \>		<code>mysqldump -h localhost --default-character-set=binary --no-tablespaces -u green -p mywiki_database \| gzip > /root/greenwiki.sql.gz</code><br \>

AwesomO: Created page with "==Creating a MediaWiki Server on Ubuntu with Apache2== ===DNS=== Domain Name System: An index that connects an ip address with a more human readable name(website name):
Like a phone book would index a persons name with a phone number.
If you have a domain name for your wiki, point it to your server's ip address.
This will be required for a letsencrypt cert also.
I am using namecheap.com and on the Advanced DNS Page
Add two T..."

2023-04-23T22:22:32Z

Created page with "==Creating a MediaWiki Server on Ubuntu with Apache2== ===DNS=== Domain Name System: An index that connects an ip address with a more human readable name(website name): Like a phone book would index a persons name with a phone number. If you have a domain name for your wiki, point it to your server's ip address. This will be required for a letsencrypt cert also. I am using namecheap.com and on the Advanced DNS Page Add two T..."

Show changes