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]
Reset MySQL root Password in OSX 10.10 + Doh! Forgot the MySQL root password for the local MAc OS 10.x ! Let me say first, check your project config files to see if you can find it (duh). If that does not work, or if you just plain want to reset the local root password… Read more RESET MYSQL ROOT PASSWORD OSX
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
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): $> mysql -u root Then tell mysql you want to ‘use’ the mysql database. Before version MySQL… Read more Change the Root Password on Mac OS 10.10
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
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
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
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
After importing a relativly huge table into my local dev using MAMP, I was experiencing MySQL hangups on large queries that when on a live site would be no problem. To fix this I made the following adjustments to the MAMP PRO my.cnf file. The my.cnf file is edited in MAMP PRO pulldown menu by… Read more MAMP: Dealing with HUGE MySQL Queries
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