Page 1 of 1

Need to fix "Your account is not associated with any databas

Posted: Thu Apr 16, 2015 8:11 pm
by TheINIC
Hi,

I had the Host do a complete restore of the site.
The site works. But Joom Admin login fails

Now, MySQL and myPhpAdmin show no dbases.
I can manually restore backup sql files, but they don't show up.

There is a message that in MySQL that states: "Your account is not associated with any databases."

Help is greatly appreciated

i

Re: Need to fix "Your account is not associated with any dat

Posted: Thu Apr 16, 2015 10:22 pm
by NathanHawks
You are saying that if you use phpMyAdmin to import a .sql dump file, it reports success but no tables or databases are created?

Perhaps the dump file did not include database creation commands. If that's the case you would just need to create the database with the same name as shown in your configuration.php file, and also a database user. (You could also change these values, e.g. for security - just be sure, if you change any of those things, that the db name, username, and password are updated in configuration.php as well).

Re: Need to fix "Your account is not associated with any dat

Posted: Thu Apr 16, 2015 11:57 pm
by TheINIC
you would just need to create the database with the same name as shown in your configuration.php file
Sorry I wasn't more specific. Here is what happened, and what I've tried.
  • Host restored from cPanel full backup.
  • Site would not come up = 403
  • Host said permissions were wrong and reset them. Site comes up.
  • Cannot access Joomla Admin. Invalid user/pword.
going to cPanel
  • Open MySQL databases. No databases, or users listed.
  • Open PhpMyAdmin. Only the standard "information_schema" is there.
    back to cPanel
  • MySQL > manually create database = error "The database “clname_jum2528” already exists.
back to PhpMyAdmin
  • Import "clname_jum2528.sql" The following is the error:
    • SQL query:
      --
      -- Table structure for table `jos_assets`
      --
      DROP TABLE IF EXISTS `jos_assets` ;
      MySQL said: Documentation
      #1046 - No database selected
    I know there has to be a database name, but since the main Joomla page loads, and MySQL doesn't list any dbases, but says clname_jum2528 already exists - was worth a try.
You can see my dilemma.

i

Re: Need to fix "Your account is not associated with any dat

Posted: Fri Apr 17, 2015 12:34 am
by NathanHawks
The site can't come back up with no databases -- you would get no farther than a white screen with the plain words "Application instatiation error".

Somehow it seems both your cPanel and your phpMyAdmin are only partially connected to the MySQL server, which isn't too weird since they had to do a restoration project and could have done it manually and missed a step.

It makes sense that you cannot select a database if they are not showing you the database in the phpMyAdmin UI... it seems like you will not need to re-import, but it is unclear why your Admin password would fail.

First verify that the host in your configuration.php file is set to whatever you expect it to be set to. (This varies drastically by hosting account.) If you are sure it is right, explain to your hosting support that phpMyAdmin can't see your Joomla database despite the fact that it obviously exists. If you are sure it is the wrong host, ask them about that. If you aren't sure what it should be, their docs will tell you how to determine your database hostname as per your service level and how they configure their provisions.

Re: Need to fix "Your account is not associated with any dat

Posted: Fri Apr 17, 2015 6:29 am
by Per Yngve Berg
Check that the Database User have permissions to the Database Tables.