Access denied for user '{username}'@'localhost' (using password: YES) Topic is solved

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
ruraldev
Joomla! Intern
Joomla! Intern
Posts: 74
Joined: Fri Jun 30, 2006 5:57 pm

Access denied for user '{username}'@'localhost' (using password: YES)

Post by ruraldev » Fri Oct 22, 2021 2:24 pm

I recently had to restore my Joomla site and the admin works fine as does the frontend, allows me to login, but as soon as I click a menu item I get the error in the subject.

Ran FPA and don't see any issues, can anyone point me in the direction of what I am doing wrong?

Forum Post Assistant (v1.6.3) : 22-Oct-2021 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.10.2-Stable (Daraja) 12-September-2021
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: Is Not Empty | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: development | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.10.2: Yes | Database Supports J! 3.10.2: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.10.0-962.3.2.lve1.5.42.el7.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | System TMP Writable: Yes | Free Disk Space : 1390.41 GiB |

PHP Configuration :: Version: 7.4.23 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 32759 | Log Errors To: error_log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: | Open Base: | Uploads: 1 | Max. Upload Size: 32M | Max. POST Size: 32M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 64M

Database Configuration :: Version: 5.5.5-10.3.31-MariaDB (Client:mysqlnd 7.4.23) | Database Size: 7.10 MiB | #of Tables with config prefix: 169 | #of other Tables: 0 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (7.4.23) | date (7.4.23) | libxml (7.4.23) | openssl (7.4.23) | pcre (7.4.23) | zlib (7.4.23) | filter (7.4.23) | hash (7.4.23) | pcntl (7.4.23) | readline (7.4.23) | Reflection (7.4.23) | SPL (7.4.23) | session (7.4.23) | standard (7.4.23) | cgi-fcgi (7.4.23) | bcmath (7.4.23) | bz2 (7.4.23) | calendar (7.4.23) | ctype (7.4.23) | curl (7.4.23) | dom (20031129) | mbstring (7.4.23) | fileinfo (7.4.23) | ftp (7.4.23) | gd (7.4.23) | gettext (7.4.23) | iconv (7.4.23) | imap (7.4.23) | intl (7.4.23) | json (7.4.23) | exif (7.4.23) | mysqlnd (mysqlnd 7.4.23) | PDO (7.4.23) | Phar (7.4.23) | posix (7.4.23) | pspell (7.4.23) | SimpleXML (7.4.23) | soap (7.4.23) | sockets (7.4.23) | sqlite3 (7.4.23) | tidy (7.4.23) | tokenizer (7.4.23) | xml (7.4.23) | xmlwriter (7.4.23) | xsl (7.4.23) | zip (1.15.6) | mysqli (7.4.23) | pdo_mysql (7.4.23) | pdo_sqlite (7.4.23) | xmlreader (7.4.23) | xmlrpc (7.4.23) | redis (5.3.2) | imagick (3.4.4) | mcrypt (1.0.4) | timezonedb (2021.1) | ionCube Loader (10.4.5) | Zend OPcache (7.4.23) | Zend Engine (3.4.0) |
Potential Missing Extensions ::
Disabled Functions :: passthru | system | dl | proc_open | proc_nice | proc_terminate | proc_get_status | proc_close | leak | apache_child_terminate | escape | shellcmd | escapeshellarg | shell_exec | crack_check | crack_closedict | crack_getlastmessage | crack_opendict | psockopen | php_u | symlink | ini_restore | posix_getpwuid | pfsockopen |

Switch User Environment :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 65092 | Threads: 24 | Questions: 2693040 | Slow queries: 50 | Opens: 66247 | Flush tables: 1 | Open tables: 2000 | Queries per second avg: 41.372 |
Extensions Discovered :: wrote:Components :: Site ::
Core :: com_wrapper (3.0.0) 1 | com_mailto (3.0.0) 1 |
3rd Party::

