permission to create a new database

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

permission to create a new database

Postby ericericsen » 11. March 2005 13:12

I would be most grateful for an explanation of how I could create a database other than test. I have no difficulty in using mysql>drop database test; but when I try mysql> create database new; I am told that Access is denied for user ''@'%' to database new. So far as I can tell XAMPP is configured so that the user is root and there is no password. Using this configuration I have no difficulty in creating tables in the test database and adding and retrieving data from with PHP code via the Apache server on localhost. (And when I used MySQL as a stand-alone server I don't encounter this glitch. XAMPP is a marvel in that it spares us the trials of configuring Apache.)

Perhaps the solution is blindingly obvious but in this area of human endeavour I am surprised with increasing frequency at my lack of intuition
ericericsen
 
Posts: 2
Joined: 11. March 2005 12:41
Location: winchester

Postby Dave_L » 11. March 2005 15:50

Try:

mysql -u root -p

Or use phpMyAdmin:

http://localhost/phpmyadmin/
User avatar
Dave_L
 
Posts: 212
Joined: 23. October 2004 00:43

permission to create a new database

Postby ericericsen » 16. March 2005 14:14

Many thanks to Dave_L for his two suggestions. The first does not do the trick whereas the second works a treat - providing all the functionality I sought and much more too. I have stopped looking in that dreadful little black window which responded to my requests as if it were the right hemisphere of a split-brain preparation .

Kind regards

ericericsen
ericericsen
 
Posts: 2
Joined: 11. March 2005 12:41
Location: winchester


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 137 guests