Installation guide

Service Scheduler – Installation Guide
Version 0.8
Page 16 of 42
Copyright © ABit Consulting 2011
Run the following SQL commands
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Replace username and password with your details (eg username = abit)
MySQL Server on Linux
Install MySQL via your Linux distributions recommended methods (eg apt-get)
Ensure that the server is configured to listen no just on local host in in my.cnf bind-address
setting.
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 0.0.0.0
Create privileged user with external access
Mysql –u root –p
Run the following SQL commands
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Replace username and password with your details (eg username = abit)