Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Users Search
Help Dashboard Sign In Sign Up
Q&A Meta
Q&A
Posts Tags Edits
Ask Question

Comments on Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Parent

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

+1
−0

I have installed mysql-server on Ubuntu 20.04 then I tried to sign into mysql-server using sudo mysql -u root but I have got

Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I don't know what does that mean. I am using Windows Subsystem for Linux (WSL) Ubuntu 20.04.

ubuntu mysql-server
posted about 5 years ago
5y ago by deleted user
user card
Kevin M. Mansour‭
24 reputation 2 3 3 3
History

0 comment threads

Post
+0
−0

Simply, mysql-server isn't running, you will have to run it first using:

sudo service mysql start

then try to sign into mysql-server using:

sudo mysql

then you are good to go.

posted about 5 years ago
5y ago
user card
Kevin M. Mansour‭
24 reputation 2 3 3 3
History

1 comment thread

`mysql` shouldn't need to be run as root (3 comments)
`mysql` shouldn't need to be run as root
Canina‭ wrote about 5 years ago
copy link

The MySQL root user has nothing to do with the system root user; the two user namespaces are separate. Also, best practice is to avoid running processes, especially complicated programs, as uid root if possible. Is there any particular reason why you suggest using sudo when invoking mysql?

Kevin M. Mansour‭ wrote about 5 years ago
copy link

Thank you for notice. When I try MySQL without sudo it produce ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: NO)

Canina‭ wrote about 5 years ago
copy link

Kevin M. Mansour‭ Try with -p also.