% mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (2)
- Cant connect to local MySQL server through socket :tmp:mysql.sock (2).jpg)
If you have installed MySQL server using homebrew package manager and when you try to start it and you get ERROR 2002 then you need to start the service using the brew services start command.
The brew services is used to manage background services using the daemon manager launchctl on macOS.
Fix:
% brew services start mysql
Once complete, you can connect to MySQL via the terminal.
% mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.33 Homebrew
mysql>
-
Facing issues? Have Questions? Post them here! I am happy to answer!
More Posts related to MySQL,
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- MySQL: Error Code: 1175 You are using safe update mode
- MySQL Query for Schema/Structure of a Table
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- Connection Failed: 1130 PHP MySQL Error
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- How to find AUTO_INCREMENT Fields value in MySQL table
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- How to clear MySQL Console Screen
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- Fix MySQL ERROR 1045 (28000): Access denied for user root@localhost (using password: YES)
- Display List of Databases in mysql Command Line
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- Fix MySQL - Error: (OperationalError) (HY000) [08S01] Communications link failure
- MySQL: How to Select Database via Terminal/Command Line
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- How to query database table names [MySQL/Oracle/SQL Server]
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- Identify MySQL version in MySQL Command Line Prompt
More Posts:
- Android EditText Cursor Colour appears to be white - Android
- Fix: rust-analyzer failed to discover workspace [Visual Studio Code] - Rust
- How to mute all sounds in Notepad++ - NotepadPlusPlus
- How to make Text in TextView bold and italic in Android - Android
- Fixing Android unknown error 961 while downloading app - Android
- F2 Key Cell Editing Alternative for Excel for Mac - Windows
- Setting up Spring Boot 3 + Maven + MySQL + JDBC Example - Java
- NewApi error : Finds API accesses to APIs that are not supported in all targeted API versions - Android