Saturday, November 17, 2018

WAMP Server Reset Root Password

I recently wanted to install Joomla 4 Beta and discovered I need PHP 7 or higher. I am running XXAMP and only PHP 5.6. I also have WAMP installed and have a bunch of sites started in there. My WAMP would start; however, the sites couldn’t connect to the database.

I looked in the “C:\WAMP\apps\myphpadminX.X.X\config.inc.php” file and the password was what I thought it was. I tried a bunch of things including using the MySQL Console but this article got me working again.

https://stackoverflow.com/questions/29070501/regaining-access-to-lost-mysql-password-for-phpmyadmin-on-wamp

The lines in my “wampserver >> MySQL >> my.ini” file in the looked like this:

# The MySQL server
[wampmysqld]
#skip-grant-tables

I assumed the “#” was a comment so I removed it. I didn’t have to add it. It looked like this:

# The MySQL server
[wampmysqld]
skip-grant-tables

Restarted everything and I could log into PHPmyAdmin and all the sites were now connecting.

I hope this helps someone else out there…

 

Joomla Site Clean Up Tools

Here is a list of “Tools of the Trade” according to Ben Martin at Sucuri Security.

  • Filezilla (FTP Client)
  • NoScript (Script Blocker)
  • VirtualBox (Virtualization Tool)
  • ublock Origin (Ad Blocker)
  • PHPMyAdmin or Adminer (Database Management)
  • User Agent Switcher
  • Support Forums (ie: https://forum.joomla.org)
  • OSSEC HIDS (Server Monitoring)
  • SSH / BASH connection

I hope this helps someone else out there…

 

Joomla – Fabrik – 0 Unable to connect to the Database:

I had a Fabrik project that I wanted so show someone and when I got there I saw this message.

0 Unable to connect to the Database: This driver is unsupported in PHP 7, please use the MySQLi or PDO MySQL driver instead.

My Joomla was version Joomla! 3.8.6. I had recently upgraded the server to PHP 7, so I found what broke it. I found this article to get me started.

http://fabrikar.com/forums/index.php?threads/if-in-joomla-3-5-you-get-this-driver-is-unsupported-in-php-7-try.43721/

I needed my Joomla! version and I found in the backend >>  System >> System information.

The solution was to change the SQL driver in Administrator side to “MySQLI(PDO)”. You get there by going to Global Configuration >> Server, and it will be in the upper right.

I hope this helps someone else out there…

 

Joomla – The MySQL server is running with the –read-only option so it cannot execute this statement SQL=DELETE FROM `#__session` WHERE `time` < '1479401841'

After deleting the website in fear it was attacked I discovered this article about simply deleting and adding back the sessions database.

How do I fix a corrupt Joomla jos_session table

This may have been my fix. If I have time I will try to restore what I have, see if I get the same error, and see if this fix helps.

I hope this helps someone else out there…