Can't create phpMyAdmin user on Synology

Discuss the phpMyAdmin Package Here.
Forum rules
We've moved! Head over to Synology Community (community.synology.com) to meet up with our team and other Synology enthusiasts!
CSO
I'm New!
I'm New!
Posts: 8
Joined: Wed Jul 25, 2012 7:04 pm

Can't create phpMyAdmin user on Synology

Unread post by CSO » Tue Dec 13, 2016 7:32 pm

Hi all,

Wan't to create user in phpMyAdmin. Have done this on more then 100 Synology servers.

PROBLEM:
When I lock into phpMyAdmin af want to create a user I get the following error. ERROR IN RED BOX:”SHOW PLUGINS SONAME LIKE ‘%_password_check%’
MySQL returned: “#1064 Error in SQL Syntax SONAME LIKE ‘%_password_check%’ line 1

Database:
phpMyAdmin 4.6.5-0168
MariaDB 5.5.52-0069

PHP version:
5.6.28-0036

Synology Firmware: 6.0.2-8451 update 6

Best Regards
Carsten

pnowak
I'm New!
I'm New!
Posts: 2
Joined: Wed Dec 14, 2016 10:32 am

Re: Can't create phpMyAdmin user on Synology

Unread post by pnowak » Wed Dec 14, 2016 10:40 am

Hi!
I've got the same problem.

Database:
phpMyAdmin 4.6.5
MariaDB 5.5.52

PHP version:
5.6.28

Synology Firmware:
6.0.2-8451 update 6

Please help solve the problem..
Regards
Paweł

jrozelle
I'm New!
I'm New!
Posts: 4
Joined: Tue Sep 04, 2012 4:51 pm

Re: Can't create phpMyAdmin user on Synology

Unread post by jrozelle » Wed Dec 14, 2016 2:23 pm

Hi ! Same here. Same version, same problem.

Thank you in advance !

CSO
I'm New!
I'm New!
Posts: 8
Joined: Wed Jul 25, 2012 7:04 pm

Re: Can't create phpMyAdmin user on Synology

Unread post by CSO » Wed Dec 14, 2016 9:02 pm

I don’t know where to look for the problem, I wrote to Synology. However, they wrote back that it’s not their problem. I need to investigate further… Posted at ticket with the problem on phpMYadmin, and it was deleted after 2 days. Perhaps the error is a problem with MariaDB.

I would just be glad if someone could point me in the correct direction, because this is a very big problem for me!!!

Best regards
Carsten

pnowak
I'm New!
I'm New!
Posts: 2
Joined: Wed Dec 14, 2016 10:32 am

Re: Can't create phpMyAdmin user on Synology

Unread post by pnowak » Thu Dec 15, 2016 9:40 am

Use command in console phpMyAdmin:

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT SELECT, INSERT, UPDATE, DELETE ON `basename`.* TO 'username'@'%';

helio58
Trainee
Trainee
Posts: 19
Joined: Tue Oct 28, 2014 3:34 pm

Re: Can't create phpMyAdmin user on Synology

Unread post by helio58 » Mon Dec 19, 2016 9:14 pm

pnowak wrote:Use command in console phpMyAdmin:

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT SELECT, INSERT, UPDATE, DELETE ON `basename`.* TO 'username'@'%';
Thanks :D
415play
DSM6.0
Tvheadend-testing

Locked

Return to “phpMyAdmin”