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

Database Error after Upgrade to PHP5.2

Discussion in 'Plesk 9.x for Linux Suggestions and Feedback' started by teddy, Jun 22, 2010.

  1. teddy

    teddy Guest

    0
     
    Hi,

    i upgrade today my php 5.1.6 tp php 5.2.13
    php and all user mysql-database works correctly, but i have not access as root (over the plesk panel) to mysql.
    i can´t create new databases or change databases (e.g. password or user)
    also i can´t change the admin-password.

    error-message on plesk - when i will create a db-user:
    Table 'mysql.servers' doesn't exist

    all permission from plesk to the database not avaible.

    what can i do?
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,543
    Likes Received:
    1,239
    Location:
    Novosibirsk, Russia
    Mysql root user is replaced to admin user during Plesk installation. You can use following command for full access to mysql:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow`
     
  3. teddy

    teddy Guest

    0
     
    Fixed

    Hi,

    the Problem was fixed.
    The error was not a problem from plesk - but i´ve installed the php5 update from http://www.atomicorp.com/
    In this update i alos installed a mysql upgrade.
    On this it gives an error - but one database table are not present an mysql was looking for them.

    I create the table with server in the database mysql with:

    CREATE TABLE `servers` (
    `Server_name` char(64) NOT NULL,
    `Host` char(64) NOT NULL,
    `Db` char(64) NOT NULL,
    `Username` char(64) NOT NULL,
    `Password` char(64) NOT NULL,
    `Port` int(4) DEFAULT NULL,
    `Socket` char(64) DEFAULT NULL,
    `Wrapper` char(64) NOT NULL,
    `Owner` char(64) NOT NULL,
    PRIMARY KEY (`Server_name`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8
    COMMENT='MySQL Foreign Servers table';
     
  4. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
  5. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,543
    Likes Received:
    1,239
    Location:
    Novosibirsk, Russia
  6. GravuTrad

    GravuTrad Regular Pleskian

    28
    23%
    Joined:
    Apr 28, 2006
    Messages:
    269
    Likes Received:
    0
    I have the same problem. Important and noted.
     
  7. GravuTrad

    GravuTrad Regular Pleskian

    28
    23%
    Joined:
    Apr 28, 2006
    Messages:
    269
    Likes Received:
    0
    But the library is still in 5.0.90 while mysql is in 5.1.48.

    How to solve this?
     
Loading...