Mperdema me php-mysql,ktl.

[therock]

Kalispera,kat'arxas na anafero pos den exo idea apo programmatismo,aplos thelo na trekso ena programma (sigkekrimena to cacti),to opoio gia na trexei prepei na permvo se arketes energeis pou aforoun egkatastaseis kai configurations ton php kai mysql.Sigkekrimena xrisimopoio ton odigo edo kai kalloao se orismena vimata kai tha ithela tin voitheia sas.

 

Guide:

>http://bsod2600.home.comcast.net/install_windows.html

 

Den katalaveno to vima configuration tou mysql

 

>#

Create the MySQL database:

shell> mysqladmin --user=root --password create cacti

#

Import the default Cacti database:

shell> mysql --user=root --password cacti < c:\inetpub\wwwroot\cacti\cacti.sql

#

Create a MySQL username and password for Cacti.

shell> mysql --user=root --password mysql
mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'cactipw';
mysql> flush privileges; 

# If you're running MySQL 4.1 or 5, then you will need to apply the old password trick for user authentication to work with Cacti.  

  1. Stop the MySQL service, edit your c:\mysql\my.ini file, and add the following:

     #Use old password encryption method (needed for 4.0 and older clients).
     old-passwords

  2. Start the MySQL service.
  3. You will also need to update the cactiuser account with the old password style:

     shell> mysql --user=root --password mysql
     shell> UPDATE mysql.user SET Password = OLD_PASSWORD('cactipw') WHERE Host = 'localhost' AND User = 'cactiuser';
     mysql> FLUSH PRIVILEGES;

  4. You should see the following after issuing the UPDATE command:

     Query OK, 1 row affected (0.00 sec)
     Rows matched: 1  Changed: 1  Warnings: 0

 

Otan kano copy paste tis entoles mou vgazei ayto

 

>Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.24-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> mysqladmin --user=root --password create cacti
   -> mysql --user=root --password cacti < c:\inetpub\wwwroot\cacti\cacti.sql
ERROR:
Unknown command '\i'.
Show warnings disabled.
   -> mysql --user=root --password cacti < c:\inetpub\wwwroot\cacti\cacti.sql
ERROR:
Unknown command '\i'.
Show warnings disabled.
   ->