Installation mysql5.1 (linux (red hat 3))
I see pros and cons of Spring Security
Recommended circle: rights management for more recommended [MYSQL] to create a remote login user and authorize Database 2009-04-29 14:07:01 268 Comments 0 read font size: large, medium and authorized users to create a remote login> grant all PRIVILEGES on discuz. * to ted @ '123 .123.123.123 'identified by '123456'; the above statement that the database will discuz ted all the rights licensed to the user, allowing users to 220.127.116.11 the IP ted remote login, and set the user's password ted is 123456.
The following analysis of all the parameters one by one:
all PRIVILEGES that all of the privileges granted to authorized users, there can also be replaced to give a specific authority, such as: select, insert, update, delete, create, drop, etc., between the use of specific rights, "" comma-separated.
discuz .* that the above permission which is against the table, discuz refers to the database, the latter * that for all of tables, it can be inferred that: For all databases for all of tables authorized "*.*", a database of all the tables authorized "database name .*", a table for a database license for the "database name. table name."
ted that which you give the user authorization, the user may be existing users, can also be non-existent users.
18.104.22.168 that allow remote connection IP address, if you want no restrictions on the IP link is set to "%" can be.
123456 for the user's password.
Implementation of the above statements, then execute the following statement before effective immediately.
> Flush privileges;