mac connection issues

go to KeyChain Access.  If you are using certificate for connection, there may be extraneous entries in the “login” section (left hand side).  Remove them.

block ip from ssh

/etc/hosts.deny ALL: 23.234.61.51   (substitute all for whatever daemon name)

Mysql create database then create user. New user can’t login

When you try to login to mysql with a newly created user, you may get:   ERROR 1044 (42000): Access denied for user Try to ensure the user’s been granted sufficient privileges for the database.   For example, create databases db; create user ‘blah’@’localhost’ with password ‘password’; grant all privileges on db.* to ‘blah’@’%’;  <—–IMPORTANT. […]

mod_status results in 404 page not found in drupal

with default config, you get 404 when accessing http://localhost/server-status with mod_status enabled. Try adding:   RewriteCond %{REQUEST_URI} !=/server-status to .htaccess. i.e. only do the rewrite thing if request isn’t for server-status. so your .htaccess would look like this: # Pass all requests not referring directly to files in the filesystem to # index.php. Clean URLs […]

mysql prompt show utf8

start mysql prompt with  –default-character-set=utf8 option, like: mysql -u root -p -h  –default-character-set=utf8

format var_dump output

To format var_dump properly with nested arrays and such, put <pre> <?php var_dump($blah); ?> </pre>

sina weibo rss autopost

Seems like sina weibo removed or is hiding their rss -> auto post functionality from their settings page.  Well, the link to do that is here:   http://www.weibo.com/tool/bloglink