mariadb Ver 15.1 Distrib 10.11.8-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
When I create new domain, everything works fine except mariadb.
When I try to login to mariadb user with correct credentials then also getting below error:
mysql -u test1 -p
Enter password:
ERROR 1045 (28000): Access denied for user âtest1â@âlocalhostâ (using password: YES)
As of now, workaround is that, I login on phpmyadmin using root and changing password after selecting user as showing in below image ( and yes I am using same password which I used while creating virtualmin domain) and works fine.
If you installed virtualmin on a clean OS (no preinstalled installing of any software).
When you created the virtual server did you enable Maria Database for that domain.
Install phpmyadmin via Manage Web apps and it should just work.
Sorry typo, it is webmin
I have installed virtualmin and creating domain through it. But this will install phpmyadmin for a particular domain right? or will be global ?
Ok as you use ubuntu you can install phpmyadmin globally using
apt install phpmyadmin
and each anydomain/phpmyadmin url will work, with one perhaps pitfall which is if you use multiple versions of php and a domain has a different version of php running than the distro default it may not work. Or you can use the virtualmin installer for phpmyadmin on a single domain and just tell all phpmyadmin users to use the selected url e.g selecteddomain.tld or selecteddomain.tld/somepath depending on how you use the virtualmin installer which gets around the php mismatch issue. Note any mysql user will be able to log in from this url not just the user(s) from the selected domain
I have install phpmyadmin using apt-get install only. at first I checked with manual setup with different version but that didnât help.
and I donât think so it is related to phpmyadmin.
Issue is different, when I create domain using virtualmin, it is creating DB, which I am not able to authenticate using either phpmyadmin or cli.
I think @jimr1 summed it up there are potential pitfalls loading phpmyadmin as a global package rather than using the Web app (`per domainâ approach) - I am assuming that you have ore than one domain on the VS. and multipl versions of PHP is only going to make life even more complicated.
Ok but what exactly I am facing is not related to PHPMyadmin, while creating domain on virtualmin, it is creating domain along with database and itâs credentials with the status âOKâ and when I try to login with that credentials using terminal " mysql -u username -p " seems not allowing me to login.
Uninstall phpmyadmin and use Manage Web Apps to install it for each domain you want to have PHPMyAdmin. If you want a central one for all domains, you can do that, instead, but donât do it with the Ubuntu package, as it is not suitable for use in a virtual hosting environment.
Please always make sure you test with a current version of Virtualmin and Webmin before asking questions. It takes up a lot of time talking past one another when youâre possibly talking about issues that are no longer present or not seeing the same terminology everyone else is using because you have an old version of the UI.
@Joe Thanks for reply, I have installed current version only, I have posted previous version detail just to let you know that it is working on that version as expected.
