Also, replace domain names with IP netblocks (instead of *. using 10.20.30.%) You can actually get mysqld to bypass having to use DNS as followsįirst replace all DNS names with hard IP addresses. Personally, I hate using DNS names in er and mysql.db That way, any authentication of user from the domain would be acceptable. GRANT ALL PRIVILEGES ON app1.* TO ALL PRIVILEGES ON app2.* TO ALL PRIVILEGES ON app3.* TO replacing the domain: Perhaps you may want to try masking the domain as follows: WHERE user='user' AND host='lb.' AND db in ('app1','app2','app3') GRANT ALL PRIVILEGES ON app1.* TO ALL PRIVILEGES ON app2.* TO ALL PRIVILEGES ON app3.* TO you want to replace 'lb.' with 'db.' do this: If you want to grant access to the app databases to the same users, do this: Version info: CRMPiccos-MacBook:log crmpicco$ mysql -version => Successfully started `mysql` (label: ) When I start MySQL with homebrew I get no error: CRMPiccos-MacBook:~ crmpicco$ brew services start mysql This is how I initialised MySQL: mysqld -initialize -verbose -user=`whoami` -basedir="$(brew -prefix mysql)" -datadir=/usr/local/var/mysql I had to create a var/log/mysql/error.log as it wasn't created automatically, however now it is logging I get the following error when I do a rver start: T13:36:28.554840Z 0 Can't open the ugin table.
I had a previous (non-functioning) install of MySQL so I followed the steps here to install a clean copy with Homebrew. I am attempting to install MySQL on macOS Sierra 10.12.5.