Please go to the Official MySQL download page to download the MySQL installer. We need to use the MySQL installer to install MySQL on the Windows platform. Once you have everything setup, don’t forget to setup a scheduled task for archiving reports in Matomo.Installing MySQL on the Windows platform is very simple and easy. If you already have PHP setup, you can continue with the next step of setting up IIS for Windows: How do I install and configure IIS on Windows for Matomo? Next we’ll take you through setting up PHP for Windows: How do I install and configure PHP on Windows for Matomo? MySQL should now be successfully setup on your Windows server. Adding anonymous user support may create a security risk for the database additionally, enabling anonymous users causes the GRANT statements used to set up database to be unreliable. Include ‘Bin’ Directory in Windows PATH - This makes the MySQL utilities available from the command prompt or from Windows PowerShell™.Ĭreate an Anonymous Account - The default is to keep this disabled. If the database will be running on a separate system from the Web server, select the Add firewall exception for this port check box. Keep the TCP port that MySQL uses to listen at 3306. Best Practices for MySQLĮnable TCP/IP Networking - This is the default. Locate your MySQL configuration file called C:\ProgramData\MySQL\MySQL Server X.X\my.ini and set the following values: max_allowed_packet = 256M Replace ‘matomo’ by your chosen MySQL username (or simply use ‘matomo’). Replace my-strong-password-here by a strong secure password. Replace matomo_db_name_here with the name of your MySQL database dedicated to Matomo Analytics. $ mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON matomo_db_name_here.* TO these instructions: Grant this user matomo the permission to access your matomo_db_name_here database $ mysql> CREATE USER IDENTIFIED BY 'my-strong-password-here' $ mysql> CREATE DATABASE matomo_db_name_here Once logged on to MySQL, use the following sequence of commands: Open the MySQL command prompt by clicking Start -> All Programs -> MySQL -> MySQL Server -> MySQL Command Line Client: That’s it! Create a Mysql database and userĪssuming your MySQL server is running, now we will create a new MySQL database for Matomo and a new MySQL user who can only access this database. We recommend to answer Yes to all the questions. When you run this executable file a window will pop up that will walk you through the process of securing your MySQL installation. Once you find the executable file, you can run this executable file. Open Explorer and search for mysql_secure_installation.exe. Then we run the MySQL secure installation tool to improve the default security settings: The installation will complete, on the following screens click Next, then click Finish Secure MySQL Unless you have specific requirements do not change the settings on this screen, click NextĬreate a strong and secure MySQL root password Select Standalone MySQL Server / Classic MySQL Replication then Next Once the installation wizard is completed, it is recommended that you leave the Configure the MySQL Server now checkbox selected. Please see below for the detailed setup process including screenshots. You can use a Typical Setup or customize the installation to suit your needs. Start Windows Installer, or extract all the files from the archive, and then start Setup.exe. Note: The MySQL Installer is 32 bit, but the installer will install both 32 bit and 64 bit binaries. We recommend downloading and using the Windows Installer. The separation of the database server and Web server makes overall installation more secure and manageable and avoids resource contentions between the database and Web server processes.ĭownload MySQL Community Server. It is recommended that you install MySQL on a dedicated server rather than installing MySQL on the same server that that you are running IIS on. In this FAQ we will provide step-by-step instructions on how to Install MySQL on Windows for use with Matomo.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |