Ralph

Ralph

Techno-babble for the Masses!


Navigation
TagMySQL
Featured

General

MySQL: Reset Root Database User’s Password

Posted byuserRalph 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: […]

Featured

General

Safely Restart a MySQL Slave Server

Posted byuserRalph 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 […]

Featured

General

How To: Enable Remote MySQL Connections on Ubuntu Server

Posted byuserRalph 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 […]

Featured

General

How To: Install Apache 2.4, PHP 5.5 and MySQL on Windows – Part 1

Posted byuserRalph 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 […]