Re: [Observium] Initial setup on UIbuntu - SQL syntax error when creating the observium DB

Hi Reuben,

You assume correctly. However, the statement you entered in your mysql client is not the one from our documentation (so the syntax error is logical) - please try again.

Tom

PS: you could just paste the text instead of a screenshot of text...

On 08/09/2015 22:57, Reuben Sankey wrote:

Hi,

Im setting up Observium on ubuntu server 14.04.1 LTS. Using the guide:

http://www.observium.org/docs/debian_ubuntu/

All going well until I get to the SQL database bit and have issues:

mysql -uroot -p
<mysql root password>
mysql>CREATE DATABASE observium DEFAULT CHARACTER SETutf8 COLLATE
utf8_general_ci;
mysql>GRANT ALLPRIVILEGES ONobservium.*TO'observium'@'localhost'
-> IDENTIFIED BY'<observium db password>';

I assume the <observium db password> is to be replaced with a password? Inline image 1

Thanks and regards,

Reuben

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium