mysql

MySQL for Mac OS X

Get MySQL from dev.mysql.com Make alias for Terminal alias mysql=/usr/local/mysql/bin/mysql alias mysqladmin=/usr/local/mysql/bin/mysqladmin if you want to make the alias permanent, you need to create / edit a file call [.bash_profile] nano ~/.bash_profile and add the command to the file save and exit. reference Reset MySQL server root account password $ cd /usr/local/mysql/bin $ ./mysqladmin -u …

MySQL for Mac OS X Read More »

WordPress Change Domain stepts

Just find a post about moving domain and change domain name for wordpress blog @ mydigitallife.info This post use MySQL replace() function to modify the database To update WordPress options with the new blog location, use the following SQL command: UPDATE wp_options SET option_value = replace(option_value, ‘http://www.old-domain.com’, ‘http://www.new-domain.com’) WHERE option_name = ‘home’ OR option_name = …

WordPress Change Domain stepts Read More »

MAC OSX Web Server path note

hosts /private/etc/hosts Apache httpd.conf /private/etc/apache2/http.conf Apache virtual httpd.conf /private/etc/apache2/users/[username].conf MySQL /usr/local/mysql/bin/mysql /usr/local/mysql/bin/mysqladmin

Use mysql in OSX terminal

The installation process do not make the alias to the MySQL installation path so here is what I do. alias mysql=/usr/local/mysql/bin/mysql alias mysqladmin=/usr/local/mysql/bin/mysqladmin Link: http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html MySQL Reference for OS X First to login you use the following mysql -u [username] -p e.g. mysql -u root -p Link: http://www.comentum.com/mysql-administration.html