Tag Archives: MySQL

WordPress Password Resets via MySQL

Posted on by

I have not completed the switch away from WordPress completely, (as this site and the justCheckers site show). I might switch to using something like Django CMS or Wagtail. Unfortunately I have not had as much time as I’d like to, to work on Rookeries, my own Flask based CMS

Still in the meantime, I managed to accidentally lock myself out of my own WordPress sites. Thankfully there are a few ways to reset passwords in WordPress. The most surefire way I found was to reset the password using MySQL. (Using the wp-cli tools looks interesting, but I didn’t feel like setting up get another PHP tool.) Most of the time you don’t need to do this. However if you’ve managed to forget your only admin password… well this will get you out of that problem. So what does resetting a WordPress password via MySQL, you ask?

  1. Log into your server via SSH (or to MySQL via a SSH tunnel if you have that enabled)
  2. Login into MySQL: mysql -u $MY_DB_USER -p
  3. Get the username if you have not already. You can look those up in the ${MY_WP_SUFFIX}_wp_users table.
  4. Finally reset the password, using the MD5() function and an update SQL statement: UPDATE "wp_users" SET "user_pass" = MD5('new_password') WHERE "wp_users"."user_login"= "username";
  5. Log in with the user using the regular WordPress login (e.g. https://my-wordpress.example.com/wp-login.php). Remember to change the password, as that will use a stronger hash than MD5 internally and is more secure.

And there you go!

New Site for justCheckers

Posted on by

I’m setting up a new site for the justCheckers project.  The only real good reason for my working at all on this project, is simply to build a portfolio.  As a software developer, I want to show to others that I can code.  And that my code is clean, elegant and professional.  I also want to show that I can write my own web applications.  So I am writing the justCheckers website as a PHP, MySQL DB enabled application.  All using proper XHTML, CSS and a touch of AJAX.  The site is a work in progress.  I’m not planning to build an entire flexible CMS, rather I plan on building a custom site.

The Open Source Gamer Looking for Work

Posted on by

I am currently looking for work, so if anyone is interested in a software developer or software engineer position please let me know. I have experience from university (finished my B.Sc. in Computer Science at the University of Toronto) and from my open source projects in:

  • Java development.
  • PHP and JSP scripting.
  • Database (MySQL and SQL Server) programming.
  • Technical, computer manual writing.
  • Graphics: mostly Java AWT and SDL.
  • Website development (XHTML, CSS and Javascript).

I am looking something that I can either do at home or commute to in Brampton, Mississauga or Toronto. So if anyone is interested please send me an email at:

dorian dot pula at gmail dot com.

Thanks in advance for all offers.

Update for February 26, 2006

Posted on by

Good morning. The sun is shining brightly, its brilliance reflected off the snow. The sky is a nice light blue gradient, and is cloudless. I’m in a pretty good mood as well.

Actually I don’t have too much time to write this, as the time to leave to church is approaching rapidly. So will be concise. Today will hopefully be a productive day, in terms of actual studying and work.

Yesterday I managed to setup an Apache, Subversion, & mySQL server. I also went out of my way to secure the machine, and to give it a dynamic DNS. So whenever its on, so is my website now. 😉 No, really have not done to much work on it. But here it is anyways: Celestia. I am pretty happy in the fact that I just need to setup three more things: my printer, my Palm and configure that pesky SQL server.

Have to run now.

Lurking in the Shadows…

Posted on by

Well its a new year, but I have been lurking mostly in the shadows. Nothing much happening, other than the start of classes. Life is the same as always. Chaotic. And my house is divided up into territories (rooms) held various factions (members). 😉 So far, I think the year is alright. Too early to tell naturally. But I hope that this year will be the year I really break out into the open.

Having said that, I started working intensely on a the new news and gallery pages for my two projects, justCheckers and Insomia. Seeing that I could join my work together in a simple cohesive whole, and the potential that it might be useful for more people than just me; I started a new project. This project, Simple Site, plans to create a simple, bare bones content management engine that will allow for developers to add news, and image gallery functionality into their sites. This engine will be so simple, that it will easily be modded into any custom website that uses PHP and MySQL. Now all I need to see if SourceForge will accept my proposal.

Well I am off, to play a short round of VegaStrike and work on Datasphere work.

One More Turn To Take

Posted on by

The purplish sand dunes flashed by as he accelerated his blue mlaren down the course. The magenta sky and the orange-yellow gas giant hung above him in a surreal but serene manner. One more sharp turn, he thought quietly to himself. The race had been a hard one, but now only a few more minutes and it would all be over. And he would emerge victorious.

These last few days have been nerve-racking. My lecture notes and preparation for the assignments pile up, while I continue on struggling with the mere set-up of my box. I have installed everything that I need and that I want. I have fought with getting my Palm, which now is safely and soundly synced with my computer. The software suspend and the splashscreen work partially. Fortunately that is nothing I have to worry about in the near future. Getting a virtual machine running was a hassle. Eventually it worked but not without a lot of arm twisting. It does like to sync with my laptop‘s native resolution, but I think that is because of the DGA mode. All my programs have been acting funny since I started that up. Again, in windowed mode everything works swell. So that is fine for this semester. As soon as the semester ends, the virtual machine is coming off my computer, along with Visual Studio .Net, Windows XP, and SQL Server.

Today alone, I got my web server up and running. The rest of the day was spent playing around with iptables, and so now I have a decent firewall running on my machine. Decent as in it literally chokes nmap when it attempts to scan for ports from the inside. I should try from my brother’s computer, but that would take too long and I am short on time. Heck, I did not go kayaking today even thought my parents insisted. This evening I tried to PHP running in safe mode, which it did. Unfortunately do to permissions issues, things behaved strangely. Silly me. All that is left is to play a second with mySQL for a few minutes and then set up my local Subversion repository. Then I am done.

I need a break, like a walk. I want to go but I think I might have to even stay up a bit, so I will refrain from leaving until EVERYTHING is set up. Then I will go for a walk.