Author:
erics, March 16th, 2022
Had an old server, needed to get root.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
service mysql stop ~OR~ service mysqld stop cd /etc/init.d; ./mysql<tab> start --skip-grant-tables mysql> update mysql.user set Password=PASSWORD('secret') where user='root'; mysql> flush privileges; mysql> ^D service mysql stop service mysql start ~OR~ service mysqld stop service mysqld start |
For MySQL 5.7: https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html For some other v5.7 nodes, I had admin access via a different user’s login, so all I needed was this:
|
|
ALTER USER 'root'@'localhost' IDENTIFIED BY 'secret'; ALTER USER 'root'@'%' IDENTIFIED BY 'secret'; |
Categories: How-To's, Technology Tags: 5.5, Flush, Grant, init.d, Lost, mysql, MySQL 5.5, Password, privileges, recover, Recovery, Reset, root, service, Skip, skip-grant-tables, Tables, User
| 
No comments
Author:
erics, November 19th, 2020
To revert the local branch:
|
|
$ git reset --hard HEAD~1 |
To revert the remote branch AFTER the previous step has been performed:
|
|
$ git push origin HEAD --force |
Categories: How-To's, Technology Tags: git, git revert, HEAD, Merge, Reset, Revert
| No comments
Author:
erics, January 4th, 2018
I was running out of memory constantly on Yosemite 10.10.5 and found the following article: https://discussions.apple.com/message/26929324?start=555&tstart=0 Edited and reposted without permission below… Disconnect any external or secondary monitors, if any is present. The video memory allocation leak can also happen if you have a system with an integrated card, like Intel, with no external monitors […]
Categories: How-To's, Technology Tags: 10.10, howto, Leak, macosx, Memory, Memory Leak, PRAM, PRAM Reset, Reset, SMC, SMC Reset, tips, Yosemite
| No comments
Author:
erics, November 5th, 2015
Every once in a while there is a hiccup in my internet service and every host that Nagios monitors shows DOWN. In those situations, I do not need the hundreds of the emails and text messages generated by Nagios. Here is the procedure for resetting Nagios v3.5.0 running on MacOSX 10.6.8 via a MacPorts install: […]
Categories: How-To's, Technology Tags: Clear, macosx, nagios, Reset, retention.dat
| No comments
Author:
erics, December 31st, 2013
update mysql.user set password=PASSWORD(‘Your New Password Here’) where user=’root’;
Categories: How-To's, Technology Tags: howto, mysql, Password, Reset, root, tips
| No comments
Author:
erics, December 12th, 2012
git reset –hard
Categories: How-To's, Technology Tags: git, Hard, howto, Reset, tips
| No comments
Author:
erics, April 7th, 2012
Quit Safari. Open Keychain Access (Applications / Utilities) Select Passwords on the left. Delete the keychain for that site. Relaunch Safari. From the Safari menu bar click Safari / Preferences then select the Autofill tab. Make sure: User names and passwords is selected. Navigate to that site. You should be prompted to save your login […]
Categories: How-To's, Technology Tags: Autofill, howto, Never, Never for this site, Password, Remember, Reset, Safari, tips, Undo
| No comments
Author:
erics, July 29th, 2011
|
|
UPDATE wp_users SET user_pass = MD5('new_password_here') WHERE user_login = "login_to_change_here"; |
Categories: How-To's, Technology Tags: howto, mysql, Password, Reset, SQL, tips, WordPress
| No comments
Author:
erics, November 28th, 2010
Power off the unit fully. On the LEFT side of the keyboard, hold down CTL-OPT-SHIFT while pressing and holding the power button on the right side for 5 seconds. All four keys must be released AT THE SAME TIME. Nothing should happen. Then power back up…
Categories: How-To's, Technology Tags: apple, MacBook Pro, Reset, SMC, SMC Reset
| No comments
