1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Unable to connect to MySQL

Discussion in 'Plesk 11.x for Windows' started by tgtcat6, Jul 17, 2012.

  1. tgtcat6

    tgtcat6 Guest

    0
     
    I've upgraded to 11, but when I try and apply updates, I'm getting

    WARNING: Unable to connect to local default MySQL server. Read carefully article http://kb.parallels.com/en/111983 for details.

    I've followed the directions in the KB mentioned, but haven't had any luck yet.

    Am I missing something?
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,543
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    But can you connect to MySQL server with command

    ?
     
  3. tgtcat6

    tgtcat6 Guest

    0
     
    I can sort of connect, but when it prompts for the admin password, it just doesn't work

    ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password:
    YES)

    I've double checked the admin password with the select command located in that article; I've even been able to change the admin password, but that hasn't allowed me to actually connect
     
  4. MansurE

    MansurE New Pleskian

    10
    85%
    Joined:
    Apr 24, 2012
    Messages:
    12
    Likes Received:
    0
    Same Problem

    I recive the Same problem.
    As mentioned in the KB http://kb.parallels.com/en/111983

    I am able to connect the DB via mysql.exe" -uadmin -p<password> -hlocalhost

    Executing the following command I get as expected the following Response:
    dbclient.exe --direct-sql --sql="select * from databaseservers where type='mysql' and host='localhost'"

    1 localhost 3306 mysql 5.1.48 admin <password> 0
    no_error


    Even when I try to reset the Passwort with the following Command I recive the Error while Updateing:
    dbclient.exe --direct-sql --sql="Update databaseservers set admin_login='admin', admin_password='<password>' where host='localhost' and type='mysql'"

    I also tryed to retype the Passwort via the Plesk Frontend - Databaseserver - Tool
     
  5. MansurE

    MansurE New Pleskian

    10
    85%
    Joined:
    Apr 24, 2012
    Messages:
    12
    Likes Received:
    0
    Possible Solution

    In my Installation there are two MySQL installations on the Server.
    On Ports 3306 and 8306

    After setting the Databaselogin to the following it worked:
    User: admin
    Passwort: The regular PLESK Password (The Panellogin Password)

    May it helps
     
  6. tgtcat6

    tgtcat6 Guest

    0
     
    Yeah, it looks like I have MySQL 4.1 and 5.0

    Which one should I be using?
     
  7. MansurE

    MansurE New Pleskian

    10
    85%
    Joined:
    Apr 24, 2012
    Messages:
    12
    Likes Received:
    0
    I mean the 4.1 MySQL is the one Plesk uses as an internal Database (Plus PHP4).
    In there the Password is also stored.

    The MySQL 5.x is the Customerdatabase and - what I reccon - should have the same Connection settings as the Plesk Login. You should keep that one for the Customers, because 5.x is the regular version nowadays.

    User this article:
    http://kb.parallels.com/en/111983

    and update the Data not on the Database connected on the 3306 Port. Instead update the Data on the 8306-Port - Database.

    Just suggestion ... it helped me for that problem, but still I cant download Licencekey and Updates ...
    Thatfor I investigate more in an another Thread with no help from others till now.
     
  8. tgtcat6

    tgtcat6 Guest

    0
     
    Yeah, I've already tried that KB article, that hasn't helped me
     
  9. InderS

    InderS Silver Pleskian

    15
    30%
    Joined:
    Apr 17, 2013
    Messages:
    968
    Likes Received:
    1
    Location:
    Nashik
    With plesk 11 you should go for mysql 5 and have you checked the error logs of mysql?
     
Loading...