![]() Be sure to pay attention to binThe path to the file. If it fails, the main reason is that the path is wrong. The blogger did not configure the environment variables and there was no problem in the follow-up. Open the command line and open it as an administrator: Switch to the unzipped root directory binPath, for example, my root path is: D:\Program Files\mysql-5.7.37-win圆4Īdd after binpath: D:\Program Files\mysql-5.7.37-win圆4\binĮnter on the target path command line: mysqld -install(Install) If it fails, check whether the path is correct, or try to configure the environment variables of the computer (generally, no configuration is required). # The default storage engine that will be used when creating new tables # The character set used by the server defaults to the 8-bit encoded latin1 character set # Set the data storage directory of the mysql databaseĭatadir=D:\Program Files\mysql-5.7.37-win圆4\data # Set the installation directory of mysqlīasedir=D:\Program Files\mysql-5.7.37-win圆4 # Set the default character set of the mysql client basedirand datadirIt needs to be based on the path where the file is decompressed, the latter needs to be added to the former path \data。 Copy the following code to your path after changing the path my.iniconfiguration file. MySQL installationįind the downloaded compressed package and unzip it directly to the path you want to install. If you log in at the beginning, it will be downloaded directly. After registration, the interface will look like this. If you don’t have an account, you can register with an email address. It depends on how many bits your computer has, download 32-bit for 32, download 64-bit for 64, and download the first or second one according to your needs. We chose to download the historical version and found version 5.7. The latest version is version 8, and version 5 is recommended for beginners. MySQL is free and open source, and you can download it directly from the official website. 18 after 10 attempts.No matter what software you want to install, the first thing you do is download the software. Retry 10: Attempting to connect to 3306 with user root with no password.įailed to connect to MySQL Server 8. Retry 9: Attempting to connect to 3309 with user root with no password. Retry 8: Attempting to connect to 3306 with user root with no password. Retry 7: Attempting to connect to 3309 with user root with no password. Retry 6: Attempting to connect to 3306 with user root with no password. ![]() Retry 5: Attempting to connect to 3309 with user root with no password. Retry 4: Attempting to connect to 3306 with user root with no password. Retry 3: Attempting to connect to 3309 with user root with no password. Retry 2: Attempting to connect to 3306 with user root with no password. Waiting 5 seconds before the next connection attempt. ![]() MySQL error 1042: Unable to connect to any of the specified MySQL hosts. Retry 1: Attempting to connect to 3309 with user root with no password. 18 can be established (with a maximum of 10 attempts). Waiting until a connection to MySQL Server 8. 18 intialized the database successfully.Įnded configuration step: Initializing database (may take a long time)īeginning configuration step: Starting the server Successfully started process for MySQL Server 8. ![]() Process for mysqld, with ID 3420, was run successfully and exited with code 0. They will be merged with strict mode in a future is created with an empty password ! Please consider switching off the -initialize-insecure option. ' NO_ZERO_DATE', ' NO_ZERO_IN_DATE' and ' ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe -defaults-file= " C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" -console -initialize-insecure=on -lower-case-table-names= 1. Beginning configuration step: Initializing database (may take a long time)ĭeleting the data directory from a previous (failed) configuration.Īttempting to run MySQL Server with -initialize-insecure option. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |