[FIX] phpmyadmin some feature/controluser

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
skurudo
VestaCP Team
Posts: 7808
Joined: Fri Dec 26, 2014 2:23 pm
Contact:

Re: [FIX] phpmyadmin some feature/controluser

Postby skurudo » Mon Jul 25, 2016 2:58 pm

Teo wrote:
skurudo wrote:What was not ok? All or some tables?

still the same error marked red in my uploaded pic.


Can you press ? behind "not OK" and show us what's error you got?
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

Botanist_
Posts: 9
Joined: Sat Jul 09, 2016 4:40 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby Botanist_ » Tue Aug 23, 2016 10:40 pm

It doesn't seem to work
::
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Delete temp files

skurudo
VestaCP Team
Posts: 7808
Joined: Fri Dec 26, 2014 2:23 pm
Contact:

Re: [FIX] phpmyadmin some feature/controluser

Postby skurudo » Wed Aug 24, 2016 7:43 am

Botanist_ wrote:It doesn't seem to
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Delete temp files


Looks like you don't have .my.cnf file in your root folder with security creditials.
You can
- add /root/.my.cnf wih root password for mysql:

Code: Select all

[client]
password='mysqlrootpassword'

- or you can a little modify script this parts "mysql -uroot " search and replase to

Code: Select all

mysql -uroot -p

Script ask you password from mysql every time.
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

edica
Posts: 101
Joined: Tue May 26, 2015 7:31 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby edica » Mon Sep 05, 2016 5:07 pm

In Debian 8.5 show "Server Choice" field. With two localhost. How fix?

Image

skurudo
VestaCP Team
Posts: 7808
Joined: Fri Dec 26, 2014 2:23 pm
Contact:

Re: [FIX] phpmyadmin some feature/controluser

Postby skurudo » Mon Sep 05, 2016 8:06 pm

edica wrote:In Debian 8.5 show "Server Choice" field. With two localhost. How fix?


Can you provide me access via PM? I'd like investigate this case.
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

edica
Posts: 101
Joined: Tue May 26, 2015 7:31 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby edica » Mon Sep 05, 2016 11:07 pm

skurudo wrote:
edica wrote:In Debian 8.5 show "Server Choice" field. With two localhost. How fix?


Can you provide me access via PM? I'd like investigate this case.


Yes, no problem. I sent PM.

Teo
Posts: 73
Joined: Mon May 11, 2015 9:17 am

Re: [FIX] phpmyadmin some feature/controluser

Postby Teo » Sat Sep 10, 2016 4:14 pm

skurudo wrote:
Teo wrote:
skurudo wrote:What was not ok? All or some tables?

still the same error marked red in my uploaded pic.


Can you press ? behind "not OK" and show us what's error you got?


phpMyAdmin configuration storage

For a whole set of additional features (bookmarks, comments, SQL-history, tracking mechanism, PDF-generation, column contents transformation, etc.) you need to create a set of special tables. Those tables can be located in your own database, or in a central database for a multi-user installation (this database would then be accessed by the controluser, so no other user should have rights to it).

rbrownell
Posts: 7
Joined: Tue Aug 16, 2016 1:03 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby rbrownell » Mon Sep 19, 2016 8:26 pm

edica wrote:
skurudo wrote:
edica wrote:In Debian 8.5 show "Server Choice" field. With two localhost. How fix?


Can you provide me access via PM? I'd like investigate this case.


Yes, no problem. I sent PM.



Any progress on this yet?

edica
Posts: 101
Joined: Tue May 26, 2015 7:31 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby edica » Tue Sep 20, 2016 12:48 pm

rbrownell wrote:
edica wrote:
skurudo wrote:
Can you provide me access via PM? I'd like investigate this case.


Yes, no problem. I sent PM.


Any progress on this yet?


Not answer me yet.

saam albert
Posts: 2
Joined: Tue Oct 04, 2016 10:55 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby saam albert » Tue Oct 04, 2016 10:58 pm

Teo wrote:
Tragus wrote:
Teo wrote:still the same error marked red in my uploaded pic.


Can you press ? behind "not OK" and show us what's error you got?


phpMyAdmin configuration storage

For a whole set of additional features (bookmarks, comments, SQL-history, tracking mechanism, PDF-generation, column contents transformation, etc.) you need to create a set of special tables. Those tables can be located in your own database, or in a central database for a multi-user installation (this database would then be accessed by the controluser, so no other user should have rights to it).


I don't swing that way.


Return to “Database Server”



Who is online

Users browsing this forum: Bing [Bot] and 2 guests

cron