You can copy example file from /usr/local/mysql/support-files/ You can achieve same result if will create my.cnf file straight in /etc/ sudo nano /etc/my.cnf Restart MySQL and check: mysql> show variables like 'secure%' Use Xcode or for example BBEdit, and add line in section ProgramArguments On mac os x startup parameters of mysql You can change by edit. If I add -secure-file-priv=/mysql_exp to Daemons and reboot MySQL does not run at all. In both cases after reboot I was still not allowed to write a file. No errors in logfiles, only in phpmyadmin (where I run the query statement from, logged in as root): same message as before. Then I run SELECT COLUMN_NAME, data_type INTO OUTFILE 'xpeter' FROM tabledefs I rerun the query without OUTFILE 'xpeter', query OK, no messages in log files except apache2 log. I run through whole filesystem, looking for any *.cnf file. usr/local/mysql/bin/mysqld -verbose -help | grep secure-file Variable stays as NULL: $bindir/mysqld_safe -datadir="$datadir" -pid-file="$mysqld_pid_file_path" -secure-file-priv="/tmp" $other_args >/dev/null & I tried to add -secure-file-priv="/tmp", no change. OUTFILE '/tmp/xpeter does not work either. When running this statement: SELECT COLUMN_NAME, data_type FROM tabledefs INTO OUTFILE 'xpeter' I get this message:ġ290 - The MySQL server is running with the -secure-file-priv option so it cannot execute this statement When in doubt, email the TTS Service Desk at or call them directly at 61.I cannot find where to set secure-file-priv. Please exercise caution when clicking links or opening attachments. Triage notifications on the go with GitHub Mobile for iOS or Android " "EmailMessage",Ĭaution: This message originated from outside of the Tufts University organization. You are receiving this email because you commented on the thread. Reply to this email directly, view it on GitHub or unsubscribe. The scripts are executable using the Shortcuts app) I've also included a few scripts to automate some bothersome everyday tasks. If you need help following these instructions on an Apple Silicon Mac, use these modified instructions. To: RealEmmettS Comment Re: commented on this gist. Where are the scripts referred to below?įrom: Emmett Shaughnessy Wednesday, Januat 7:18 PM Homebrew Install brew services first : $ brew tap homebrew/services To install MySQL enter : $ brew install mysql No matter what I attempt I keep getting this errorĮRROR 1045 (28000): Access denied for user (using password: NO)Īt this time of writing, Homebrew has MySQL version 5.7.15 as default formulae in its main repository : Enter the following command : $ brew info mysqlĮxpected output: mysql: stable 5.7.15 (bottled) To manage your databases, I recommend using Sequel Pro, a MySQL management tool designed for macOS.Ĭurrent version available: 1.1.2 Commentsġ The brew services start mysql - instruction is equal to : $ ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents Important : Use the single ‘quotes’ to surround the password and make sure to select a strong password! Database Management Mysqladmin -u root password 'yourpassword' Open Terminal and execute the following command to set the root password: Verify the installed MySQL instance : $ mysql -V.Įxpected output : Ver 14.14 Distrib 5.7.15, for osx10.12 (x86_64) Load and start the MySQL service : $ brew services start mysql.Įxpected output : Successfully started mysql (label: )Ĭheck of the MySQL service has been loaded : $ brew services list 1 Install brew services first : $ brew tap homebrew/services To install MySQL enter : $ brew install mysql Additional configuration Homebrew Expected output: mysql: stable 5.7.15 (bottled).Enter the following command : $ brew info mysql.
0 Comments
Leave a Reply. |