Posts Tagged ‘privilege’

MySQL: Add User


2008
10.28

To create a database and give a user privilege to that database:

mysql> CREATE DATABASE temp;
mysql> GRANT ALL PRIVILEGES ON temp.* TO 'bob'@'EEEPC'
    -> IDENTIFIED BY 'alice'
    -> WITH GRANT OPTION;

The privilege is full for Bob for all tables contained in the database called temp. Here, I explicitly defined the user’s host. That means Bob can only access the server if he used my Eee-PC. Even local access for Bob is not allowed because I did not add ‘bob’@'localhost’ in the GRANT command.

Mass Transit Privileges


2008
08.25

I was on the bus today and at a stop, a woman at around her 50s climbed the bus. The bus isn’t full, just a loose. The woman didn’t walk all the way to the back, instead she stood in front of me, hoping to get a seat because there’s an empty seat, but another man’s things are on it. The man just took a glance at her and did not do anything. He’s a black man. The man just went along with what he was doing and finally gathered his things as he’s nearing his stop. The woman, whom I suspect is Filipino and I can only describe as someone who has the attitude and demeanor of a Spaniard. So if you’re a Filipino reading this, quickly gather your thoughts on what a Kastila is like for a moment. The woman took the seat after the man took everything off of it. (more…)