The Video is available in HD
Category: MySQL
āĻŽāĻžāĻā§ āĻŽāĻžāĻā§āĻ āĻāĻŽāĻ¨ āĻšā§ āĻ¯ā§ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ā§āĻ° āĻ°ā§āĻ āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻā§āĻā§āĻ āĻĒāĻžāĻā§āĻž āĻ¯āĻžāĻā§āĻā§ āĻ¨āĻž āĨ¤ āĻŦā§āĻļā§āĻ°āĻāĻžāĻ āĻā§āĻˇā§āĻ¤ā§āĻ°ā§āĻ āĻĻā§āĻāĻž āĻ¯āĻžā§ āĻ¸āĻžāĻ°ā§āĻāĻžāĻ° āĻĒā§āĻ°āĻĨāĻŽāĻŦāĻžāĻ° āĻ¸ā§āĻāĻžāĻĒ āĻāĻ°āĻžāĻ° āĻ¸āĻŽā§ āĻŦā§āĻļ āĻļāĻā§āĻ¤ āĻĒā§āĻā§āĻ¤ āĻ°ā§āĻ āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻ¸ā§āĻ āĻāĻ°āĻž āĻšā§, āĻāĻ°āĻĒāĻ° āĻ¨āĻŋāĻā§āĻ° āĻā§āĻ¯āĻžāĻĒā§āĻ˛āĻŋāĻā§āĻļāĻ¨ āĻāĻ° āĻāĻ¨ā§āĻ¯ āĻ¨āĻ¤ā§āĻ¨ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻāĻāĻāĻžāĻ° āĻ¤ā§āĻ°āĻŋ āĻāĻ°ā§ āĻ¨ā§āĻ āĨ¤ āĻ°ā§āĻ āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄāĻāĻž āĻā§āĻĨāĻžāĻ āĻ¨ā§āĻ āĻāĻ°ā§ āĻ¨āĻž āĻ°āĻžāĻāĻ˛ā§ āĻĒāĻ°āĻŦāĻ°ā§āĻ¤ā§āĻ¤ā§ āĻāĻāĻž āĻāĻ° āĻŽāĻ¨ā§ āĻāĻ°āĻ¤ā§ āĻĒāĻžāĻ°āĻŋ āĻ¨āĻž āĨ¤ āĻāĻ°āĻāĻŽ āĻĒāĻ°āĻŋāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋāĻ¤ā§ āĻ°ā§āĻ āĻāĻāĻāĻžāĻ°ā§āĻ° āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄāĻāĻž āĻ°āĻŋāĻ¸ā§āĻ āĻāĻ°āĻž āĻāĻžā§āĻž āĻā§āĻ¨ āĻāĻĒāĻžā§ āĻĨāĻžāĻā§ āĻ¨āĻž āĨ¤
āĻāĻ āĻŦā§āĻ˛āĻ āĻĒā§āĻ¸ā§āĻā§ āĻāĻŽāĻ°āĻž āĻĻā§āĻāĻŦā§ āĻāĻŋāĻāĻžāĻŦā§ āĻāĻŽāĻ°āĻž āĻ¸āĻšāĻā§āĻ āĻāĻŦā§āĻ¨ā§āĻā§āĻ¤ā§ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ā§āĻ° āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻ°āĻŋāĻ¸ā§āĻ āĻāĻ°ā§ āĻ¨āĻŋāĻ¤ā§ āĻĒāĻžāĻ°āĻŋ āĨ¤ āĻ¯āĻĻāĻŋāĻ āĻāĻŦā§āĻ¨ā§āĻā§āĻ° āĻāĻ¨ā§āĻ¯ āĻāĻŽāĻžāĻ¨ā§āĻĄ āĻā§āĻ˛ā§ āĻ˛ā§āĻāĻž, āĻāĻā§āĻ˛ā§ āĻĄā§āĻŦāĻŋā§āĻžāĻ¨ āĻ˛āĻŋāĻ¨āĻžāĻā§āĻ¸ā§āĻ āĻāĻžāĻ āĻāĻ°āĻžāĻ° āĻāĻĨāĻž āĨ¤ āĻāĻ° āĻ āĻ¨ā§āĻ¯ āĻā§āĻ¨ āĻĄāĻŋāĻ¸ā§āĻā§āĻ°ā§āĻ° āĻā§āĻˇā§āĻ¤ā§āĻ°ā§ āĻ¸āĻžāĻŽāĻžāĻ¨ā§āĻ¯ āĻĒāĻ°āĻŋāĻŦāĻ°ā§āĻ¤āĻ¨ āĻāĻ°āĻž āĻ˛āĻžāĻāĻ¤ā§ āĻĒāĻžāĻ°ā§ āĨ¤
āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻ¸āĻžāĻ°ā§āĻāĻŋāĻ¸ āĻŦāĻ¨ā§āĻ§ āĻāĻ°āĻž
āĻ°ā§āĻ āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻ°āĻŋāĻ¸ā§āĻ āĻāĻ°āĻ¤ā§ āĻā§āĻ˛ā§ āĻāĻŽāĻžāĻĻā§āĻ° āĻĒā§āĻ°āĻĨāĻŽā§āĻ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻāĻ° āĻ¸āĻžāĻ°ā§āĻāĻŋāĻ¸ āĻŦāĻ¨ā§āĻ§ āĻāĻ°āĻ¤ā§ āĻšāĻŦā§ āĨ¤ āĻāĻŦā§āĻ¨ā§āĻā§āĻ° āĻāĻ¨ā§āĻ¯:
|
1 |
sudo service mysql stop |
āĻ āĻĨāĻŦāĻž, āĻĄā§āĻŦāĻŋā§āĻžāĻ¨ āĻāĻŦāĻ āĻāĻŦā§āĻ¨ā§āĻā§ āĻĻā§āĻā§āĻ¤ā§āĻ āĻāĻžāĻ āĻāĻ°āĻŦā§ āĻāĻ āĻāĻŽāĻžāĻ¨ā§āĻĄāĻāĻŋ:
|
1 |
sudo /etc/init.d/mysql stop |
āĻā§āĻ°āĻžāĻ¨ā§āĻ āĻā§āĻŦāĻŋāĻ˛ āĻāĻžā§āĻžāĻ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻ°āĻžāĻ¨ āĻāĻ°āĻž
āĻāĻŦāĻžāĻ° āĻāĻŽāĻžāĻĻā§āĻ° āĻ¯ā§āĻāĻž āĻāĻ°āĻ¤ā§ āĻšāĻŦā§ āĻ¤āĻž āĻšāĻ˛ā§ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻāĻ° āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻā§āĻ āĻāĻ°āĻž āĻšā§ āĻ¯ā§āĻ āĻā§āĻŦāĻŋāĻ˛āĻāĻž āĻĨā§āĻā§, āĻ¸ā§āĻāĻŋāĻā§ āĻ¸ā§āĻāĻŋāĻĒ āĻāĻ°ā§ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻāĻžāĻ˛ā§ āĻāĻ°āĻžāĨ¤ āĻāĻāĻž āĻ¸ā§āĻāĻŋāĻĒ āĻāĻ°āĻ˛ā§ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻāĻ° āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻā§āĻ āĻāĻ°āĻŦā§ āĻ¨āĻž āĻāĻā§āĻ° āĻŽāĻ¤ āĻāĻ°ā§āĨ¤ āĻĢāĻ˛ā§ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻ āĻāĻŽāĻ°āĻž āĻ°ā§āĻ āĻā§āĻ¯āĻžāĻāĻžāĻāĻ¨ā§āĻ āĻ āĻā§āĻ¯āĻžāĻā§āĻ¸ā§āĻ¸ āĻāĻ°āĻ¤ā§ āĻĒāĻžāĻ°āĻŦā§ āĻā§āĻ¨ āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻāĻžā§āĻžāĻ āĨ¤
|
1 |
sudo mysqld --skip-grant-tables & |
āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻ°āĻŋāĻ¸ā§āĻ āĻāĻ°āĻž
āĻāĻāĻŦāĻžāĻ° āĻāĻ āĻāĻŽāĻžāĻ¨ā§āĻĄāĻāĻŋ āĻ°āĻžāĻ¨ āĻāĻ°āĻŋ:
|
1 |
mysql -u root mysql |
āĻāĻ āĻāĻŽāĻžāĻ¨ā§āĻĄāĻāĻŋ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻ¸āĻžāĻ°ā§āĻāĻžāĻ°ā§ āĻāĻžāĻ¨ā§āĻā§āĻ āĻāĻ°āĻŦā§ āĻāĻŦāĻ mysql āĻĄāĻžāĻāĻžāĻŦā§āĻāĻāĻāĻŋ āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻāĻ°āĻžāĻ° āĻāĻ¨ā§āĻ¯ āĻ¸āĻŋāĻ˛ā§āĻā§āĻ āĻāĻ°āĻŦā§ āĨ¤
āĻāĻāĻŦāĻžāĻ° āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻĒāĻ°āĻŋāĻŦāĻ°ā§āĻ¤āĻ¨ āĻāĻ°āĻžāĻ° āĻĒāĻžāĻ˛āĻž āĨ¤ āĻāĻāĻžāĻ° āĻāĻ¨ā§āĻ¯ āĻāĻŽāĻ°āĻž āĻāĻ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻā§ā§ā§āĻ°āĻŋāĻāĻž āĻāĻžāĻ˛āĻžāĻŦā§:
|
1 |
UPDATE user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit; |
āĻāĻ āĻā§ā§ā§āĻ°āĻŋ āĻāĻŽāĻžāĻĻā§āĻ° āĻ°ā§āĻ āĻāĻāĻāĻžāĻ°ā§āĻ° āĻāĻ¨ā§āĻ¯ āĻ¨āĻ¤ā§āĻ¨ āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ (āĻāĻā§āĻˇā§āĻ¤ā§āĻ°ā§ NEW_PASSWORD) āĻā§āĻ¯āĻžāĻ¸āĻžāĻāĻ¨ āĻāĻ°āĻŦā§, āĻĒā§āĻ°āĻŋāĻāĻŋāĻ˛ā§āĻ āĻĢā§āĻ˛āĻžāĻļ āĻāĻ°āĻŦā§ (āĻ¸āĻšāĻ āĻāĻžāĻˇāĻžā§ āĻĒāĻžāĻ°ā§āĻŽāĻŋāĻļāĻ¨ āĻ°āĻŋāĻ˛ā§āĻĄ āĻāĻ°āĻŦā§) āĻāĻŦāĻ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻ¸āĻžāĻ°ā§āĻāĻžāĻ° āĻĨā§āĻā§ āĻĄāĻŋāĻ¸āĻāĻžāĻ¨ā§āĻā§āĻ āĻāĻ°āĻŦā§ āĨ¤
āĻĒā§āĻ¨āĻ°āĻžā§ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻ¸ā§āĻŦāĻžāĻāĻžāĻŦāĻŋāĻāĻāĻžāĻŦā§ āĻ°āĻžāĻ¨ āĻāĻ°āĻž
āĻāĻŽāĻ°āĻž āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ā§āĻ° āĻĒāĻžāĻ°ā§āĻŽāĻŋāĻļāĻ¨ āĻā§āĻ āĻā§ āĻĢāĻžāĻāĻŋ āĻĻāĻŋā§ā§ āĻ°ā§āĻ āĻāĻāĻāĻžāĻ°ā§āĻ° āĻāĻ¨ā§āĻ¯ āĻ¨āĻ¤ā§āĻ¨ āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻ¸ā§āĻ āĻāĻ°ā§ āĻĻāĻŋā§ā§āĻāĻŋ āĨ¤ āĻāĻāĻ¨ āĻāĻŽāĻ°āĻž āĻ¨āĻ°āĻŽāĻžāĻ˛āĻŋ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻ¸āĻžāĻ°ā§āĻāĻžāĻ° āĻāĻžāĻ˛āĻžāĻ˛ā§āĻ āĻ¨āĻ¤ā§āĻ¨ āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄ āĻāĻžāĻ āĻāĻ°āĻŦā§ āĨ¤ āĻāĻāĻ¨ā§āĻ¯ āĻāĻŽāĻ°āĻž āĻāĻŽāĻžāĻĻā§āĻ° āĻāĻāĻā§ āĻāĻā§ āĻ°āĻžāĻ¨ āĻāĻ°āĻž mysqld āĻĒā§āĻ°āĻ¸ā§āĻ¸āĻāĻŋ āĻāĻžāĻ°ā§āĻŽāĻŋāĻ¨ā§āĻ āĻāĻ°ā§ āĻŽāĻžāĻāĻ¸āĻŋāĻā§ā§ā§āĻ˛ āĻ°āĻŋāĻ¸ā§āĻāĻžāĻ°ā§āĻ āĻĻāĻŋāĻŦā§ āĨ¤
|
1 2 |
sudo killall mysqld sudo service mysql start |
āĻŦā§āĻ¯āĻžāĻ¸, āĻāĻāĻ¨ āĻāĻŽāĻžāĻĻā§āĻ° āĻ¨āĻ¤ā§āĻ¨ āĻ¸ā§āĻ āĻāĻ°ā§ āĻĻā§āĻā§āĻž āĻĒāĻžāĻ¸āĻā§āĻžāĻ°ā§āĻĄāĻ āĻāĻžāĻ āĻāĻ°āĻŦā§!
In one of my old posts, I noted short documentation on how to get started with the AMP stack on Mac OS X Lion. In that setup, I was using the default PHP and downloaded MySQL from the mysql website. In this post, I am going to describe how I used homebrew to setup my AMP environment with ease!
The Homebrew Magic
Homebrew is a cool tool for Mac OS users. Written in Ruby, this beautiful tool works as a package manager for Mac OS. Unlike Mac Ports or Fink, homebrew takes less space, uses the default os x tools to compile everything to a custom location. This makes life suck less and clutter free!
To install PHP 5.4 branch using homebrew, just issue this command:
|
1 2 3 |
brew tap josegonzalez/php brew update brew install php54 |
PS: If you want to customize the installation (like installing the mysql module by default) add necessary configuration options. Using the “bash-completion” formula from brew, you can hit tabs to see available installation options.
To view information on your PHP 5.4 installation via brew, type in:
|
1 |
brew info php54 |
Seperate MySQL Installation: Where is the ctl?
I have installed MySQL separately. I added the mysql and mysqldmin to my bash_profile like this:
|
1 2 |
alias mysql=/usr/local/mysql/bin/mysql alias mysqladmin=/usr/local/mysql/bin/mysqladmin |
And to start/stop/restart mysql server, I added:
|
1 |
export mysqlctl=/Library/StartupItems/MySQLCOM/MySQLCOM |
That allows me to do:
|
1 |
sudo $mysqlctl restart |
Using PEAR
Homebrew installs all the PEAR packages to “/usr/local/Cellar/php54/5.4.3/lib/php”. So, I added it to my php include_path.
For PEAR to work correctly, we need sudo. If there are tools involved in the pear setup which can be run from command line (eg. phpunit), the binary files are stored in: “/usr/local/Cellar/php54/5.4.3/bin”.
I added the above path to my .bash_profile for convenience đ