Granting permissions to other users

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

Granting permissions to other users

Postby grosskopf » 23. May 2011 22:21

I've used XAMPP for a while now and I jut got another server, so I installed it. I have a program that needs to connect to a database that I created. The program is called BigBrotherBot. If I set the database username/password to root/(my root password), I can connect to the database. If I try using the user that I created for the database, it won't connect. This is all locally, not over the net.

In the database, I granted all permissions to the new user, only to that specific database. Here's screenshots so you can see for yourself. If anyone has any suggestions, it would be greatly appreciated!

Image
Image
Image
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02

Re: Granting permissions to other users

Postby Altrea » 23. May 2011 23:43

localhost isn't part of thge wildcard %
If your script is running on the same server like the DB, you need a localhost permission.
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: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Granting permissions to other users

Postby grosskopf » 24. May 2011 00:28

Altrea wrote:localhost isn't part of thge wildcard %
If your script is running on the same server like the DB, you need a localhost permission.


I would kiss you if you were sitting next to me.

That was the problem! Thanks! I knew it was going to be something easy!
grosskopf
 
Posts: 18
Joined: 23. December 2010 02:02


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 29 guests