Page 1 of 1

phpMyAdmin - No privileges for Create new database

PostPosted: 15. December 2005 17:36
by powderskier
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,

Answer to the above problem

PostPosted: 19. December 2005 17:48
by powderskier
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 :)

Re: Answer to the above problem

PostPosted: 17. February 2006 23:11
by DeepBlue
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 :-)

PostPosted: 17. February 2006 23:33
by Wiedmann
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

PostPosted: 17. February 2006 23:51
by DeepBlue
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.

PostPosted: 18. February 2006 00:08
by Wiedmann
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"...

PostPosted: 18. February 2006 00:15
by DeepBlue
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

PostPosted: 18. February 2006 00:40
by Wiedmann
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".