![]() ![]() T04:23:43.439507Z 1 is created with an empty password ! Please consider switching off the -initialize-insecure option. See 'systemctl status rvice' and 'journalctl -xe' for details. Table 'mysql.gtid_executed' cannot be opened. sudo service mysql start Job for rvice failed because the control process exited with error code. T04:23:43.437511Z 0 Gtid table is not ready to be used. T04:23:43.430463Z 0 No existing UUID has been found, so we assume that this is the first time that this server has been started. set maxallowedpacket 128M, then restart your MySQL server. T04:23:43.364499Z 0 InnoDB: Creating foreign key constraint system tables. To fix, you can increase the maximal packet size limit maxallowedpacket in my.cnf file, eg. T04:23:42.798963Z 0 Can't create test file C:\ProgramData\MySQL\MySQL Server 5.7\Data\?.lower-test They will be merged with strict mode in a future release. Can't connect to db at /usr/share/perl5/ZoneMinder/Config.pm line 166. T04:23:42.798963Z 0 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. fail DBI connect ('databasezm hostlocalhost','zmuser'.) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Config.pm line 117. Please use -explicit_defaults_for_timestamp server option (see documentation for more details). Depending on what distribution youre running, this might be in /var/log/mysql.log, /var/log/mysql/error.log, or something similarly. T04:23:42.798963Z 0 TIMESTAMP with implicit DEFAULT value is deprecated. Waiting for the server stops: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe -defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" -initialize-insecure=on -console ![]() Running process: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe -defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" -initialize-insecure=on -console I am very new to MySQL, I am already stuck at this installation phase.īeginning configuration step: Stopping Server Įnded configuration step: Stopping Server īeginning configuration step: Writing configuration fileĮnded configuration step: Writing configuration fileīeginning configuration step: Updating firewallĪdding firewall rule for MySQL57 on port 3306.Įnded configuration step: Updating firewallīeginning configuration step: Adjusting Windows service Īttempting to grant Network Service require filesystem permissions.Įnded configuration step: Adjusting Windows service īeginning configuration step: Initializing Database Īttempting to run MySQL Server with -Initialize-insecure ![]() I tried to check the log but I have no idea how to deal with it. In the past few days, I have been reinstall the MySQL for at least ten times but I still got the same problem. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |