Posts

MySQL Not Listening On A Public IP By default, MySQL (on Debian) doesn’t listen on the public interface: #netstat -l tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 1768/mysqld In /etc/mysql/my.cnf, comment out the...
Resolving: ‘Client does not support authentication protocol requested by server’ If you get an error about client authentication version when connecting to MySQL then it may be because your server is using the new password format, while your mysql client...
Mass setting user passwords Every need to change (or set) passwords for a large number of users? Something like this code snippet may help. # find all the usernames with bash logins usernames=$(cat...
MediaWiki password reset Here’s the SQL to reset the mediawiki password of a user: use mediawikidb; update tbl_user set user_password=md5(concat(user_id,'-',md5('newpassword'))) where user_name =...