J
J
JohnDaniels2016-09-12 00:00:43
Server equipment
JohnDaniels, 2016-09-12 00:00:43

How to make ispconfig work with db?

Dear evening. There is such a problem:
there is a vds with pre-installed ipsconfig, that is, I installed a ready-made image and did not change anything with my hands yet. In ispconfig I go to "Sites -> Database", I create a new database, everything seems to be fine:
3f067d2bfcab4ca285b8fbcf780be9dd.png
but phpmyadmin does not see it
ae5f4a264ae44558b4ee6a8fa392ea42.png
and it is not here either:
3554af17949e486aaccd118ac4b5199c.png
Then I do the opposite - I create a database in phpmyadmin, then it appears in PA and the console, but isp does not see her.
It seems that two subds are installed on the server, is this possible? and what to do?
PS. rummaged around in the mysql.user table, there is this:
7e53ebd270a44bcc9528849c46f58b79.png
4 root users is this normal?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Maxim, 2016-09-13
@JohnDaniels

When you create a database through an ISP, you declare a client and give it all the privileges.
If you log into PHPMyAdmin under the user you created for the database, your database will open.
If you messed up directly in PHPMYAdmin without creating a database in ISP, then your default user is root, which will not explicitly display your database in ISP. Also, PHPMyAdmin will not have the user base that you created from the ISP because you don't have permission to view it.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question