Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

PIWIK Error #11730

Closed
BCTH opened this issue May 23, 2017 · 2 comments
Closed

PIWIK Error #11730

BCTH opened this issue May 23, 2017 · 2 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@BCTH
Copy link

BCTH commented May 23, 2017

After sign-on, receive this error message: SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT,UPDATE command denied to user 'uwgSr3L5KD55l'@'69088336-fda7-40aa-a864-eea193bb9667.cell.default.w3ibm-cio-' for table 'piwik_option'
@Findus23
Copy link
Member

command denied to user means that the MySQL user you are using doesn't have the permission to write to the database.

Make sure you are using the right user.

@mattab
Copy link
Member

mattab commented Jun 21, 2017

When installing Piwik, you will need to specify a MySQL username and password. The MySQL user must have permission to create and alter tables in the database.

The MySQL USER should have the permission to SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES.

Click here for detailed instructions on how to create a new database and MySQL user.

@mattab mattab closed this as completed Jun 21, 2017
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Jun 21, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@mattab @Findus23 @BCTH