Home > database >  How to use UDL connect local database
How to use UDL connect local database

Time:11-15



Don't know why, always an error, suggest the server does not exist, I also shut firewall,
thank you

CodePudding user response:

T430 is your computer name?
Here need to fill in the IP address, or the machine, filling localhost with respect to ok,

CodePudding user response:

Whether localhost or 127.0.0.1, all not line, with which the provider?

CodePudding user response:

To start the LOG:

The 2020-06-25 12:33:07 - the Workbench will use CMD shell commands to start/stop this instance

The FROM T430. Err:
The 2020-06-25 T04:33:09 0 Warning TIMESTAMP with implicit DEFAULT value is deprecated. Do use - explicit_defaults_for_timestamp server option (see documentation for more details).
The 2020-06-25 T04:33:09 0 Warning 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO SQL modes should be 2 with strict mode. They will be merged with strict mode in a future release.
The 2020-06-25 T04:33:09 0 Note C: \ Program Files \ MySQL \ MySQL Server 5.7 \ bin \ mysqld exe (mysqld 5.7.10 - log) starting as the process of 14308...
The 2020-06-25 T04:33:09 0 Note InnoDB: Mutexes and rw_locks use Windows interlocked functions provides
The 2020-06-25 T04:33:09 0 Note InnoDB: Uses the event mutexes
The 2020-06-25 T04:33:09 0 Note InnoDB: _mm_lfence () and _mm_sfence () are 2 for the memory barrier
The 2020-06-25 T04:33:09 0 Note InnoDB: Compressed tables use zlib 1.2.3
The 2020-06-25 T04:33:09 0 Note InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
The 2020-06-25 T04:33:09 0 Note InnoDB: Number of pools: 1
The 2020-06-25 T04:33:09 0 Note InnoDB: Not using CPU crc32 instructions
The 2020-06-25 T04:0 spoke to Note the InnoDB: Initializing buffer pool, the total size=8 m, the instances=1, the chunk size=8 m
The 2020-06-25 T04:0 spoke to Note the InnoDB: Completed initialization of buffer pool
The 2020-06-25 T04:0 spoke to Note the InnoDB: Highest supported file format is Barracuda.
The 2020-06-25 T04:0 spoke to Note the InnoDB: Creating Shared in tablespace for temporary tables
The 2020-06-25 T04:0 spoke to Note the InnoDB: Setting the file '\ ibtmp1' size to 12 MB. Physically their file full; Both Please wait...
The 2020-06-25 T04:0 spoke to Note the InnoDB: the File '\ ibtmp1' size is now 12 MB.
The 2020-06-25 T04:0 spoke to Note the InnoDB: 96 redo the rollback segment (s) found. 96 redo the rollback segment (s) are active.
The 2020-06-25 T04:0 spoke to Note the InnoDB: 32 non - redo the rollback segment (s) are active.
The 2020-06-25 T04:0 spoke to Note the InnoDB: Waiting for purge to start
The 2020-06-25 T04:0 spoke to Note the InnoDB: 5.7.10 started; The log sequence number 10861286
The 2020-06-25 T04:0 spoke to Note the InnoDB: Loading buffer pool (s) from C: \ ProgramData \ MySQL \ MySQL Server 5.7 \ Data \ ib_buffer_pool
The 2020-06-25 T04:0 spoke to Note the InnoDB: not started
The 2020-06-25 T04:0 spoke to Note the Plugin 'FEDERATED is disabled.
The 2020-06-25 T04:0 spoke to Warning Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
The 2020-06-25 T04:0 spoke to Note the Server hostname (bind - address) : '*'; Port: 3306
The 2020-06-25 T04:0 Note spoke to IPv6 is available.
The 2020-06-25 T04:0 Note - spoke to ': :' resolves to '... ';
The 2020-06-25 T04:0 spoke to Note the Server socket created on IP: ':'.
The 2020-06-25 T04:0 spoke to Note the InnoDB: Buffer pool (s) the load completed at 200625 12:33:10
0 2020-06-25 T04: wherefore Note Event Scheduler: the Loaded 0 events
0 2020-06-25 T04: wherefore Note C: \ Program Files \ MySQL \ MySQL Server 5.7 \ bin \ mysqld exe: ready for connections.
Version: '5.7.10 - log' socket: "' the port: 3306 MySQL Community Server (GPL)
The 2020-06-25 12:33:11 - Starting server...
The 2020-06-25 12:33:11 - Server start done.
The 2020-06-25 12:33:11 - Checking server status...
The 2020-06-25 12:33:11 - Trying to connect to the MySQL...
The 2020-06-25 12:33:11 - Connection succeeded
The 2020-06-25 12:33:11 - Assuming the server is running
The 2020-06-25 12:33:11 - Checking server status...
The 2020-06-25 12:33:11 - Trying to connect to the MySQL...
The 2020-06-25 12:33:11 - Connection succeeded
The 2020-06-25 12:33:11 - Assuming the server is running
  • Related