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!
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 SMBs
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.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.