今回の一撃シェルスクリプトは、OSインストール直後のサーバーに対し、CMSの「WordPress」のインストールと起動をオートメーション化するものです。同時に、RDBMS「MySQL」やWebサーバー「nginx」、分散型メモリキャッシュシステムの「memcached」などのミドルウェア、WordPressをコマンドラインで操作 ...

MySQLではcharacter setやcollationをグローバル、データベース、テーブルやカラムレベルで設定することができます。今回はMySQLのデフォルトcollationの注意点を紹介したいと思います。

The mysql command-line interactive program is a very powerful way to access, display and even manipulate data without the need for any GUI at all. The basic commands are well worth learning, so if you ...

I've modified a bit of code that registers users in a DB encrypting passwords using bcrypt through phpass. This works fine. I've built change password functionality as well. The problem is that it ...

Look to these excellent tools to improve CLI and web admin, SQL queries, schema migration, and replication and recovery in your MySQL environment ...

This is likely because when I first learned it was with command-line tools, but even so, I think command-line database tools often are the best way to interact with a database manually. Two of the ...