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

mysql is dead

Discussion in 'Plesk for Windows - 8.x and Older' started by jorfermo, Jul 7, 2005.

  1. jorfermo

    jorfermo Regular Pleskian

    26
     
    Joined:
    Jun 22, 2005
    Messages:
    102
    Likes Received:
    0
    Hi.

    Hi have P7.5 running but suddenly something seems to have happened to mysql.

    I've I try to create databases it shows: "Unable to create database: Run-time error: Failed to connect to database: Can't connect to MySQL on 'localhost' (10061)"

    Under mysql database administration on control panel appears a yellow icon and shows: "database is not running or l/p are incorrect".

    Seems mysql is not running but I don't know how to fix it.

    Any idea?

    Thanks in advance!
     
  2. jorfermo

    jorfermo Regular Pleskian

    26
     
    Joined:
    Jun 22, 2005
    Messages:
    102
    Likes Received:
    0
    There must be somethign wrong because in database administration panel, mysql is pointing to localhost:3306 instead of 10061
     
  3. botsman

    botsman Guest

    0
     
    On this page( server>databases>mysql) you have set valid mysql credentials. IF you don' know them you can open %plesk_dir%\databases\mysql\data\my.ini file, set there "skip-grant-tables" otpion, restart mysql, login there without any password and update password for admin(root) user, then remove skip-grant-tables option , restart mysql again and enter updated credentils to plesk.

    P.S. 10061 isn't port number, but mysql error number that menas access denied.
     
  4. jorfermo

    jorfermo Regular Pleskian

    26
     
    Joined:
    Jun 22, 2005
    Messages:
    102
    Likes Received:
    0
    Thanks for your reply.

    I think credentials are ok because I haven't changed it.

    Problem must be with mysql not running. I've checked with netstat and telnet and port 3306 is not opened. Another clue is in this page: Server -> Component Managment, under the row "SQL Servers" only appears MSSSQL.

    How can I test if mysql is running?. Does it run as windows service?
     
  5. jorfermo

    jorfermo Regular Pleskian

    26
     
    Joined:
    Jun 22, 2005
    Messages:
    102
    Likes Received:
    0
    I answer myself.

    I've located MySQL service but if I try to start it it deads after 3 or 4 seconds. This is the output of <server>.err file:

    InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 25165824 bytes!
    050707 12:20:54 [ERROR] Can't init databases
    050707 12:20:54 [ERROR] Aborting

    050707 12:20:54 [Note] C:\Archivos de programa\SWsoft\Plesk\Databases\MySQL\bin\mysqld-nt: Shutdown complete


    Any idea?
     
  6. swarm

    swarm Guest

    0
     
    It seems ibdata corrupted. Try to stop MySQL and rename files ib_logfile0, ib_logfile1 and ibdata1. Then start MySQL and look if it works.
     
Loading...