Phpmyadmin xampp create new user install#

Replace Apache and PHP and nothing is left over.įorget WIndows, get a nice Linux distribution and install everything from the repositories. Why do you use it? You have replaced phpmyadmin and as well MariaDB - so this is YOUR train wreck, it is not Xampp anymore. October 2015 23:31 Operating System: Windows 8.1Ĭoder1 wrote:I'm running phpMyAdmin 4.5.1 and have loaded MariaDB 10.1.8 in my XAMPP stack to replace 10.0.17. And MariaDB is becoming a more widely used database server, the inclusion of said in the new stacks.

Yet, some of us are having serious problems with regard to User Management with the presence of MariaDB. I know lem9 has the demo in PMA working with MariaDB 10.0.21 and does have one user pma in table db of database MySQL. no data is in the table db, duh).Īgain, MairaDB, no matter what 'stable' release is apparently doing a number on database MySQL and it seems in particular table db. However, clicking on the edit privileges is useless since table db is empty and thus you get an SQL error noting something to the effect that the MyISAM table was expecting more data than provided (i.e. And again, if the screen shot error does not present itself, one can access the User accounts tab/page and see the users you've created. And of course when that screen shot error appears you're not going to get to the PMA User accounts tab/page. However, when table db does show the users, that is when you get the error noted by linuxs in his original screen shot. However, being the db table bug that it is, table db will, on occasion, populate with the users I've created and also the global privileges I've given them. I cannot add a user with PMA so I had to install HeidiSQL and only then could I add a user but could not drill down to give a user privileges to a particular database thus, could only provide privileges at the global level. Table db in database MySQL is completely unstable. The whole thing's a complete train wreck.

I'm running phpMyAdmin 4.5.1 and have loaded MariaDB 10.1.8 in my XAMPP stack to replace 10.0.17.

Phpmyadmin xampp create new user