SELECT FROM informationschema. You can check the configuration of user with statement.

CREATE USER 'newuser''localhost' IDENTIFIED BY 'password' And this is the way you give the user permission: It seems like the permission of user 'parser' is not correct. And hostname is the name of the host from which the user connects to the MySQL Server. This is the way to create new user in MySQL. The account name has two parts: username and hostname, separated by the sign: The username is the name of the user. First, specify the account name after the CREATE USER keywords. replace matomo by your chosen MySQL username (or simply use matomo). The CREATE USER statement creates a new user in the database server.replace my-strong-password-here by a strong secure password.replace matomo_db_name_here with the name of your MySQL database (if possible, this database should only have the Matomo tables installed).In this example, the CREATE USER statement would create a new user called smithj in the MySQL database. (OPTIONAL) Grant this user matomo the FILE global privilege: (if enabled, reports will be archived faster thanks to the LOAD DATA INFILE feature) $ mysql> GRANT FILE ON *.* TO these instructions: CREATE USER smithjlocalhost IDENTIFIED BY autumn. Grant this user matomo the permission to access your matomo_db_name_here database $ mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON matomo_db_name_here.* TO is important to grant the user the following privileges: SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES Or if you are using an older version such as MySQL 5.1, MySQL 5.5, MySQL 5.6: $ mysql> CREATE USER IDENTIFIED BY 'my-strong-password-here' If you are installing Matomo (Piwik) on your own server and/or don’t have a tool available to manage your database, you can manually create the MySQL database user by following these steps:Ĭreate a database for Matomo: $ mysql> CREATE DATABASE matomo_db_name_here Ĭreate a user called matomo, if you are using MySQL 5.7 or MySQL 8 or newer: $ mysql> CREATE USER IDENTIFIED WITH mysql_native_password BY 'my-strong-password-here' To create your database and database user, you would typically use your web hosting provider interface which would let you add a new MySQL database and create a new user with permission to access this database, in just a few clicks. When installing Matomo you need to specify a MySQL (or MariaDB) database hostname, user and password.

Mysql create user