Grafana Installation
From r00tedvw.com wiki
(Difference between revisions)
(Created page with "==Add Repository== <nowiki>echo 'deb https://packagecloud.io/grafana/stable/debian/ wheezy main' | sudo tee -a /etc/apt/sources.list</nowiki> ==Add Key== <nowiki>curl https...") |
(→Setup MySQL) |
||
| Line 13: | Line 13: | ||
~$ mysql> exit</nowiki> | ~$ mysql> exit</nowiki> | ||
verify permissions have been granted | verify permissions have been granted | ||
| − | <nowiki>~$ mysql -u grafana -p | + | <nowiki>~$ mysql -u grafana -p |
~$ mysql> SHOW GRANTS; | ~$ mysql> SHOW GRANTS; | ||
+---------------------------------------------------------------------------------------------------------------+ | +---------------------------------------------------------------------------------------------------------------+ | ||
Revision as of 13:30, 30 June 2016
Contents |
Add Repository
echo 'deb https://packagecloud.io/grafana/stable/debian/ wheezy main' | sudo tee -a /etc/apt/sources.list
Add Key
curl https://packagecloud.io/gpg.key | sudo apt-key add -
Install Grafana, MySQL, Apache
sudo apt-get update && sudo apt-get install grafana mysql-server apache2 -y
Note: Remember to document the MySQL root password.
Setup MySQL
~$ mysql -u root -p ~$ mysql> CREATE USER 'grafana'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED'; ~$ mysql> CREATE DATABASE grafanadatabase; ~$ mysql> GRANT ALL PRIVILEGES ON grafana.* TO 'grafana'@'localhost' IDENTIFIED BY 'grafanauserpassword' WITH GRANT OPTION; ~$ mysql> exit
verify permissions have been granted
~$ mysql -u grafana -p ~$ mysql> SHOW GRANTS; +---------------------------------------------------------------------------------------------------------------+ | Grants for grafana@localhost | +---------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'grafana'@'localhost' IDENTIFIED BY PASSWORD '*2K21458K438UYE85A38B9Y7Y78DAEBF4T8689YK4' | | GRANT ALL PRIVILEGES ON `grafanadatabase`.* TO 'grafana'@'localhost' WITH GRANT OPTION | +---------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
