1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

No psa database in mysql

Discussion in 'Plesk for Windows - 8.x and Older' started by Joost@, Feb 19, 2005.

  1. Joost@

    Joost@ New Pleskian

    22
    23%
    Joined:
    Feb 19, 2005
    Messages:
    6
    Likes Received:
    0
    I trying to setup a secondary dns server for my plesk installation.
    Therefore I need to allow zone transfers from certain ip's.
    The manual states that I should add a few records to the misc table of the psa database.
    When I connect to mysql with the admin username and password, there is no psa database there. I only see a mysql and a test database.

    These are exactly the 2 that show up in the phpMyAdmin control pages.

    I'm running the brand new 7.5

    I updated 7.0 with this version, and all went well. There should be a database somewhere, because I'm able to login to the control panel, add a domain and stuff.

    Is there perhaps another instance of mysql that psa uses for internal data storage?
     
  2. Joost@

    Joost@ New Pleskian

    22
    23%
    Joined:
    Feb 19, 2005
    Messages:
    6
    Likes Received:
    0
    Ok, I've found the solution to this and will post it here because it might be helpfull to others.

    There are two instances of MySQL running, one on port 3306 (default) and one on 8306.

    Use the -P option of the mysql.exe client tool to specify the port:

    mysql -u admin -p -P 8306
     
  3. jbinette

    jbinette Guest

    0
     
    Anyone know the default password of default SQL Server .... the one on port 3306 .... ? i have some error when i try to backup the Plesk 7.5 user@localhost.com bad password....

    Thank You

    Jonathan
     
  4. Lenman

    Lenman Guest

    0
     
    I am getting the same error. Anyone have an idea how to get the password or reset it?
     
  5. Davo

    Davo Guest

    0
     
    To change the common MySQL server root password go to 'Server', 'Databases', click on the 'MySQL' tab, and click on change password. You don't need to know the old password.
     
  6. webbit

    webbit Guest

    0
     
    mysql password on port 8306

    Is the password for mysql on port 8306 the same as my plesk password?

    If not how can I set it and add another user to the DB?

    Thanks.
     
  7. swarm

    swarm Guest

    0
     
    Re: mysql password on port 8306

    Yes, it's the same. You can login to MySQL on port 8306 with user 'admin' and your Plesk pass.
     
Loading...