Cacti (home)ForumsDocumentation

Differences

This shows you the differences between two versions of the page.

manual:087:1_installation.2_install_windows.5_install_mysql [2009/02/21 14:55]
gandalf created
manual:087:1_installation.2_install_windows.5_install_mysql [2009/08/30 00:16] (current)
BSOD2600 content updates
Line 4: Line 4:
   - Install MySQL to the default directory, or for the purposes of this manual to the "c:\mysql" directory.   - Install MySQL to the default directory, or for the purposes of this manual to the "c:\mysql" directory.
   - If running an older version of MySQL, start it by running "c:\mysql\bin\winmysqladmin.exe". In more recent versions, this is not required.   - If running an older version of MySQL, start it by running "c:\mysql\bin\winmysqladmin.exe". In more recent versions, this is not required.
-  - Set a password for the root user<code> +  - Stop the MySQL service. 
-shell> cd mysql\bin +  - Edit your C:\MySQL\my.ini file 
-shell> mysqladmin --user=root password somepassword +  - Verify you don't have a **sql-mode** defined.  If so, comment it out. 
-shell> mysqladmin --user=root --password reload+  - You will need to apply the [[http://dev.mysql.com/doc/mysql/en/old-client.html|old client]] hack for user authentication to work with Cacti.  
 +    - Add the following to the [mysqld] sub-section:<code> 
 +#Use old password encryption method (needed for 4.0 and older clients). 
 +old-passwords 
 +</code> 
 +  - Start the MySQL service. 
 +  - Set a password for the root user (if not set already during MySQL installation)<code> 
 +c:\> mysqladmin --user=root password somepassword 
 +c:\> mysqladmin --user=root --password reload
 </code> </code>
   - Create the MySQL database:<code>   - Create the MySQL database:<code>
-shell> mysqladmin --user=root --password create cacti+c:\> mysqladmin --user=root --password create cacti
 </code> </code>
   - Import the default Cacti database:<code>   - Import the default Cacti database:<code>
-shell> mysql --user=root --password cacti < c:\apache2\htdocs\cacti\cacti.sql+c:\> mysql --user=root --password cacti < c:\apache2\htdocs\cacti\cacti.sql
 </code> </code>
 +** Note: If you get any errors during this phase, you likely have sql-strict mode enabled or something else misconfigured in my.ini! **
   - Create a MySQL username and password for Cacti.<code>   - Create a MySQL username and password for Cacti.<code>
-shell> mysql --user=root --password mysql +c:\> mysql --user=root --password mysql 
-mysql> GRANT ALL ON cacti.* TO [email protected] IDENTIFIED BY 'somepassword';+mysql> GRANT ALL ON cacti.* TO [email protected] IDENTIFIED BY 'cactipw'; 
 +mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('cactipw') WHERE Host = 'localhost' AND User = 'cactiuser';
 mysql> flush privileges; mysql> flush privileges;
 </code> </code>
-  - If you are running MySQl 4.1 and above, you will need to apply the old password setting in order to authenticate with Cacti. To make this change, stop the MySQL service and add the following to the Start Parameter field. Start it again once it has been added.<code> 
---old-password</code>You will also need to update the cactiuser account with the old password style.<code> 
-shell> UPDATE mysql.user SET Password = OLD_PASSWORD('cactipwd') WHERE Host = 'localhost' AND User = cactiuser'; 
-mysql> FLUSH PRIVILEGES; 
-</code> 
- 
- 





Personal Tools