![]() ![]() Mysql> CREATE USER IDENTIFIED BY 'anotherpass' ĮRROR 1045 (28000): Access denied for user (using password. Mysql> SHOW VARIABLES LIKE 'skip_networking' Įxact same setup, except I re-activated networking, and I now create an anonymous user. mysql -ubill -ppass -socket=/tmp/mysql-5.5.sock These are only meant to answer some questions raised in other comments within this thread.Īuthenticating as through a. The recommended solution is to drop this anonymous user (this is usually a good thing to do anyways).īelow edits are mostly irrelevant to the main question. Hence, such an anonymous user would "mask" any other user like when connecting from does match but would match (e.g.) beforehands. Literal host names and IP addresses are the most specific. The server uses sorting rules that order rows with the most-specific Host values first. The server uses the first row that matches the client host name and user name.When a client attempts to connect, the server looks through the rows in sorted order.When multiple matches are possible, the server must determine which of You probably have an anonymous user or per the manual: Note the second: a commenter says step 2 is not required. ![]() Note: the -force bit on brew cleanup will also cleanup outdated kegs, think it's a new-ish homebrew feature. Launchctl load -w ~/Library/LaunchAgents/ Used the alternate security script: /usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installationįollowed the launchctl section from the brew package script output such as, #start Start mysql with rver start command, to be able to log on it Mysql_install_db -verbose -user=`whoami` -basedir="$(brew -prefix mysql)" -datadir=/usr/local/var/mysql -tmpdir=/tmp Ran the commands brew suggested: (see note: below) unset TMPDIR installed mysql with brew install mysql.Launchctl unload -w ~/Library/LaunchAgents/ Note also your alternate security script directory will be based on which version of MySQL you are installing. Used brew's remove & cleanup commands, unloaded the launchctl script, then deleted the mysql directory in /usr/local/var, deleted my existing /etc/my.cnf (leave that one up to you, should it apply) and launchctl plist I had the same problem and none of the above solutions worked for me. I think one can end up in this position with older versions of mysql already installed. ![]() I hope that works/make sense because this works for me.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |