In the terminal input MySQL, the result appears
macdemacbook-pro:~ mac$ alias mysql=/usr/local/mysql/bin/mysqlmacdemacbook-pro:~2002 ( HY000): Can'/tmp/mysql.sock' (2)
Search the Internet for many ways, not good, and then query the official documents
Http://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
The following writes
Here is some reasons the Can‘t connect to local MySQL server
error might occur:
I didn't think the first one would fit, and then I tried typing mysqld.
Results:
macdemacbook-pro:bin mac$ mysqld2018- to-10t07: at: in.997151Z0[Warning] TIMESTAMP withImplicitDEFAULT value isDeprecated. --explicit_defaults_for_timestamp server option (see documentation forMore details).2018- to-10t07: at: in.997492Z0[Note]--secure-file-priv is SetTo NULL. Operations related to importing and exporting data is disabled2018- to-10t07: at: in.997557Z0[Note] Mysqld (mysqld5.7. A) starting asProcess33939 ...2018- to-10t07: at: -.003105Z0[Warning] Setting lower_case_table_names=2Because file system for/usr/local/var/mysql/ is Caseinsensitive2018- to-10t07: at: -.004893Z0[Note] innodb:mutexes and rw_locks use GCC atomic builtins2018- to-10t07: at: -.004919Z0[Note] Innodb:usesEventmutexes2018- to-10t07: at: -.004926Z0[Note] INNODB:GCC Builtin __atomic_thread_fence () isUsed forMemory Barrier2018- to-10t07: at: -.004932Z0[Note] innodb:compressed Tables Use Zlib1.2.32018- to-10t07: at: -.005337Z0[Note] Innodb:number of Pools:12018- to-10t07: at: -.005498Z0[Note] innodb:using CPU CRC32 Instructions2018- to-10t07: at: -.007117Z0[Note] Innodb:initializing buffer pool, total size = 128M, instances =1, Chunk size =128M2018- to-10t07: at: -.018796Z0[Note] innodb:completed initialization of buffer pool2018- to-10t07: at: -.035212Z0[Note] Innodb:highest supported file format isBarracuda.2018- to-10t07: at: -.051578Z0[Note] Innodb:creating shared tablespace forTemporary Tables2018- to-10t07: at: -.051764Z0[Note] innodb:setting file'./IBTMP1'Size to AMB. Physically writing the file full; Please wait ...2018- to-10t07: at: -.065007Z0[Note] Innodb:file'./IBTMP1'Size isNow AMB.2018- to-10t07: at: -.065856Z0[Note] InnoDB: theRedo rollback segment (s) found. theRedo rollback Segment (s) is active.2018- to-10t07: at: -.065868Z0[Note] InnoDB: +non-Redo rollback Segment (s) is active.2018- to-10t07: at: -.066135Z0[Note] Innodb:waiting forpurge to start2018- to-10t07: at: -.121419Z0[Note] InnoDB:5.7. AStarted Log sequence Number25516742018- to-10t07: at: -.121762Z0[Note] Innodb:loading buffer Pool (s) from/usr/local/var/mysql/Ib_buffer_pool2018- to-10t07: at: -.122048Z0[Note] Plugin'Federated' isdisabled.2018- to-10t07: at: -.133391Z0[Note] Innodb:buffer Pool (s) load completed at180510 the: at: -2018- to-10t07: at: -.134352Z0[Note] Found Ca.pem, Server-cert.pem and Server-key.peminchData directory. Trying to enable SSL supportusingthem.2018- to-10t07: at: -.134366Z0[Note] Skipping generation of SSL certificates asCertificate files are presentinchData directory.2018- to-10t07: at: -.135842Z0[Warning] CA Certificate Ca.pem isSelf signed.2018- to-10t07: at: -.135903Z0[Note] Skipping generation of RSA key pair asKey files are presentinchData directory.2018- to-10t07: at: -.142139Z0[Note] Server hostname (bind-address):'127.0.0.1'; Port33062018- to-10t07: at: -.142191Z0[Note]-'127.0.0.1'resolves to'127.0.0.1';2018- to-10t07: at: -.142330Z0[Note] Server socket created on IP:'127.0.0.1'.2018- to-10t07: at: -.195770Z0[Note] Event scheduler:loaded0Events2018- to-10t07: at: -.195949Z0[Note] Mysqld:ready forconnections. Version:'5.7.22'Socket'/tmp/mysql.sock'Port3306Homebrew
Waiting for a whole bunch of bugs and stuff, and finally quitting.
Finally, the right approach:
macdemacbook-pro:~mac$ sudo mysqld_safepassword:logging to'/usr/local/var/mysql/macdemacbook-pro.local.err'.2018- to-10t07: -: A.6NZ Mysqld_safe starting mysqld daemon with databases from/usr/local/var/MySQL2018- to-10t07: -: A.6NZ Mysqld_safe Mysqld fromPID file/usr/local/var/mysql/macdemacbook-Pro.local.pid Endedmacdemacbook-pro:~mac$ Mysqlerror1045(28000): Access denied forUser'mac'@'localhost'(usingPassword:no)
Then the MYSQLD service is running.
At this point, you can finally open MySQL
Mac-can ' t connect to local MySQL server through socket '/tmp/mysql.sock ' (2)