Ad Widget

Collapse

Can't create MySQL schema

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mandy hughes
    Junior Member
    • Jul 2007
    • 2

    #1

    Can't create MySQL schema

    [zabbix@lnm-mgt-tm003 schema]$ cat mysql.sql | mysql -u root > zabbix
    ERROR 1046 (3D000) at line 1: No database selected
    [zabbix@lnm-mgt-tm003 schema]$ cat mysql.sql | mysql -u root -p xxxxxxxx > zabbix
    Enter password:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    [zabbix@lnm-mgt-tm003 schema]$ cat mysql.sql | mysql -u zabbix -p zabbix > zabbix
    Enter password:
    ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: YES)
    [zabbix@lnm-mgt-tm003 schema]$

    I tried both 'root' and 'zabbix' userids and passwords and both failied. What userid/passord it's looking for? THank you !!!
  • gescheit
    Senior Member
    • Jul 2007
    • 156

    #2
    You not selected DB.
    mysql -D zabbix -p < images_mysql.sql
    Last edited by gescheit; 26-07-2007, 18:10.

    Comment

    • mandy hughes
      Junior Member
      • Jul 2007
      • 2

      #3
      Gescheit,
      Thank you for your response. That appeared to have worked. I was just following the installation provided in Zabbix's Manual.

      Again, thank you!

      Comment

      Working...