|
|
 |
 MySQL- How to see only the database of users authorized..
- Execute SQLGate for MySQL.
- Select [Server] | [User Manager]
- Set Host value and ID / Password after selecting [User Add]
The data the that user can access denpends on the value of Host.
Host = % => Connection is possible anywhere outside.
Host = localhost => Connection is possible only with MySQL Server.
Host = 192.168.1.21 => Connection is possible only with the current IP.
- Do not select any Priviliges values.
- Select [OK].
- Select [Table / Column authority] on the top bar.
- Select a database that is authorized.
- Select authority of user.
- Select [Grant].
|
