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

Error creating MySQL Database

Discussion in 'Plesk for Windows - 8.x and Older' started by topws, Mar 1, 2006.

  1. topws

    topws Guest

    0
     
    When i try to create a MySQL database from Plesk 7.5 for windows, i get the following error:

    Unable to create database: Create new database failed: Run-Time error: Failed to connect to database: Can't connect to MySQL server on 'localhost' (10061)

    Can anyone help me please.
     
  2. swarm

    swarm Guest

    0
     
    In most cases there is connection from Plesk to MySQL server doesn't established. So you should go to Plesk CP -> Server -> Databases and set proper connections settings.
     
  3. topws

    topws Guest

    0
     
    i checked in services, MySQL service in not running. When i start it, it cannot start and gives the error message.

    I want to ask that if i do a fresh installation of MySql, does it effect the data of plesk???
     
  4. OlegB

    OlegB Guest

    0
     
    There is no need to reinstall mysql. You need just take a look into MySQL error log located at
    %plesk_dir%databases\mysql\data
    and called <hostname>.err

    and find out what exact thing does not let MySQL to get started.
     
  5. topws

    topws Guest

    0
     
    The errors are as follow:

    051215 5:02:30 InnoDB: Started; log sequence number 0 7771220
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060102 8:53:11 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060102 8:53:13 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 18 user: 'admin'

    060102 8:53:13 InnoDB: Starting shutdown...
    060102 8:53:15 InnoDB: Shutdown completed; log sequence number 0 8700797
    060102 8:53:15 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060102 8:54:40 InnoDB: Started; log sequence number 0 8700797
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060102 10:45:19 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060102 10:45:20 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: 'admin'

    060102 10:45:20 InnoDB: Starting shutdown...
    060102 10:45:23 InnoDB: Shutdown completed; log sequence number 0 8700846
    060102 10:45:23 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060102 10:46:56 InnoDB: Started; log sequence number 0 8700846
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060102 11:08:53 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060102 11:08:54 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: 'admin'

    060102 11:08:54 InnoDB: Starting shutdown...
    060102 11:08:56 InnoDB: Shutdown completed; log sequence number 0 8700856
    060102 11:08:56 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060102 11:10:29 InnoDB: Started; log sequence number 0 8700856
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060102 11:39:22 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060102 11:39:24 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: 'admin'

    060102 11:39:24 InnoDB: Starting shutdown...
    060102 11:39:25 InnoDB: Shutdown completed; log sequence number 0 8700866
    060102 11:39:25 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060102 11:40:59 InnoDB: Started; log sequence number 0 8700866
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060102 16:54:03 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060102 16:54:05 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 33 user: 'admin'

    060102 16:54:05 InnoDB: Starting shutdown...
    060102 16:54:08 InnoDB: Shutdown completed; log sequence number 0 8710927
    060102 16:54:08 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060102 16:55:42 InnoDB: Started; log sequence number 0 8710927
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060108 5:00:26 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060108 5:00:28 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: 'admin'

    060108 5:00:28 InnoDB: Starting shutdown...
    060108 5:00:30 InnoDB: Shutdown completed; log sequence number 0 9625065
    060108 5:00:30 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060108 5:02:20 InnoDB: Started; log sequence number 0 9625065
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060117 13:40:12 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060117 13:40:13 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: 'admin'

    060117 13:40:13 InnoDB: Starting shutdown...
    060117 13:40:15 InnoDB: Shutdown completed; log sequence number 0 9991725
    060117 13:40:15 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060117 13:41:40 InnoDB: Started; log sequence number 0 9991725
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060117 17:10:36 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060117 17:10:38 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: 'admin'

    060117 17:10:38 InnoDB: Starting shutdown...
    060117 17:10:40 InnoDB: Shutdown completed; log sequence number 0 10096385
    060117 17:10:40 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060117 17:12:16 InnoDB: Started; log sequence number 0 10096385
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060118 7:14:00 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060118 7:14:02 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 4 user: 'admin'

    060118 7:14:02 InnoDB: Starting shutdown...
    060118 7:14:03 InnoDB: Shutdown completed; log sequence number 0 10140310
    060118 7:14:03 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060118 7:15:40 InnoDB: Started; log sequence number 0 10140310
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060209 9:02:22 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060209 9:02:24 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 4 user: 'admin'

    060209 9:02:24 InnoDB: Starting shutdown...
    060209 9:02:26 InnoDB: Shutdown completed; log sequence number 0 12105656
    060209 9:02:26 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060209 9:03:15 InnoDB: Started; log sequence number 0 12105656
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060215 7:54:23 InnoDB: Operating system error number 32 in a file operation.
    InnoDB: Some operating system error numbers are described at
    InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
    InnoDB: File name .\ibdata1
    InnoDB: File operation call: 'open'.
    InnoDB: Cannot continue operation.
    060215 8:31:50 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060215 8:31:51 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: 'admin'

    060215 8:31:51 InnoDB: Starting shutdown...
    060215 8:31:54 InnoDB: Shutdown completed; log sequence number 0 12549926
    060215 8:31:54 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060215 8:33:14 InnoDB: Started; log sequence number 0 12549926
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060227 5:14:03 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060227 5:14:06 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: 'admin'

    060227 5:14:06 InnoDB: Starting shutdown...
    060227 5:14:07 InnoDB: Shutdown completed; log sequence number 0 13457982
    060227 5:14:07 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060227 5:16:09 InnoDB: Started; log sequence number 0 13457982
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
    060301 11:24:00 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060301 11:24:01 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 3 user: 'admin'

    060301 11:24:01 InnoDB: Starting shutdown...
    060301 11:24:03 InnoDB: Shutdown completed; log sequence number 0 13541242
    060301 11:24:03 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060301 11:25:41 InnoDB: Started; log sequence number 0 13541242
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: '4.1.12-nt' socket: '' port: 8306 Official MySQL binary
     
Loading...