0

Every time I create a database using a custom joomla template quick install the database is created but does not show up in MySQL Database management despite the fact that it most definitely does exist and MySQL database management knows it does because it wont let me create a database with that name due to error "Database already exists".

I want to delete joomlasall database.

http://img99.imageshack.us/img99/4995/tempkh.png

Full size image

http://img99.imageshack.us/img99/4995/tempkh.png

1
  • alternatively, if u knows where u have saved it u can delete it from there. Commented May 29, 2012 at 5:09

2 Answers 2

1

If you can not see database but you are sure that it exists, this is definitely permissions issue.

Do

SHOW GRANTS

More info here

You will see that you does not hold global SELECT privilege. You need to explicitly GRANT permissions with similar command like:

GRANT ALL PRIVILEGES ON DBNAME.* TO 'username'@'localhost';

Instead of ALL you can specify SELECT, INSERT, UPDATE, DELETE , EXECUTE, etc... check this

replace DBNAME with your DB name, username with user for whom you want to grant access and localhost with hostname if DB is used remotly.

To do this, you need GRANT privilege or to be root user.

Sign up to request clarification or add additional context in comments.

Comments

0

use same mysql user credentials for Joomla DB connectivity also the one you are using in phpmyadmin.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.