[FIX] phpmyadmin some feature/controluser

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
skurudo
VestaCP Team
Posts: 7798
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
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: 7798
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
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: 7798
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
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: No registered users and 4 guests