Error Accessing "User Accounts" from phpmyadmin

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Re: Error Accessing "User Accounts" from phpmyadmin

Postby coder1 » 31. October 2015 21:20

Thanks for the update linuxs.

In its present state, MariaDB 10.x, at least with regard to User Management, is not usable. And since User Management is a fundamental component, MariaDB 10.x is useless.

Also, I tried deleting some of the garbage users that appear in the User accounts overview page and I could not do it, instead I got an SQL error. The garbage users bug appears to be a PMA problem since I only saw the real users in HeidiSQL User management.
coder1
 
Posts: 13
Joined: 25. October 2015 23:31
Operating System: Windows 8.1

Re: Error Accessing "User Accounts" from phpmyadmin

Postby Nobbie » 01. November 2015 11:24

coder1 wrote:In its present state, MariaDB 10.x, at least with regard to User Management, is not usable. And since User Management is a fundamental component, MariaDB 10.x is useless.


Seems to be specific to Windows, on my Ubuntu Gnome Installation 64bit it runs flawlessly.
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04

Re: Error Accessing "User Accounts" from phpmyadmin

Postby Beltran » 02. November 2015 09:38

Thanks for your comments. It seems some of you have issues when you reboot the machine and have PMA extended configuration enabled on Windows. We are investigating these spurious users that appear in PMA and check if there is a workaround for that.
User avatar
Beltran
Power-User
 
Posts: 108
Joined: 22. March 2013 12:29
Operating System: Windows, Linux, OS X

Re: Error Accessing "User Accounts" from phpmyadmin

Postby coder1 » 02. November 2015 14:12

Beltran,

I would say the spurious users is a secondary problem. In that, though frustrating to have spurious users, the primary problem still is the deletion of data in table db, and at times, the reappearance of the data in table db. That is the primary MariaDB bug in this instance I would argue.

But, the appearance of spurious users in PMA is a pain. And the spurious users do not show up in other GUIs. However, in other GUIs, the true, created users do not show up either when, on a particular reboot, MariaDB has deleted table db.
coder1
 
Posts: 13
Joined: 25. October 2015 23:31
Operating System: Windows 8.1

Re: Error Accessing "User Accounts" from phpmyadmin

Postby linuxs » 02. November 2015 21:43

Is this thing alive ??????
It is like it has its own AI XD
Sometimes it is working as it should, sometimes does not. I reboot my machine and it is working when doing NOTHING more than cheeking MySQL users after that i reboot the machine again and then it is not working, restart again and NOW its working hahaha XD. Trolling me pretty much that's it.
But somehow i think it is getting better because i couldn't even enter user account once and had problems starting MySQL but not now.
linuxs
 
Posts: 12
Joined: 23. October 2015 16:03
Operating System: Windows 10 Home

Re: Error Accessing "User Accounts" from phpmyadmin

Postby Beltran » 06. November 2015 19:39

Thanks a lot for your feedback! We have been working on adding several fixes to phpMyAdmin to address these issues. Please find below a new revision of XAMPP that fixes the phpMyAdmin issues with MariaDB on Windows.

https://www.apachefriends.org/xampp-files/5.5.30/xampp-win32-5.5.30-2-VC11-installer.exe

md5: 577aa48d49639f3ab740e9f4f6309e7a

https://www.apachefriends.org/xampp-files/5.6.14/xampp-win32-5.6.14-2-VC11-installer.exe

md5: 7b3bac1feeec346303b70e01ed96ba11

This version ships the following:

- Updated phpMyAdmin to 5.4.1 with patches for MariaDB
- Updated MariaDB to 10.1.8

Please post if you find any issue with phpMyAdmin and MariaDB using this new XAMPP version. Thanks!
User avatar
Beltran
Power-User
 
Posts: 108
Joined: 22. March 2013 12:29
Operating System: Windows, Linux, OS X

Re: Error Accessing "User Accounts" from phpmyadmin

Postby Beltran » 13. November 2015 15:59

We have been released a new XAMPP version with fixes for MariaDB and phpMyAdmin. Thanks a lot for your feedback! Please post if you find any issue with this new version.
User avatar
Beltran
Power-User
 
Posts: 108
Joined: 22. March 2013 12:29
Operating System: Windows, Linux, OS X

Re: Error Accessing "User Accounts" from phpmyadmin

Postby tem1950 » 14. November 2015 20:53

Beltran,

I installed the new "fix" version 5.6.14-3 only to have no access to the db via phpmyadmin. I went back through my saved versions and the only one that will work correctly is 1.8.3. Once all the dust clears around MariaDB, I might be interested in updating xampp. Until then, I'd rather be able to actually use the db. My main problem is that I can't add a new user when MariaDB is the db, because the new user isn't in the "privileges" table. I'm not a database expert, so my only safe avenue is avoidance for now. I hope you get things worked out soon.
tem1950
 
Posts: 1
Joined: 03. August 2014 01:50
Operating System: windows 8.1

Re: Error Accessing "User Accounts" from phpmyadmin

Postby Altrea » 14. November 2015 21:15

tem1950 wrote:My main problem is that I can't add a new user when MariaDB is the db, because the new user isn't in the "privileges" table.

I don't understand this sentence. Of cause the user is not in the privileges table. You want to create it because it is not present :shock:
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Previous

Return to XAMPP for Windows

Who is online

Users browsing this forum: hthnightwolf and 65 guests