![]() On activation if no /opt/local/etc/mysql8/my.cnf file exists one will be created which loads /opt/local/etc/mysql8/macports-default.cnf.Īny changes made to /opt/local/etc/mysql8/macports-default.cnf will be lost during port upgrades, deactivations or activations. opt/local/etc/mysql8/my.cnf is a good place to customize your mysql8 installation. Sudo /opt/local/lib/mysql8/bin/mysql_upgrade -u root -p Man mysql_upgrade - details on the upgrade program (man page) If the database exists from a previous installation, you may need to upgrade. See also Step 6: Database upgrade as necessary $ /opt/local/bin/mysql_secure_installation There is an interactive program to secure a MySQL installation. If desired, reboot your machine and then run:Īgain to verify that the daemon is again running. Once you are logged in, simply exit the session like this: It means you have entered the wrong password. ![]() Test everything by logging in to the server.ĮRROR 1045 (28000): Access denied for user (using password: YES) ![]() Then `is your new desired root password, followed by Return. You will first be prompted for your existing password ( Enter password:) enter the root password (auto generated or no entry depending on your MySQL version) then press Return.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |