286
edits
Changes
Jump to navigation
Jump to search
Line 54:
Line 54: − + − + − + − + + + + + + +
→Change Username on MySQL Console
== Change Username on MySQL Console ==
== Change Username on MySQL Console ==
login into the MySQL Server, change database and enter:
login into the MySQL Server, change database and enter (table prefix wiki_*):
<pre>
<pre>
update user set user_name = 'NewName' where user_name = 'OldName';
use wikidatabasename; #change database
update revision set rev_user_text = 'NewName' where rev_user_text = 'OldName';
show tables; #check prefix
update recentchanges set rc_user_text = 'NewName' where rc_user_text = 'OldName';
update wikiprefix_user set user_name = 'NewName' where user_name = 'OldName';
update wikiprefix_revision set rev_user_text = 'NewName' where rev_user_text = 'OldName';
update wikiprefix_recentchanges set rc_user_text = 'NewName' where rc_user_text = 'OldName';
</pre>
</pre>
Now login as new Username and test the Settings, History Changes.
All entries should show the new Username!
== Disable Talk at Mediawiki (Spam) ==
== Disable Talk at Mediawiki (Spam) ==