![]() Restart MySQL and run following commands to further secure the database $ rver restart $ mysql_install_db -verbose -user=$(whoami) -basedir="$(brew -prefix mysql)" -datadir=/usr/local/var/mysql -tmpdir=/tmp $ mysqld -initialize -verbose -user=$(whoami) -basedir="$(brew -prefix mysql)" -datadir=/usr/local/var/mysql -tmpdir=/tmpįYI - One of the older variant of the command is $ echo mysql_install_db -verbose -user=$(whoami) -basedir="$(brew -prefix mysql)" -datadir=/usr/local/var/mysql -tmpdir=/tmp $ echo mysqld -initialize -verbose -user=$(whoami) -basedir="$(brew -prefix mysql)" -datadir=/usr/local/var/mysql -tmpdir=/tmp Validate the output in "echo" command before executing the actual command. Unset the temporary directory $ echo $TMPDIRĪfter you have run the command below, make sure that the folders in the command and whoami resolves into the right name $ whoamiĮxecute command mentioned below. Log-builtin-as-identified-by-password FALSE Log-error=/usr/local/var/mysql/įor information on various log files, you can use the MySQL demon command like following $ /usr/local/Cellar/mysql/5.7.18_1/bin/mysqld -verbose -help | grep '^log' Plugin-dir=/usr/local/Cellar/mysql/5.7.18_1/lib/plugin Information like following can be obtained demon location - /usr/local/Cellar/mysql/5.7.18_1/bin/mysqld Run command below to find out where the key MySQL directories are $ ps auxww|grep ysqld ![]() Execute the command below and select Y|y to all. You will need it soon in the following steps. Select good password and select Y for all the options. In my case the cnf was found at /usr/local/etc/my.cnf usr/local/Cellar/mysql/5.7.18/my.cnf -> Sever Level Access Three potential areas will be /usr/local/etc/my.cnf -> Global Access Terminal 2: use command $ rver restartįind the potential location where my.cnf needs to be added. Terminal 1: use following command $ rver stop We\'ve installed your MySQL database without a root password. We will secure the installation later as we go through the process. You will see message like following that indicates that the installation is not secure. Run following command on Terminal to update Homebrew and install MySQL $ brew update See Uninstalling MySQL on MacOS Install base MySQL using Homebrew If you have previous MySQL installation on your Mac, please uninstall it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |