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

Joomla versions 2.5, 1.7 and 1.6 are all end-of-life since December 31st 2014 and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
TheINIC
Joomla! Intern
Joomla! Intern
Posts: 92
Joined: Thu Feb 17, 2011 5:27 am
Location: Earth - but that too is temporary.
Contact:

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

Post by TheINIC » Thu Apr 16, 2015 8:11 pm

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
Official Head Computer Whisperer(Someone had to do it.)

User avatar
NathanHawks
Joomla! Ace
Joomla! Ace
Posts: 1900
Joined: Wed Oct 02, 2013 6:17 pm
Location: Washington state, U.S.
Contact:

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

Post by NathanHawks » Thu Apr 16, 2015 10:22 pm

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).
Save time - hire me for your Joomla to-do list! http://nathanhawks.us/joomla

TheINIC
Joomla! Intern
Joomla! Intern
Posts: 92
Joined: Thu Feb 17, 2011 5:27 am
Location: Earth - but that too is temporary.
Contact:

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

Post by TheINIC » Thu Apr 16, 2015 11:57 pm

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
Official Head Computer Whisperer(Someone had to do it.)

User avatar
NathanHawks
Joomla! Ace
Joomla! Ace
Posts: 1900
Joined: Wed Oct 02, 2013 6:17 pm
Location: Washington state, U.S.
Contact:

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

Post by NathanHawks » Fri Apr 17, 2015 12:34 am

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.
Save time - hire me for your Joomla to-do list! http://nathanhawks.us/joomla

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 26192
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

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

Post by Per Yngve Berg » Fri Apr 17, 2015 6:29 am

Check that the Database User have permissions to the Database Tables.


Locked

Return to “Installation Joomla! 2.5”