Changes

From Amahi Wiki
Jump to: navigation, search

Guacamole (view source)

Revision as of 22:13, 9 October 2016

380 bytes removed ,  22:13, 9 October 2016
→‎Making the MySQL Tables
{{Code| Code = sudo systemctl restart mariadb.service}}
==== Making Loading Guacamole's schema into the MySQL Tables ====Now we need The schema for MySQL was downloaded in the previous process.Just change directories to create a MySQL Table that Guacamole can usethe files location
{{Code|
Code = $ cd /var/hda/web-apps/guacamole/sqlauth/guacamole-auth-jdbc-0.9.9/mysql/schema/ }}and run the following commandsudo cat ./*.sql | mysql -u root -pEnter password: default for Amahi is hdamysql> CREATE DATABASE guacamole;Query OK, 1 row affected (0.00 sec)guacdb
mysql> CREATE USER 'guacamole'@'localhost' IDENTIFIED BY 'some_password';Query OK, 0 rows affected (0.00 sec) mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON guacamole.* TO 'guacamole'@'localhost';Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES;Query OK, 0 rows affected (0.02 sec) mysql> quitBye}}The database and password requested is the root user can be named whatever you like, but the above coding steps refer to both as "guacamole". Naturally, you should choose a real password for your user rather than the string "some_password" shown aboveMySQL.
==== Running the SQL scripts ====
Raymond Jones
128

edits

Retrieved from "https://wiki.amahi.org/index.php/Special:MobileDiff/105126"