Cacti (home)ForumsDocumentation

Differences

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

manual:088:1_installation.2_install_windows.5_install_mysql [2009/08/30 04:16]
127.0.0.1 external edit
manual:088:1_installation.2_install_windows.5_install_mysql [2019/10/29 15:16] (current)
Line 1: Line 1:
 ==== Install MySQL ==== ==== Install MySQL ====
  
-  Extract the MySQL zip file to a temp directory and run "setup.exe"+=== MySQL 5.6 === 
-  - Install MySQL to the default directory, or for the purposes of this manual to the "c:\mysql" directory. +  Download the latest Generally Available MSI Installer from [[https://www.mysql.com/downloads/mysql/|MySQL.com]]
-  - If running an older version of MySQL, start it by running "c:\mysql\bin\winmysqladmin.exe". In more recent versionsthis is not required+  - Launch the MSI 
-  - Stop the MySQL service+    - Agree to the license  
-  - Edit your C:\MySQL\my.ini file +    - Setup Type - Select //Server only// 
-  - Verify you don't have a **sql-mode** defined.  If so, comment it out+    - Click Execute and wait until the installation has completed.   
-  - 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.  +  - Click Next to begin the Product Configuration 
-    Add the following to the [mysqld] sub-section:<code> +  - Type and Networking Page: 
-#Use old password encryption method (needed for 4.0 and older clients). +    - Config Type: //Server Machine// 
-old-passwords +    - Connectivity: Leave the defaults selected (TCPPort 3306, Open Firewall port for network access) 
-</code> +    - Enable //Show Advanced Options// 
-  - Start the MySQL service.+    - Click Next
 +  - Accounts and Roles Page: 
 +    - Specify a root password 
 +    - Skip the User Accounts section 
 +    - Click Next
 +  - Windows Service Page 
 +    - Leave all defaults enabled 
 +    - Click Next
 +  - Apply Server Configuration page 
 +    Click Execute. 
 +    - Validate all steps are green and were successful.  
 +    - Click Finish 
 +  - Click Next through the remaining screens 
 + 
 + 
 +=== MySQL 5.5 === 
 +  - Download the latest Generally Available MSI Installer from [[https://www.mysql.com/downloads/mysql/|MySQL.com]]. 
 +  Install MySQL using the Typical setup. 
 +  - Launch the MySQL Instance Configuration Wizard 
 +    Select //Detailed Configuration// 
 +    - Select //Server Machine// 
 +    - Select //Non-Transactional Database Only// 
 +    - Select //Online Transaction Processing (OLTP)// 
 +    Enable //firewall exception for the port// 
 +    - Disable //SQL Strict Mode// 
 +    - Select the correct character set for the region. 
 +    - Select //Install As Windows Service// 
 +    - Set a root password 
 +  - Edit my.ini file. Typically resides in \Program Files\MySQL\MySQL Server X.Y\ 
 +  - Verify **sql-mode** is not defined.  If so, comment it out. 
 +  - Verify the MySQL service is started.
   - Set a password for the root user (if not set already during MySQL installation)<code>   - 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 somepassword
 c:\> mysqladmin --user=root --password reload c:\> mysqladmin --user=root --password reload
 </code> </code>
 +
 +=== Configure Database ===
   - Create the MySQL database:<code>   - Create the MySQL database:<code>
 c:\> 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>
-c:\> mysql --user=root --password cacti < c:\apache2\htdocs\cacti\cacti.sql+c:\> mysql --user=root --password cacti < C:\Inetpub\wwwroot\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! **+<note>If you get any errors during this phase, you likely have sql-strict mode enabled or something else misconfigured in my.ini!</note>
   - Create a MySQL username and password for Cacti.<code>   - Create a MySQL username and password for Cacti.<code>
 c:\> mysql --user=root --password mysql c:\> mysql --user=root --password mysql
 mysql> GRANT ALL ON cacti.* TO [email protected] IDENTIFIED BY 'cactipw'; mysql> GRANT ALL ON cacti.* TO ca[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>





Personal Tools