MySQL

Why New Domain Keeps Forwarding to Old Domain [Solution]

After changing a domain name and updating the DNS records you might find yourself baffled by the fact that the site continues to redirect to the old domain. You may be frustrated as you have seemingly tried everything. Likely, you are dealing with a WordPress site. With a WordPress website, references to the domain name… Read more Why New Domain Keeps Forwarding to Old Domain [Solution]

How to Reset the ROOT Password for MySQL on Mac OS 10.10

This post explains how to reset the MySQL root user on a Mac running OS 10.10. This procedure is for the case that you are unable to log in as the root user and need to reset the root user’s password. Note that there are 2 colored sets of examples. One is for MySQL installed… Read more How to Reset the ROOT Password for MySQL on Mac OS 10.10

Change the Root Password on Mac OS 10.10

There is a small change to the way to update the root password for MySQL in Mac OS 10.10. If you do not have a root password already, then log into mysql like this (otherwise use your password):

Then tell mysql you want to ‘use’ the mysql database. Before version MySQL 5.7 , the… Read more Change the Root Password on Mac OS 10.10

How to Set Up MySQL Workbench on a MAMP Server

My main reason for using MySQL Workbench, at least for now, is for the really cool Data Modeling tools. It a bit of a pain to MySQL Workbench up for MAMP, though. To set mySQL workbench up for MAMP, I found the following to work after scouring the internet and finding this simple to the… Read more How to Set Up MySQL Workbench on a MAMP Server

How to Export a Large MySQL Table on MAMP to a CSV File

You many need to export a data base table that is larger than phpMyAdmin’s maximum allowed size (in the export table tab). An easy way to do this by using the terminal. I have provided a simple example below for MAMP users like me. This information is based on a blog post I found on… Read more How to Export a Large MySQL Table on MAMP to a CSV File

PHP and MySQL command line with MAMP on OSX

I found a handy article named “Getting command line access to PHP and MySQL running MAMP on OSX” by  Joaquin Lippincott . It was very helpful for getting PHP and MySQL acces from the terminal on a mac. In addition, one of the comments by Matthew Bacon was about getting the ZEND FRAMWORK up and running… Read more PHP and MySQL command line with MAMP on OSX

MySQL from the Command Line (terminal) in MAMP PRO

To get to the command line for MySQL for MAMP or MAMP PRO just open up you terminal and enter the following:   /Applications/MAMP/Library/bin/mysql –host=localhost -uroot -proot You can see all the databases by using the following command: If you type the MySQL command : USE <table name>  you can then start using that particular… Read more MySQL from the Command Line (terminal) in MAMP PRO

Import WordPress Database from Staging Server to Local Development Server

You may be working with a WordPress project and wish to use SVN to have a development instance, a staging instance, a local development instance and of course a production instance of the web site. This could prove to be problematic in keeping track of your data base instances. WordPress stores the root URL (http://website.com)… Read more Import WordPress Database from Staging Server to Local Development Server