![]() I wanted to eliminate that, so I went through the whole process, uninstalling and the installing from DMG and initializing MySQL again. It reminded me of the possibility that I perhaps I did not do enough to have removed the MySQL pane from System Preferences, and what I was seeing was a ghost from my first installation. After that I continued with starting up the server normally,Īfter you initialize the data directory by starting the server with ->initialize or -initialize-insecure, start the server normally (that is, >without either of those options) and assign the account >a new password:Ī sequence of steps I shall not quote hereĪnd finished up the rest of the instructions in the docs, and then shutting down the server.īut I realized then the dedicated MySQL pane in the System Preferences of my Mac, which shows whether or not MySQL server is running or not, still showed that MySQL Server Instance was still running. So that was what I did and I could proceed with the initialization. In this case, remove or rename the data directory and try again.Īs of MySQL 5.7.11, an existing data directory is permitted to be nonempty >if every entry either has a name that begins with a period (.) or is named >using an -ignore-db-dir option. initialize specified but the data directory exists. If a data directory exists and is not empty (that is, it contains files or >subdirectories), the server exits after producing an error message: Aborting.Īnd then I another part of the documentation entitled Initializing the Data Directory Manually Using mysql, that accounted for this error and actually said: T17:28:21.162124Z 0 -initialize specified but the data directory has files in it. Please use -explicit_defaults_for_timestamp server option (see documentation for more details). The errors popped up T17:28:21.145457Z 0 TIMESTAMP with implicit DEFAULT value is deprecated. As I was at the step running the command shell> bin/mysqld -initialize -user=mysql I found the process of initialization to be quite tricky and confusing. My goal for doing so was so that I could follow the initialization instructions as stated in the documentation before I started using the database, unlike in the first time round, where I started using it before I had initialized. ![]() I got really puzzled, and just decided to uninstall MySQL following the instructions here and go through the whole installation process again. Then next I came across this page in the documentation that explained the process of initializing the data directory. I even tried doing some basic hello-world type of activities on the database to get a feel of it. First I have installed MySQL using the DMG file and everything looks like it worked fine. I need some help here to understand installing and initializing MySQL on my local Macbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |