Good evening together I use Xammp to create databases for my Minecraft server, but I always get the error that I have no rights. How do I give the user the rights.
Edit: Wehr can help me to solve the problem, ever get the best rank on my Minecraft server in advance which will soon be available in the shop when the server is online.
Looks like the specified user has no access rights to the DB.
And how do you give the user rights
Arrives at the SQL client. Alternatively, this is also possible via SQL query.
Does not work either
First, of course, this is a troubleshooting infinite, as it could be everything.
Now that I'm just missing out on simple user behavior, here are some things that have led to bugs / errors in XAMPP and phpmyadmin in the past, making it look like you have no rights.
Do you use Chrome as a browser? Then change the times
Which MySQL user are you using? Please take to test the "root"
Look at the "config.inc.php" in the PHPMYADMIN folder to set the auth_type from "cookie" to "config"
$ cfg ['servers'] [$ i] ['auth_type'] = 'config';
$ cfg ['Servers'] [$ i] ['user'] = 'root';
$ cfg ['Servers'] [$ i] ['password'] = ''; // write your password here
Maybe one of them will help.
So I use Internet Explorer to go to the internet and root the user
Does "AllowNoPassword" have to be "true" or "false so I can use a password?
That does not matter, TRUE means only that no password is allowed.
In both cases, you should be able to use a password
But if I enter now localhost / phpMyAdmin then the following error comes: This side is not attainable.
Try the following
Make sure you use the correct web address: http://localhost
http://ms-appx-web://microsoft.microsoftedge/assets/errorpages/dnserror.html?ErrorStatus=0x800C0005&DNSError=0# http://localhost http://ms-appx-web://microsoft.microsoftedge/assets/errorpages/dnserror.html?ErrorStatus=0x800C0005&DNSError=0#
http://ms-appx-web://microsoft.microsoftedge/assets/errorpages/dnserror.html?ErrorStatus=0x800C0005&DNSError=0#
http://ms-appx-web://microsoft.microsoftedge/assets/errorpages/Titelnummer
There was a temporary DNS error. Try refreshing the page.
Error Code: INET_E_RESOURCE_NOT_FOUND
although I started Apache and MySQL
You may not have a HOSTS entry from localhost to 127.0.0.1
Write times instead of "localhost / phpmyadmin" → "127.0.0.1 / phpmyadmin"
Do not go instead of recognizing that a URL is looking for it and do not open the page
"http://127.0.0.1/phpmyadmin"
It does not work
Is something more accurate instead of not going? _. What is not working? What did you try like?
So rather I do not understand that (so the tutorials on YouTube)
Well then you should rather rent a managed Minecraft server. Et al In terms of system administration, this should be more useful.