Sorry but how to start a mysql service

[zfk513]

I already #issue WSL repleaceService using systemctl
But all failed ,could you help?thx a lot ? ありがとうございます

[yuk7]

Which mysql version are you using?
If you use Mysql 8.0 or later,I think this isssue may be related.

[zfk513]

well just 5.7

[yuk7]

Ok.
Can you excute mysqld command?
You can see a detailed log.

[zfk513]

I think the problem is i still cannot get a service

[yuk7]

Yes,mysqld is mysql daemon executable,it provides mysql server service.
Since an execution user error has occurred, try switching to the mysql user and retry it.

su mysql
mysqld

[zfk513]

the same,i decide try Vmare now ,thx a lot

[zfk513]

Did you make initial settings including mysql_secure_installation?

Nope,i just install and try to start the service as other tutorial suggest,how to change ?

[zfk513]

the VMware ways works ,so far ,thank you for you attention

[yuk7]

hmm... I did same,but it worked.

Env: Windows 10 1903

[zfk513]

how so,i just cann't ????

[yuk7]

Can you read /var/log/journal/mysqld.service.log ?

[zfk513]

yeap

[yuk7]

Ok... It seems crashed mysqld daemon.
Logs are stored elsewhere.
Please read /var/log/mysqld.log

[parveenhooda]

This is happening because /var/run is a volatile directory and somehow it is not able to find/create mysqld.pid file in /var/run/mysqld and hence it is failing. If it still doesn't work look for the logs at /var/logs/mysqld.log.

Also, you would have to do it every time you restart the LxssManager service or reboot the machine.

[mandaputtra]

@parveenhooda, @yuk7 what distro youre using? seems you can get your systemctl works, I can't get systemctl works on Ubuntu 18.04. Thanks

Edit : Sorry stupid me asking without even realize this was a CentOS WSL Repo

[yuk7]

@mandaputtra
systemctl alternative script
Please see: microsoft/WSL#1579 (comment)