Can't create database - "No priviledges" error! [Solved]

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

Can't create database - "No priviledges" error! [Solved]

Postby AdrianaRulz » 19. July 2012 06:00

Hi ^_^

OK, so first of all, I should say that I'm really REALLY dumb when it comes to computers or generally anything that requires you to be smarter than an average bear. So excuse me if I'm breaking some forum rules or missing something obvious.

So, I'm using (or trying to use) Lampp on Ubuntu 12.04 (Can't afford Windows, I'm poor. Ha Ha!) I downloaded and installed Xampp according to the exact instructions given on this site but when I tried to access it from browser, it gave permission issues. So I opened "gksu nautilus" and changed the whole lampp directory's permission to read/write for everyone. I didn't change the owenership (I think!)
By doing this, I managed to run xampp from http://localhost but I now I couldn't access phpmyadmin because of the New Xampp policy error. I tried the method given by johnb here:
http://community.apachefriends.org/f/viewtopic.php?f=17&t=50902&p=196185#p196185

It worked but now when I enter phpmyadmin and go to the database tab, I see a "No priviledges" error under "Create new database". :(

What should I do now?
AdrianaRulz
 
Posts: 3
Joined: 19. July 2012 04:08
XAMPP Version: 5.6.3
Operating System: Ubuntu 12.04

Re: Can't create database because of "No priviledges" error!

Postby JonB » 19. July 2012 13:47

who did you log in on MySQL as?
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Can't create database because of "No priviledges" error!

Postby AdrianaRulz » 19. July 2012 15:10

User Name: Admin
Password: Admin
AdrianaRulz
 
Posts: 3
Joined: 19. July 2012 04:08
XAMPP Version: 5.6.3
Operating System: Ubuntu 12.04

Re: Can't create database because of "No priviledges" error!

Postby JonB » 19. July 2012 15:25

"no"

You must be 'root' to initially administer a MySQL database. MySQL has nothing to do with your Linux OS login or LAMPP credentials

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Can't create database because of "No priviledges" error!

Postby AdrianaRulz » 20. July 2012 03:01

*slaps forehead*
As I told you. I'm dumb. Thanks anyways. It's working now. :)
AdrianaRulz
 
Posts: 3
Joined: 19. July 2012 04:08
XAMPP Version: 5.6.3
Operating System: Ubuntu 12.04

Re: Can't create database because of "No priviledges" error!

Postby JonB » 20. July 2012 14:35

OK - Great, glad it works

Good Luck with XAMPP and your project.

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


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 8 guests