Softaculous

Topic : SSH Mysql Repair Commands

Posted By: batursoylu on November 22, 2015, 12:45 pm

Hi all,

What ssh mysql repair command?

mysqlcheck --repair -A

mysqlcheck --optimize -A

mysqlcheck -A -h localhost -u root -r -p

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

??????

SSH answer: command not found

Thank you for reply.

Posted By: abhijeetm on November 23, 2015, 1:17 pm | Post: 1

Hi,
Once you install MySQL through Webuzo, all binaries for it can be found under /usr/local/apps/mysql/bin/

So you can try with: /usr/local/apps/mysql/bin/mysqlcheck

Posted By: batursoylu on December 12, 2015, 3:11 am | Post: 2

/usr/local/apps/mysql/bin/mysqlcheck

How command?

Thank you for answer.

Posted By: nikhil89 on December 14, 2015, 2:26 pm | Post: 3

Hi,

You can try using the following command:

/usr/local/apps/mysql/bin/mysqlcheck --repair -A

/usr/local/apps/mysql/bin/mysqlcheck --optimize -A

/usr/local/apps/mysql/bin/mysqlcheck -A -h localhost -u root -r -p

/usr/local/apps/mysql/bin/mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

Hope this helps.

Please let us know if you still face the issue. We will be happy to help you.

Posted By: batursoylu on December 14, 2015, 4:23 pm | Post: 4

Hi,

Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO)

when trying to connect

What problem?

Thank you.

Posted By: abhijeetm on December 17, 2015, 12:39 pm | Post: 5

Hi,
Can you check the root user password you enter is correct.

If you are not able to login to mysql with root credentials, you can run server in with --skip-grant-tables as:
/usr/local/apps/mysql/bin/mysqld --skip-grant-tables

and then try to use your required commands without any password.

Once the issue resolved, you can stop mysql servers by entering command:
killall mysqld

and restart MySQL again in normal mode by running:
service mysqld restart

Note: If you change your mysql root password, you will also have to update it in /var/webuzo/my.conf.