Phpmyadmin login access from all mysql users

You need to access hosts of this users add remote IP to allow remote connections to DB.
 
Any guides on this ? And when u say hosts, what do you mean ? In phpmyadmin i have this
1689762765315.png
 
I don't know about phpmyadmin, but access hosts must be added in DA, in mysql management click on database name, than on database username to modify it, then you will see "access hosts" here better not to add % but exact IP.
 
Well i get that but this is not what i meant, so let me explain.
I have other sistems implemented on my dedicated server, that create normal databases and users like this
1689767128148.png

And i want to access them from phpmyadmin but i cant !! I can only log in with the DA users. How do i disable or be able to log in into Phpmyadmin using mysql databases users ?
 
No, let me give you an example. If i create a user like this in PhpMyAdmin
1689794452577.png

And i try to log in with it like this
1689794478223.png

I will get this error
1689794508741.png

My question is, how do I prevent this, on a normal phpmyadmin install on a normal database this should work
 
I don't know, I never use it that way. Otherwise try using localhost instead of % for the host.

Why don't you create the user from Directadmin?
Go to mysql management, click the database you want to add the user to and then click the "create new database user" button.
 
That's a good idea but think that I need a solution because I have pterodactyl panel installed and that's the main reason I need this, pterodactyl creates databases and users.
 
Aha... wel still... try using localhost instead of the default % for the host, maybe that already helps.

Also check for this line in /etc/my.cnf:
bind-address=127.0.0.1

and check your /etc/hosts file that it's bound correctly:
127.0.0.1 localhost.localdomain localhost

Then it should be possible to do it your way if the correct permissions are granted too.
 
Thank you, with localhost in the phpmyadmin the accounts can log in now but my question is, dosent this affect my servers ?
 
Cartitaarul said:
dosent this affect my servers ?
Click to expand...
In what way do you mean?
It might affect the servers because databases are also counted to quota and disk space. But since I presume these accounts are created as (mysql)admin directly it probably does not count.

However, it might be that they are also not being added in a backup as they are not directadmin users or belonging to a DA account since they are not created that way.

But that's totally guessing. Maybe somebody else can help you with that.

@Zhenyapan do you have a clue on this?
 
You must log in or register to reply here.
Back
Top