a record of thoughts

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 [...]