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 [2012/10/25 04:42]
BSOD2600 modernizing
manual:088:1_installation.2_install_windows.5_install_mysql [2019/10/29 15:16] (current)
Line 1: Line 1:
 ==== Install MySQL ==== ==== Install MySQL ====
  
-  - Download the latest generally available MSI Installer from [[https://www.mysql.com/downloads/mysql/|Mysql.com]].  - +=== MySQL 5.6 === 
 +  - Download the latest Generally Available MSI Installer from [[https://www.mysql.com/downloads/mysql/|MySQL.com]]. 
 +  - Launch the MSI 
 +    - Agree to the license  
 +    - Setup Type - Select //Server only// 
 +    - Click Execute and wait until the installation has completed.   
 +  - Click Next to begin the Product Configuration 
 +  - Type and Networking Page: 
 +    - Config Type: //Server Machine// 
 +    - Connectivity: Leave the defaults selected (TCP, Port 3306, Open Firewall port for network access) 
 +    - Enable //Show Advanced Options// 
 +    - 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.   - Install MySQL using the Typical setup.
   - Launch the MySQL Instance Configuration Wizard   - Launch the MySQL Instance Configuration Wizard
Line 13: Line 40:
     - Select //Install As Windows Service//     - Select //Install As Windows Service//
     - Set a root password     - Set a root password
-  - Edit \my.ini file+  - 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 **sql-mode** is not defined.  If so, comment it out.
   - Verify the MySQL service is started.   - Verify the MySQL service is started.
Line 21: Line 48:
 </code> </code>
  
-==== Configure Cacti ====+=== 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





Personal Tools