{"id":10028,"date":"2026-05-08T17:12:31","date_gmt":"2026-05-08T16:12:31","guid":{"rendered":"https:\/\/stevepedwards.today\/ElectronicsStuff\/?p=10028"},"modified":"2026-05-08T17:53:45","modified_gmt":"2026-05-08T16:53:45","slug":"replace-lost-wp-login-password-via-maria-db-and-all-es_projects_titles-list","status":"publish","type":"post","link":"https:\/\/stevepedwards.today\/ElectronicsStuff\/replace-lost-wp-login-password-via-maria-db-and-all-es_projects_titles-list\/","title":{"rendered":"Replace lost WP login password via Maria DB and All ES_projects_titles List"},"content":{"rendered":"

Replace lost WP login password via the ISP SSH Command Line:<\/p>\n

mysql -u stevee -p<\/p>\n

MariaDB >use ES ;<\/p>\n

MariaDB [ES]> SELECT ID, user_login, user_email FROM wp_xubg_users;
\n+----+-----------------+---------------------------+
\n| ID | user_login | user_email |
\n+----+-----------------+---------------------------+
\n| 1 | stevee | stevepedwards@gmail.com |
\n| 2 | steveped_stevee | stevepedwards@hotmail.com |
\n+----+-----------------+---------------------------+
\n2 rows in set (0.000 sec)<\/p>\n

UPDATE wp_xubg_users SET user_pass = MD5('New_Password') WHERE ID = 1;<\/p>\n

List All Post Titles in text file:<\/p>\n

mysql -u stevee -p -e \"SELECT post_title FROM ES.wp_xubg_posts WHERE post_type = 'post' AND post_status = 'publish' ORDER BY post_date DESC;\" > ~\/electronics_projects.txt<\/p>\n

MariaDB >exit<\/p>\n

Now you can open that list in a local Windows text editor (like Notepad++ or VS Code) by typing:<\/p>\n

\n
Bash<\/span><\/div>\n
\n
\n
explorer.exe .<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
\"\"<\/a><\/p>\n
cat electronics_projects.txt:<\/p>\n
Dim Bulb Tester Reforming Pye Radio Capacitors
\nDimb Bulb Tester and Pye Valve Radio Testing
\nBuilding and Understanding a Dim Bulb Tester
\n1946 Vidor Chanson CN349 Valve Radio Checks
\nCar Charger from Sony EX50 Transformer
\nHome Built Sine Gens Total Harmonic Distortion on DSO5102P
\nBattery Charger Circuits
\nRadio Antenna Fundamentals 1947
\n1KHz Sine Wave Gen Circuits, MCL Wien with Tweeter
\nPioneer X-HMII DAB System - Blown Ceramic Fuse
\nSony EX50 - Multiplexor IC Causing Voltage Fault
\nTechnics SU X840 - Replaced SVI 3102B
\nMr Carlson's Lab 30s Delay Circuit
\nSu600 - No Bass Knob
\nPioneer X-HM11 DAB-K - Dead, full of concrete dust.
\nSony Ex50 - no left channel output
\nJason's Dead PB15
\nDuncan Tone Stack Calculator
\nSweep Signal Generator AD9833 on Uno
\nDIY PCB Toner Transfer (No Heat) & Etching
\nHantek DSO Math Function for THD
\nSean's Ibanez Chorus
\nSean's DOD Env Filter
\nTechnics SU V303 + THD
\nSean's SU A808
\nQuick Testing SVI 3102 14-16 pin Family Using Same 100% Feedback Op Amp Circuit
\nTechnics SUX911 - Fixed, Power Out
\nLM324\/AN6554 Quad Amp IC Quick Test 100% Feedback Op Amp Circuit
\nLM358\/6552\/6558 based mono NPN\/PNP class B amp
\nOp Amp class B mono power amp - Electronic Testing Book
\nLM324\/AN6554 14pin quad amp tester
\nVacuum Flouro Displays
\nZ80 CPU Tester - Julian Illet
\nIndie IT 150 Guitar Amp
\nMCL - Peak Detector
\nMr Carlson's Lab - 1kHz Wien Bridge Oscillator
\n555 Astable Multivibrator - Duty Cycle From 0 To 100%
\nOp Amp Test - Transfer Characteristics by XY Mode
\nLM358 Dual Op Amp Tester
\nTechnics SU-V1X - Volume Board Short
\nNice LED Clock Kit
\nTechnics SU-V1X - Intermittent Noise
\nAnother 741 Op Amp Test Circuit
\nTechnics SU-X911 - multiple issues
\nTechnics SU-V1X - No Power
\nPhilips FA-443 - Low Sound, One Channel Only
\nTechnics SA 5L Repair \u2013 Working - Sound Check and Lessons Learned
\nTechnics SA 5L Repair - Working - Sound Check and Lessons Learned
\nTechnics SU X840 - Voltage Tests Main Board
\nGW Instek 2030D Dual Rail PSU Master Channel Voltage Maxed Problem
\nTechnics SA 5L Repair - Transistor Checks
\nTechnics SU X840 - Initial Inspection
\nTechnics SA 5L Repair - First Inspection
\nTechnics SU 600 Repair \u2013 Fixes Required - Bodge Done
\nTechnics SU 600 Repair - Fixes Required - Bodge Done
\nTechnics SU 600 Repair \u2013 Minor Faults and Section Function
\nTechnics SU 600 Repair - Minor Faults and Section Function
\nTechnics SU 600 Repair - Mains Transformer Tests
\nAlan&#039;s Automatic Audio Leveling Circuit (Limiter)
\nAlan&#039;s Stairstep Generator Using 555 and Op Amps
\nWeather Station Complete
\n16Mhz Crystal Oscillator Actually at 16Mhz!
\n3 Transistor Sawtooth Generator \/ Oscillator
\nLM358 VCO Circuit
\nKentiger HY-502S Amp
\nUnity Phase Splitter - Two Outputs from Same Transistor
\nTwo Transistor Schmitt Trigger; Converts Analogue Signal to Digital Output
\nBreadboard Amp 17.5kHz Limited Frequency Response Setup Using Keuwlsoft App
\nLM358N\/TL082\/741 Op Amps 5 Gain Circuits and 741 Op Amp Tester Circuit
\nReading Remote Control Codes With Arduino
\nSimplest Transistor Oscillator and Breadboard Crystal Oscillator Actually Working!
\nAtmega 8L Inductance\/Capacitance Kit - Good Cheap Chinese LC Tester - If you have the missing bits!
\nAstable Multivibrators from Transistors and 555 Timer
\nAstable Multivibrator from Great Scott Channel
\nI2C Bus Connections For 2 Or More Devices
\nShowing GPS and DHT11 Temp\/Humidity in 128\u00d732 OLED with 2 Text Sizes
\nShowing GPS data in 128x32 OLED
\nAlftek 0.96inch I2C IIC Serial 128x32 Blue OLED Display Module for Arduino
\nHow to display your Arduino GPS NMEA data in Google Earth
\nGPS LCD Data combining with Weather Station data
\nNeo 7\/Uno\/Nano showing accurate GPS clock LCD location data via pins 8\/9
\nUno\/Nano LCD arduino-weather-station-2, DHT11, BMP80
\nNano Pins, 1602 LCD Pins, DHT11 pins, BMP180 pins, Uno pins
\nCombining Code from BMP180 and Thermistor LCD Output
\nBosch BMP180 Pressure Sensor
\nArduino LCD Screen and Thermistor
\nArduino Examples - Basics Dir 1
\nKeuwlsoft Android Function Gen
\nKKmoon 47 HiFi NE5532 Headphone Amplifier DIY
\nKKmoon 1HZ-500KHZ DDS Functional Signal Generator
\nKKmoon 1HZ-500KHZ DDS Functional Signal Generator
\nEZM 1Hz-999kHz DDS Functional Signal Generator
\nXR2206 Function Gen
\nArduino, TinyGPSPlus and Neo 7m GPS module
\nLysignal Fever 6J1 Tube Amplifiers Board - Safe Novice Valve Amp Intro
\nLysignal Fever 6J1 Tube Amplifiers Board
\nArduino Intro on Linux Mint
\nLaney Vintage Reverb Tank Notes
\nBiyang ODT100 Valve Pedal Repair and Modding Options Study
\n2008 Carlsbro TC60 Repair - Fixed
\n2008 Carlsbro TC60 Repair \u2013 Part 2
\n2008 Carlsbro TC60 Repair - Part 2
\nCarlsbro TC60 Repair and Design Study \u2013 Part 1
\nCarlsbro TC60 Repair and Design Study - Part 1
\n1962 Fender Tremolux Repair
\nUnderstanding Speaker Cab 16, 8 and 4 Ohm Connections
\nLaney Klipp 100W Repair and Design Study \u2013 Part 2
\nLaney Klipp 100W Repair and Design Study - Part 2
\nLaney Klipp 100W Repair and Design Study \u2013 Part 1
\nLaney Klipp 100W Repair and Design Study - Part 1
\nPassive Filters, Capacitors, Smoothing and Noise in Amps
\nUnderstanding Amp Load Lines
\nAmp Power Output Calculations
\nGlobal Negative Feedback on the PP18
\nCarlsbro CS60 Reverb Mk II PA Repair
\nPP18_6V6 Build Summary
\n1967 Marshall JMP 100W Buyer\u2019s Info
\n1967 Marshall JMP 100W Buyer's Info
\nMarshall 100W Mains Tests Data
\nHandbook Amp Project \u2013 Part 5 \u2013 Output Section \u2013 Working Amp
\nHandbook Amp Project - Part 5 - Output Section - Working Amp
\nMarshall JMP 100W Super Lead - Serial 10928 \u2013 Components List
\nMarshall JMP 100W Super Lead - Serial 10928 - Components List
\nGibson GA 15 Amp Repair
\nAmplifier Output Frequency Responses
\nHandbook Amp Project \u2013 Part 4 \u2013 Input Section
\nHandbook Amp Project - Part 4 - Input Section
\nHandbook Amp Project \u2013 Part 3 \u2013 Rectification
\nHandbook Amp Project - Part 3 - Rectification
\nHandbook Amp Project \u2013 Part 2 \u2013 Mains Electricity and Transformer
\nHandbook Amp Project - Part 2 - Mains Electricity and Transformer
\nHandbook Amp Project \u2013 Part 1 \u2013 Chassis
\nHandbook Amp Project - Part 1 - Chassis
\nCorrecting the Marshall Tremolo Circuit
\nAmplifier Jack Socket Stomp Switch Variations
\nIbanez Five Position Switch Adventure
\nWaveforms Revisited \u2013 AM and FM Modulation using Synthmaker
\nWaveforms Revisited - AM and FM Modulation using Synthmaker
\nAddendum to Test Tone Using FLS - Synthmaker
\nFender Champ 12 Repair
\nAmp Related Circuit Basics \u2013 Transformers, Rectifiers and Capacitors
\nAmp Related Circuit Basics - Transformers, Rectifiers and Capacitors
\nAshdown Fallen Angel 40W Repair
\nUsing FLS As A Test Signal Generator With DSO Nano
\nApplying the Briggs Valve PDF Principles to the Marshall Circuit
\nAston Electronics 5W Valve Amp Kit Build - Finished
\nAston Electronics 5W Valve Amp Kit Build - Start
\nMarshall Mercury 2060 \u2013 Repaired!!
\nMarshall Mercury 2060 - Repaired!!
\nMarshall Mercury 2060 Repair \u2013 Week 2-3, Circuit Theory
\nMarshall Mercury 2060 Repair - Week 2-3, Circuit Theory
\nMarshall Mercury 2060 Repair \u2013 Days 4-6
\nMarshall Mercury 2060 Repair - Days 4-6
\nMarshall Mercury 2060 Repair \u2013 Days 1-3
\nMarshall Mercury 2060 Repair - Days 1-3<\/p>\n","protected":false},"excerpt":{"rendered":"
Replace lost WP login password via the ISP SSH Command Line: mysql -u stevee -p MariaDB >use ES ; MariaDB [ES]> SELECT ID, user_login, user_email FROM wp_xubg_users; +----+-----------------+---------------------------+ | ID | user_login | user_email | +----+-----------------+---------------------------+ | 1 | stevee | stevepedwards@gmail.com | | 2 | steveped_stevee | stevepedwards@hotmail.com | +----+-----------------+---------------------------+ 2 rows in set ...  Replace lost WP login password via Maria DB and All ES_projects_titles List<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-10028","post","type-post","status-publish","format-standard","hentry","category-tech-studies"],"_links":{"self":[{"href":"https:\/\/stevepedwards.today\/ElectronicsStuff\/wp-json\/wp\/v2\/posts\/10028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stevepedwards.today\/ElectronicsStuff\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stevepedwards.today\/ElectronicsStuff\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stevepedwards.today\/ElectronicsStuff\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stevepedwards.today\/ElectronicsStuff\/wp-json\/wp\/v2\/comments?post=10028"}],"version-history":[{"count":4,"href":"https:\/\/stevepedwards.today\/ElectronicsStuff\/wp-json\/wp\/v2\/posts\/10028\/revisions"}],"predecessor-version":[{"id":10033,"href":"https:\/\/stevepedwards.today\/ElectronicsStuff\/wp-json\/wp\/v2\/posts\/10028\/revisions\/10033"}],"wp:attachment":[{"href":"https:\/\/stevepedwards.today\/ElectronicsStuff\/wp-json\/wp\/v2\/media?parent=10028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stevepedwards.today\/ElectronicsStuff\/wp-json\/wp\/v2\/categories?post=10028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stevepedwards.today\/ElectronicsStuff\/wp-json\/wp\/v2\/tags?post=10028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}