ISR Computing -

How to create MySQL user

Connect to "mysql" database

use mysql;

Create new user

INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv) VALUES ('localhost', 'netflowuser', PASSWORD('mypassword'), 'Y', 'Y', 'Y');

Reload privileges

FLUSH PRIVILEGES;

Test permissions

SELECT host, user, password FROM user WHERE user = 'netflowuser';

Let's say you have table called flows, then you can grant permissions to insert, update, create to user "netflowuser"

GRANT insert,update,create,execute ON flows.* TO netflowuser;