i’ve error when i start mysql server telling:
- Checking for corrupt, not cleanly closed and upgrade needing tables.
i’d want to use: mysqlcheck --repair --all-databases
how can i do via ssh? i use mysql -u username -p password -h localhost
but then shell tells: password db doesnt exist?
When MySQL starts on certain Linux distros, it does indeed say:
“Checking for corrupt, not cleanly closed and upgrade needing tables.”
That in itself is not an error or warning, it’s just checking things out.
Are you seeing an error message of some sort though?
If so, can you paste it in?
i’m on ubuntu 8.04, and then i don’t see any errors, everything seems to work.
however to access mysql via shell, how could i do? just to know…
To access MySQL via the shell, you can type:
mysql -u USERNAME -p
And then it’ll prompt you for a password.
That’ll give you the MySQL shell