Port Issue Mysql wont connect

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

Port Issue Mysql wont connect

Postby bobe1997 » 18. February 2012 07:15

Please help. I installed xampp and followed directions. I ended up installing twice. Changed the port because 80 wasnt working so now I have to use localhost:8080. Ok all is working except when I try to add a database I get the error No Privileges. I have been looking for hours to fix this. Can anyone help? Also I have checked host and it is fine. No hash.
bobe1997
 
Posts: 3
Joined: 18. February 2012 06:35
Operating System: Windows 7

Re: Port Issue Mysql wont connect

Postby JonB » 18. February 2012 12:39

Is the problem you can't connect or that you cannot create a database?

Port Issue Mysql wont connect


when I try to add a database I get the error No Privileges


:shock:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Port Issue Mysql wont connect

Postby bobe1997 » 21. February 2012 02:23

I can log into myphpadmin but can not create a database. I gave the other information because didnt know if by me changing the ports if that had anything to do with it.
bobe1997
 
Posts: 3
Joined: 18. February 2012 06:35
Operating System: Windows 7

Re: Port Issue Mysql wont connect

Postby Altrea » 21. February 2012 03:38

which user do you use to login to phpmyadmin? or will you be autologgedin?
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: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Port Issue Mysql wont connect

Postby bobe1997 » 21. February 2012 21:36

I set up my user but I have tried them all and I still get the same error. I just reinstalled xampp again and this time I did not set up anything. I am logging in under the root and that works. Cant figure out why its not working when I go in and set up my own user account.
bobe1997
 
Posts: 3
Joined: 18. February 2012 06:35
Operating System: Windows 7

Re: Port Issue Mysql wont connect

Postby Altrea » 22. February 2012 07:00

You are the only person who can know the answer.
If you create a new user, you can specify which permissions the user gets. If the global permission for creating databases is missing, then the user can't create any databases.

best wishes,
Altrea
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: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 83 guests