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 »
Q&A

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.

History
Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

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.

History
Why does this post require moderator attention?
You might want to add some details to your flag.

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 almost 3 years ago

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 almost 3 years ago

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 almost 3 years ago

Kevin M. Mansour‭ Try with -p also.