34
ACCO NET
SATEL
sudo apt-get upgrade
– if you are logged in as another type of user
and pressing ENTER.
3. Install the MySQL program by entering the command:
apt-get install mysql-server
– if you are already logged in as an administrator;
sudo apt-get install mysql-server
– if you are logged in as another type of user
and pressing ENTER.
4. When the screen appears, create a password for the root administrator of the MySQL
database.
5. Log in to the database by entering the command:
mysql – u root -p
and pressing ENTER.
6. Enter the password for the user with root administrator privileges.
7. Grant the privileges to connect to the device on which ACCO Server is installed to the
root
administrator of the MySQL database by entering the command:
GRANT ALL PRIVILEGES ON * . * TO ‘root’@’192.168.9.11’ IDENTIFIED BY
‘password’;
and pressing ENTER.
Instead of “password”, enter the password created for the root administrator.
8. Grant the privileges to manage other users to the
root
administrator of the MySQL
database by entering the command:
GRANT USAGE ON * . * TO ‘root’@’192.168.9.11’ WITH GRANT OPTION;
and pressing ENTER.
9. Refresh the settings of edited privileges by entering the command:
FLUSH PRIVILEGES;
and pressing ENTER.
10. Exit the database by entering the command:
EXIT
and pressing ENTER.
11. Allow remote access to the database by entering the command:
nano /etc/mysql/my.cnf
and pressing ENTER.
12. Change the part of the code
bind-address
= 127.0.0.1
to a comment by typing
#
before
it:
# bind-address = 127.0.0.1
Save your changes by pressing the Ctrl and O keys at the same time. Then press
ENTER.
13. Exit the file by pressing the Ctrl and X keys at the same time.
14. Restart the MySQL program to enter new settings by entering the command:
service mysql restart
and pressing ENTER.
