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
Need to fix "Your account is not associated with any databas
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.
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.
-
- 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
►Official Head Computer Whisperer◄(Someone had to do it.)
- NathanHawks
- 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
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).
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
-
- 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
Sorry I wasn't more specific. Here is what happened, and what I've tried.you would just need to create the database with the same name as shown in your configuration.php file
- 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.
- 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.
- 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
- SQL query:
i
►Official Head Computer Whisperer◄(Someone had to do it.)
- NathanHawks
- 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
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.
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
- Per Yngve Berg
- Joomla! Master
- Posts: 26190
- Joined: Mon Oct 27, 2008 9:27 pm
- Location: Akershus, Norway
Re: Need to fix "Your account is not associated with any dat
Check that the Database User have permissions to the Database Tables.