By Ali GOREN
Hi i can’t mysql server. I use Ubuntu 14.04 2 gb droplet
I try:
service mysql start
i get error
start job failed to start
i try this command
this command output:
I see: Unknown/unsupported storage engine: InnoDB
But, WordPress used to InnoDB. How to use InnoDB ?
How to solved? :(
Thank you also sorry for my bad english
Update://
I use this command
dmesg | grep mysql
output this command:
Update 2 ://
I try this command:
mysqladmin status
Output:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
hi, for me it’s doesn’t work.
see:
my mysql can’t restart .
i saw my /var/log/mysql/error.log and there is this error:
2017-12-03T09:39:52.142121Z 459 [Warning] IP address ‘168.1.128.53’ has been resolved to the host name ‘35.80.01a8.ip4.static.sl-reverse.com’, which resembles IPv4-address itself.
2017-12-03T10:59:19.141618Z 460 [Warning] IP address ‘27.223.28.120’ could not be resolved: Name or service not known
2017-12-03T10:59:19.305963Z 460 [Note] Access denied for user ‘mysql’@‘27.223.28.120’ (using password: NO)
2017-12-03T10:59:19.797301Z 461 [Note] Access denied for user ‘mysql’@‘27.223.28.120’ (using password: YES)
2017-12-03T10:59:28.499946Z 462 [Note] Access denied for user ‘mysql’@‘27.223.28.120’ (using password: YES)
2017-12-03T10:59:30.009678Z 463 [Note] Access denied for user ‘mysql’@‘27.223.28.120’ (using password: YES)
2017-12-03T10:59:30.503099Z 464 [Note] Access denied for user ‘mysql’@‘27.223.28.120’ (using password: YES)
2017-12-03T17:20:15.641002Z 467 [Warning] Host name ‘207-226-143-218.static.pccwglobal.net’ could not be resolved: Name or service not known
2017-12-03T17:20:16.949527Z 468 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
i don’t know what is the problem !
help me
I had the same issue.
I checked the log with
less /var/log/mysql/error.log
At the bottom of the log I found this
161212 6:30:06 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 278 of name './gseworldfilm/wp_wfHoover.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 278 of name './budget_bumps/wp_wfBadLeechers.ibd' already exists in the tablespace
InnoDB: memory cache!
I moved the “/var/lib/mysql/budget_bumps/wp_wfBadLeechers.ibd” file to “/var/lib/mysql/budget_bumps”
mv /var/lib/mysql/budget_bumps/wp_wfBadLeechers.ibd /var/lib/mysql/
I ran a check and repair to the db
mysqlcheck -c -uroot --all-databases
mysqlcheck -o -uroot --all-databases
mysqlcheck -r -uroot --all-databases
Then I ran the mysql
service mysql start
Everything is running fine noe
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