Components :: Admin ::
Core :: com_users (3.0.0) 1 | com_cache (3.0.0) 1 | com_associations (3.7.0) 1 | com_installer (3.0.0) 1 | com_menus (3.0.0) 1 | com_joomlaupdate (3.10.1) 1 | com_contenthistory (3.2.0) 1 | com_login (3.0.0) 1 | com_media (3.0.0) 1 | com_config (3.0.0) 1 | com_fields (3.7.0) 1 | com_modules (3.0.0) 1 | com_categories (3.0.0) 1 | com_content (3.0.0) 1 | com_checkin (3.0.0) 1 | com_finder (3.0.0) 1 | com_languages (3.0.0) 1 | com_templates (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_newsfeeds (3.0.0) 1 | com_admin (3.0.0) 1 | com_messages (3.0.0) 1 | com_ajax (3.2.0) 1 | com_tags (3.1.0) 1 | com_redirect (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_privacy (3.9.0) 1 | com_search (3.0.0) 1 | com_banners (3.0.0) 1 | com_plugins (3.0.0) 1 |
3rd Party:: Akeeba (8.0.11) 1 | COM_BREEZINGFORMS (1.9.1 Stable ) 1 | sysbreezingforms (1.0.0) 0 | COM_GANTRY (4.1.43) 0 | com_gantry5 (5.4.37) 1 | plg_system_breezingcommerce (1.0.0) 0 | COM_BREEZINGCOMMERCE (1.0.9) 1 |

Modules :: Site ::
Core :: mod_tags_popular (3.1.0) 1 | mod_finder (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_login (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_articles_categories (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_search (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_whosonline (3.0.0) 1 |
3rd Party:: Responsive Slide Show (1.0) 1 | RokNavMenu (2.0.9) 1 | BreezingForms (1.8.4) 1 | BreezingCommerce - Mini Cart (1.0.2) 1 | BreezingCommerce - Filter (1.0.1) 1 | mod_gantry5_particle (5.4.37) 1 | BreezingCommerce - Categories (1.0.2) 1 | Crosstec IconicButtons (1.0.0) 1 | BreezingCommerce - Currencies (1.0.1) 1 |

Modules :: Admin ::
Core :: mod_quickicon (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_status (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_title (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_login (3.0.0) 1 | mod_version (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_latest (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_custom (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_feed (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_submenu (3.0.0) 1 |
3rd Party::

Libraries ::
Core ::
3rd Party:: file_fof30 (3.6.2) ? | Regular Labs Library (21.9.16879) 1 | SIM Tools! (1.0) ? | file_fof40 (4.0.9) ? |

Plugins ::
Core :: PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_webinstaller (2.1.2) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_quickicon_eos310 (3.10.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_captcha_recaptcha (3.4.0) 0 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_pagebreak (3.0.0) 1 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_system_sessiongc (3.8.6) 1 | plg_system_logout (3.0.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_fields (3.7.0) 1 | plg_system_sef (3.0.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_stats (3.5.0) 1 | plg_system_p3p (3.0.0) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_log (3.0.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_updatenotification (3.5.0) 1 |
3rd Party:: plg_quickicon_akeebabackup (8.0.11) 1 | plg_quickicon_gantry5 (5.4.37) 1 | plg_editors_codemirror (5.60.0) 1 | plg_editors_tinymce (4.5.12) 1 | PLG_EDITORS-XTD_SOURCERER (9.0.2) 1 | PLG_ACTIONLOG_AKEEBABACKUP (8.0.11) 0 | plg_gantry5_preset (5.4.37) 0 | BreezingForms - AddOns - Zapier (1.0) 1 | PLG_SOCIALLOGIN_GOOGLE (1.0.2) 0 | PLG_SOCIALLOGIN_TWITTER (1.0.2) 0 | PLG_SOCIALLOGIN_FACEBOOK (1.0.2) 0 | BreezingForms - Content - Download (1.1) 1 | BreezingForms (1.8) 1 | PLG_SYSTEM_BACKUPONUPDATE (8.0.11) 0 | PLG_SYSTEM_REGULARLABS (21.9.16879) 1 | sysbreezingforms (1.0.0) 0 | System - Gantry 4 (4.1.43) 1 | System - RokExtender (2.0.0) 1 | plg_system_gantry5 (5.4.37) 1 | PLG_SYSTEM_SOURCERER (9.0.2) 1 | PLG_SYSTEM_SOCIALLOGIN (1.0.2) 0 | plg_system_breezingcommerce (1.0.0) 0 |
Templates Discovered :: wrote:Templates :: Site :: rt_interstellar (1.0.6) 1 | rt_aurora (1.0.0) 1 | protostar (1.0) 1 | Cleanlogic3 (1.0) 1 | beez3 (3.1.0) 1 | NaturalWay (1.2) 1 |
Templates :: Admin :: hathor (3.0.0) 1 | isis (1.0) 1 |
Last edited by toivo on Sat Oct 23, 2021 3:42 am, edited 1 time in total.
Reason: mod note: disabled smilies in post Options for readability

User avatar
JAVesey
Joomla! Hero
Joomla! Hero
Posts: 2374
Joined: Tue May 14, 2013 1:21 pm
Location: Cardiff, Wales, UK
Contact:

Re: Access denied for user '{username}'@'localhost' (using password: YES)

Post by JAVesey » Fri Oct 22, 2021 4:16 pm

"Live Site" in configuration.php would normally be empty.

Edit your configuration.php to remove the entry, i.e. make it:

Code: Select all

	public $live_site = '';
John V
Cardiff, Wales, UK
Uses Joomla 3.10.3 and PHP8.0.13

ruraldev
Joomla! Intern
Joomla! Intern
Posts: 74
Joined: Fri Jun 30, 2006 5:57 pm

Re: Access denied for user '{username}'@'localhost' (using password: YES)

Post by ruraldev » Fri Oct 22, 2021 4:20 pm

Unfortunately that didn't make any difference, but thanks for trying.

I just find it very strange that the site works and as such the credentials must be correct!

I get these 2 warnings if it helps.

Warning: session_start(): Failed to initialize storage module: user (path: /var/cpanel/php/sessions/ea-php73) in /home/vehic2/public_html/iot/libraries/vendor/joomla/session/src/Storage/NativeStorage.php on line 478

Warning: mysqli::prepare(): invalid object or resource mysqli in /home/vehic2/public_html/iot/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php on line 137

ruraldev
Joomla! Intern
Joomla! Intern
Posts: 74
Joined: Fri Jun 30, 2006 5:57 pm

Re: Access denied for user '{username}'@'localhost' (using password: YES)

Post by ruraldev » Fri Oct 22, 2021 5:02 pm

I've just noticed that it's trying to access files on the old site rather than the new site but not sure where that setting would be

/home/vehic2/public_html/iot/

should be

/home/vehic2/public_html/iot2/

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27809
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Access denied for user '{username}'@'localhost' (using password: YES)

Post by imanickam » Sat Oct 23, 2021 3:07 am

ruraldev wrote:
Fri Oct 22, 2021 5:02 pm
I've just noticed that it's trying to access files on the old site rather than the new site but not sure where that setting would be
You have to check to which directory your domain (site's URL) is pointing to. Mostly this setting is available in the cPanel of your hosting services - NOT Joomla!

I would also suggest checking about this with your host service provider.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
ex-Joomla! Translations Coordination Team
Eegan - Support the poor and underprivileged

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

Re: Access denied for user '{username}'@'localhost' (using password: YES)

Post by Per Yngve Berg » Sat Oct 23, 2021 9:42 am

I will recommend changing session handler from 'database' to php 'none' in Global Configuration.

Did you make a new database for the second site?

ruraldev
Joomla! Intern
Joomla! Intern
Posts: 74
Joined: Fri Jun 30, 2006 5:57 pm

Re: Access denied for user '{username}'@'localhost' (using password: YES)

Post by ruraldev » Sat Oct 23, 2021 1:25 pm

Thanks got it sorted, it was all caused by a redirect in .htaccess


Post Reply

Return to “General Questions/New to Joomla! 3.x”