Ad Widget

Collapse

noob MSQL install question.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bookduck
    Junior Member
    • Jun 2009
    • 2

    #1

    noob MSQL install question.

    I'm a lnux noob with running unbutu server and have spent many days (and a good few nights) trying to get this software to install and getting nowhere. Makes me think, 'if I can't get the installation working, the rest of the product does not stand much chance?'

    I'm following this wiki http://www.zabbix.com/wiki/doku.php?...:ubuntuinstall

    I've typed in this from -> 3 - Create a zabbix database and populate it:

    sudo mysql -e"create database zabbix;" ----> then
    sudo mysql -e "grant all privileges on zabbix.* to zabbix@localhost identified by 'enter-password-here';" ---> firstly I would not work with out a space after the '-e', and secondly I get a GNU nano screen (attached pic) into which I typed in the line below, but now what do I do now?

    mysql -D zabbix -uzabbix -pzabbix < /home/zabbix/zabbix-1.6.4/create/schema/mysql.sql

    thanks
    Attached Files
  • tchjts1
    Senior Member
    • May 2008
    • 1605

    #2
    Instead of using that particular set of commands, I use this:

    Create a zabbix database and populate it:
    Start mysql – sudo /etc/init.d/mysql start
    Code:
    sudo mysql
    create database zabbix;
    grant all on zabbix.* to zabbix@’localhost’ identified by ‘password’;
    quit;
    From /home/zabbix/zabbix-1.6.4/
    Code:
    cd create/schema
    cat mysql.sql | mysql -uzabbix -ppassword zabbix
    cd ../data
    cat data.sql | mysql -uzabbix -ppassword zabbix
    cat images_mysql.sql | mysql -uzabbix -ppassword zabbix

    Comment

    Working...