i have never used mysql before , know little mac terminal. trying establish first connection in mysql workbench mysql community server installed on mac. asking password:
entering password provided in previous popup dialogue box not work. there message @ point needing change temporary password, can no longer figure way access message potential instructions.
clicking on "i" information button in connection box says there no password stored. don't know if means: not saved in key chain, no password associated account, or no password associated user named "root".
i've experimented in ways can think of in dialogue box well: 
it seems commands have executed server running vs not well. have @ least found how turn off/on in system preferences! have read as can comprehend in mysql documentation/tutorials, articles found on internet, videos i've watched. i'm trying use terminal either set, change, or determine if there password, keep hitting roadblocks before getting alter user commands, like:
✘-1 /usr/local/mysql/bin 11:57 $ sudo mysqld_safe --skip-grant-tables sudo: mysqld_safe: command not found ✘-127 /usr/local/mysql/bin 11:58 $ mysql> update mysql.user set password=password('password') user='root'; -bash: syntax error near unexpected token `(' i'm copying characters terminal see in videos , articles, don't know means. i've looked unix commands on line , getting of slowly.
ultimately, wanted experiment mysql , try diagram out , create test database. complete newb, can't seem log in, lol. wish ask more specific question, i'm not sure start. pointers can offer.
ps: x-127 stuff in code think employer asked me install once making using terminal easier. don't quite know does, or if it's interfering.
edit: here's result when trying test connection, , entering supplied password:
Comments
Post a Comment