Techno-babble for the Masses!
Ralph on April 12th, 2017.
Here are the commands you need to execute to change a forgotten MySQL root user password: Step # 1 : Stop the MySQL service: Step # 2: Start the MySQL server w/o password: Step # 3: Connect to the MySQL server using the MySQL client: Step # 4: Set a new MySQL root user password: […]
Ralph on June 7th, 2016.
Ensure it’s not accessible by any clients, if you use a load balancer, you should take it off temporarily. Connect to the MySQL Server via the command line: Stop the replication: Now is a good time to make any changes you want to. Resume replication: Check the status to confirm replication is running normally, and […]
Ralph on August 31st, 2015.
1. Identify public IP address: 2. Edit /etc/mysql/my.cnf, replacing the value for bind-address, usually 127.0.0.1 with your public IP address derived above: 3. Type the following to enter the MySQL shell and provide your password: 4. Grant remote access to the desired MySQL user with the following command, replacing ‘root’ with the desired user and […]
Ralph on July 31st, 2014.
In this article, I will show you how to install Apache 2.4, PHP 5.5 and MySQL. I’m running a standard Windows 8.1 64-bit setup without Xampp or Wamp. I will be showing you how to add PHP 5.5 as a module in Apache 2.4. Step 1: Downloads Apache: Download Apache 2.4 binaries from ApacheLounge.com. You […]