Error Pleskmaindbexception
Contents |
& Site Management Integration Options Developers eMail Components CloudLinux Extensions Extension Catalog Submit your Extension Plans & Pricing Support Resources FAQs Forums Knowledge Base Documentation Downloads Plesk University Release access denied for user admin localhost using password yes notes Blog Become a Partner Russian German French Spanish Chinese Japanese plesk mysql admin password Italian Language English Russian German French Spanish Chinese Japanese Italian any Search ERROR PleskMainDBException Access denied for
Access Denied For User ''@'localhost' (using Password: Yes)
user 'admin'@'localhost' (using password: YES) Article ID: 119188, created on Dec 16, 2013, last review on Mar 23, 2016 Applies to: Plesk for Windows Symptoms After upgrading Plesk on
Access Denied For User Root Localhost Using Password Yes
Windows or after changing the admin password, the following error is shown instead of the Plesk login page: Access denied for user 'admin'@'localhost' (using password: YES) Similar error appears when you are opening the phpmyadmin page after the issue above is resolved: You probably did not create a configuration file. You might want to use the setup error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes) script to create one. #1045 - Access denied for user 'admin'@'localhost' (using password: YES) Cause An incorrect password is set in the MySQL database for the admin user. Resolution 1. The first case error with MySQL on port 8306 can be repaired in 3 steps: 1.1. Add the skip-grant-tables option under the [PleskSQLServer] section of the file: "%plesk_dir%"\MySQL\Data\my.ini Then restart the "Plesk SQL Server" service. net stop PleskSQLServer net start PleskSQLServer 1.2. Then change the admin password: "%plesk_cli%"\init_conf.exe --set-admin-password -passwd
Microsoft OLE DB Provider for SQL Server
Description: Login failed for user 'admin'. 0: plib\common_func.php3:624 db_mssql_connection() 1: plib\common_func.php3:653 reconnect() 2: plib\common_func.php3:614 db_connect() 3: auto_prepend\auth.php3:80 Causes This happens when Plesk is not able to log into its PSA database. The most common causes for this are: SQL is not running The "admin" user's password was changed. Resolution Unless you have a dedicated server these steps must be performed by a member of our Support staff. SQL is not running https://kb.plesk.com/en/119188 Confirm MSSQL Server is running by double clicking on the Plesk Services Monitor. If there is an X next to the MSSQL Server, check the SQL Server box and click the Start button. The "admin" user's password was changed. Step 1: Reset the "admin" password in SQL. Log into the server via remote desktop Open SQL https://support.managed.com/kb/a442/error-pleskmaindbexception.aspx Server Management Studio and connect to the local server In Management Studio, Go to Security > Logins. Right-Click on the admin user and select Properties Under Password and Confirm Password, type in the new password and then click OK Step 2: Reset the "admin" password in Plesk. Click on Start > Run (or Windows - R). Type cmd and press enter. In the command prompt, type (the quotes are required): "%plesk_bin%\PleskSrvClient.exe" A Set Plesk Admin Password dialog will appear. It will display an error message indicating that it can not connect to the Plesk SQL Server. That is OK. Type in the same password you typed above and then click OK followed by Yes. You will now be able to log into Plesk with the password you entered. Article ID: 442, Created: April 9, 2012 at 3:40 PM, Modified: August 26, 2014 at 8:59 AM Add Feedback Was this article helpful? Yes No Thanks for your feedback... Share this articleFacebookGoogle+TwitterOther Social Networks × Share With OthersBlinkListBlogmarksdel.icio.usDiggDiigoFacebookFriendFeedGoogle+LinkedInNetvouzNewsVineRedditStum
Discussion in 'Plesk 9.x for Windows Issue, Fixes, How-To' started by FatanehE, Aug 1, 2013. FatanehE Kilo Poster Messages: 41 Hello, I'm using plesk http://forum.odin.com/threads/error-pleskmaindbexception-db-query-failed-unknown-error.289573/ 9.5.4 when I enter the plesk url I give this error: ERROR: PleskMainDBException http://trulymanaged.com/blog/plesk-error-pleskmaindbexception/ DB query failed: Unknown error 0: common_func.php3:171 db_query(string 'set names utf8') 1: common_func.php3:626 reconnect() 2: common_func.php3:591 db_connect() 3: auth.php3:90 I done this article: http://kb.parallels.com/en/115602 but there is problem yet, I see administrator pass plesk and I can login to plesk mysql with same password but plesk has problem. I restart all access denied services and finally reset the server but problem doesn't resolve. Please guide me Last edited: Aug 2, 2013 FatanehE, Aug 1, 2013 #1 FatanehE Kilo Poster Messages: 41 Aren't there any solutions? I can't work with plesk! FatanehE, Aug 2, 2013 #2 IgorG Odin Team Messages: 19,081 Contact Support Team if this article doesn't help. Looks like there is other root cause access denied for of this issue. IgorG, Aug 2, 2013 #3 FatanehE Kilo Poster Messages: 41 IgorG said: ↑ Contact Support Team if this article doesn't help. Looks like there is other root cause of this issue.Click to expand... how to contact support team? FatanehE, Aug 2, 2013 #4 IgorG Odin Team Messages: 19,081 http://www.parallels.com/support IgorG, Aug 2, 2013 #5 (You must log in or sign up to reply here.) Show Ignored Content Share This Page Tweet Your name or email address: Do you already have an account? No, create an account now. Yes, my password is: Forgot your password? Stay logged in Odin Forum Home Forum > More Products Discussion > Older Panel Software Versions > Plesk 9.x for Windows > Plesk 9.x for Windows Issue, Fixes, How-To > Home Forum Forum Quick Links Search Forum Recent Posts Members Members Quick Links Notable Members Current Visitors Recent Activity Knowledgebase Menu Search Search titles only Posted by Member: Separate names with a comma. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Contact Us Help Home Top RSS Terms and Rules
'psa.APSApplicationItems' doesn't exist 0: /usr/local/psa/admin/plib/common_func.php3:218 db_query(string 'SHOW CREATE TABLE `APSApplicationItems`') 1: /usr/local/psa/admin/plib/SQLParser.php:27 SQLParser->handleDatabase() 2: /usr/local/psa/admin/plib/MySQL5FixBinaryColumns.php:36 MySQL5FixBinaryColumns::run() 3: /usr/local/psa/admin/auto_prepend/auth.php3:90 SOLUTION: The Main reason of this problem is corrupted Plesk Database. We can check that using following command [root@server ~]# mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow ` psa psa.APSApplicationItems error : Table 'psa.APSApplicationItems' doesn't exist psa.APSClientApplicationItems error : Table 'psa.APSClientApplicationItems' doesn't exist psa.APSLicenseTypes error : Table 'psa.APSLicenseTypes' doesn't exist psa.APSLicenses error : Table 'psa.APSLicenses' doesn't exist To resolve the issue, please do the following: - remove corrupted tables from plesk database - restore them from plesk database distributive you can do above using following Steps 1. Backup undamaged Tables mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -NB -e'show tables' > ../tables for i in `cat ../tables` do mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa $i > $i.sql done 2. Remove Plesk database from /var/lib/mysql/ manually. 3. Restore the latest valid daily dump which can be found in /var/lib/psa/dumps/ directory. 4. Finally Restore the backup which we have taken on step 1. for i in `cat ../tables` do echo $i mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa < $i.sql done NOTE: Fix for this problem is completely depends upon the error you are getting. So, be careful before trying this fix. Bookmark To: Tags: corrupted Plesk Database., PleskMainDBExceptionPosted in Plesk For Linux, VPS hosting, Windows VPS | 1 Comment » One Comment to "Plesk ERROR: PleskMa