Mysql Command Pages Links

http://www.pantz.org/software/mysql/mysqlcommands.html ( thank pantz )

Comments

Post a Comment

Popular posts from this blog

Byobu + Tmux Tips # 2014-01-22

Scenario#1     As a Byobu-Tmux user, I want to broadcast command to multiple panes. So that I don't have to do the same thing for each pane. solution#1 enter command mode => PREFIX + : active this feature => setw synchronize-panes on deactive => setw synchronize-panes off Scenario#2     As a Byobu-Tmus user, I want to have a shortcut to maximize/minimize current pane. So that I can see/work on specific pane efficiently. solution#1 edit ~/.byobu/keybindings.tmux fill-in these code below # maximum pane and restore unbind + bind + new-window -d -n tmux-zoom 'clear && echo TMUX ZOOM && read' \; swap-pane -s tmux-zoom.0 \; select-window -t tmux-zoom  unbind -  bind - last-window \; swap-pane -s tmux-zoom.0 \; kill-window -t tmux-zoom # resize pane bind H resize-pane -L 1 bind J resize-pane -D 1 bind K resize-pane -U 1 bind L resize-pane -R 1 Scenario#3     As a Byobu-Tmux...
Read more

Changing postgres password and warning

ORIGINAL from https://serverfault.com/questions/110154/whats-the-default-superuser-username-password-for-postgres-after-a-new-install CAUTION  The answer about changing the UNIX password for "postgres" through "$ sudo passwd postgres" is not preferred, and can even be  DANGEROUS ! This is why: By default, the UNIX account "postgres" is locked, which means it cannot be logged in using a password. If you use "sudo passwd postgres", the account is immediately unlocked. Worse, if you set the password to something weak, like "postgres", then you are exposed to a great security danger. For example, there are a number of bots out there trying the username/password combo "postgres/postgres" to log into your UNIX system. What you should do is follow  Chris James 's answer: sudo -u postgres psql postgres # \password postgres Enter new password: To explain it a little bit. There are usually two default ways to login to...
Read more

yoh, Sort dict

have a problem with sorting dict by value!!! found something interesting on http://code.activestate.com/recipes/304440/ by Nick Coghlan let's see >>d = {'a':0,'b':1,'c':2} >>d #will get {'a':0,'c':2,'b':1} some solution from Nick >>from operator import itemgetter >>print sorted(d.items(),key=itemgetter(1)) #we get [('a':0),('b':1),('c':2)] # >>>>> a list of tuples it might be useful in the future!!!:) thank nick and activestate
Read more