What follows is a collection of links that deal with common character set issues in MySQL setups.

https://wincent.com/wiki/Finding_out_the_encoding_of_a_MySQL_database
This short article desribes how to find out the current encoding settings of a MySQL database.

https://dev.mysql.com/doc/refman/5.5/en/charset-connection.html
This is the official documentation of character set manipulation in MySQL 5.5.

http://mysqldump.azundris.com/archives/60-Handling-character-sets.html
This article describes in detail how characters are represented in the database. Basically, it introduces how character encodings work.

Create a user that is allowed to log in from anywhere (with or without password ‘123’):

Create a user that is allowed to log in only from localhost:

Remove a user:

Show permissions for a user:

Grant all privileges on a specific database to a user:

Grant all privileges on all databasesto a user (optionally with right to grant to other users):

Remove permissions of a user (w.r.t. a specific database):

Remove permissions of a user globally:

References

  • [1] MySQL 5.1 Reference, Chapter 6.3 on user account security (overview)
  • [2] MySQL 5.1 Reference, Chapter 13.7.1 on user account management