phpMyAdmin - No privileges for Create new database

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

phpMyAdmin - No privileges for Create new database

Postby powderskier » 15. December 2005 17:36

Hello All,

I am currently trying to setup a test database on Xampp and when I login to phpmyadmin with the pma account, I am able to login correctly, but I cannot create a new database.

Can someone please tell me what security setting I am missing or what needs to be edited in the config.inc.php file?

Thanks,
powderskier
 
Posts: 5
Joined: 16. November 2005 17:32

Answer to the above problem

Postby powderskier » 19. December 2005 17:48

For those of you who did have this problem, log in as mysql root account tp phpmyadmin and you should be able to create a new db and access as needed. Sorry to those who looked at this if it seems obvious, not everyone is an expert with these tools :)
powderskier
 
Posts: 5
Joined: 16. November 2005 17:32

Re: Answer to the above problem

Postby DeepBlue » 17. February 2006 23:11

powderskier wrote: Sorry to those who looked at this if it seems obvious, not everyone is an expert with these tools :)


I think XAMPP is a wonderful tool - but I'm a Linux newbie and yes this one had me stumped as well. Can we get the documentation updated so that once you run the security script it actually tells you what you need to do next ;-)

And yes I would be happy to help with that task :-)
DeepBlue
 
Posts: 8
Joined: 01. December 2005 15:47
Location: Glenrothes

Postby Wiedmann » 17. February 2006 23:33

Can we get the documentation updated so that once you run the security script it actually tells you what you need to do next

I don't think so:
In the XAMPP documentation you can read, that MySQL have the user "root" with no password. Then in the security script you change this none password to something else --> the next time you use MySQL you must use the user "root" with your new password. That's all, there is nothing special to do after the security script.

BTW:
You can find the MySQL documentation at:
http://dev.mysql.com/doc/refman/5.0/en/index.html

and for phpMyAdmin:
http://www.phpmyadmin.net/home_page/docs.php
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby DeepBlue » 17. February 2006 23:51

Wiedmann wrote:
Can we get the documentation updated so that once you run the security script it actually tells you what you need to do next

I don't think so:In the XAMPP documentation you can read, that MySQL have the user "root" with no password.


Where?

In the documentation I read it said the userid was pma which works fine but has no priveleges once you set the password.

XAMPP is a wonderful, wonderful tool but is sadly let down by the poor documentation.
DeepBlue
 
Posts: 8
Joined: 01. December 2005 15:47
Location: Glenrothes

Postby Wiedmann » 18. February 2006 00:08

In the documentation I read it said the userid was pma

No, this is only a phpMyAdmin internal user --> read the documentation for phpMyAmdin.

Where?

e.g.: http://www.apachefriends.org/en/xampp-linux.html#381

from http://www.apachefriends.org/en/faq-xam ... l#sicherer:
LAMPP: MySQL has no root passwort set!!!
LAMPP: Do you want to set a password? [yes] yes

During the security script you can read, that the new password is for the MySQL user "root"...
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby DeepBlue » 18. February 2006 00:15

Wiedmann wrote:During the security script you can read, that the new password is for the MySQL user "root"...


Yes - but that doesn't make clear that you need to logon to phpmyadmin as root.

I think we will just need to agree to disagree.

Thanks for your time.

Alan
DeepBlue
 
Posts: 8
Joined: 01. December 2005 15:47
Location: Glenrothes

Postby Wiedmann » 18. February 2006 00:40

Yes - but that doesn't make clear that you need to logon to phpmyadmin as root.

Not? It's the only MySQL user you can read about...

For questions about MySQL and how to use it, the first address is the MySQL documentation. And there you can read, that the preconfigured user in MySQL is "root" (you can read this in the phpMyAdmin documentation also).

Or have a look in the XAMPP demoscript "cd database".
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 6 guests