SSH Mysql Repair Commands

You are here: Index > Webuzo > General Support > Topic : SSH Mysql Repair Commands

SSH Mysql Repair Commands (5 Replies, Read 21723 times)

batursoylu	# November 22, 2015, 12:45 pm
Group: Member Post Group: Newbie Posts: 46 Status:	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.
IP: --

SSH Mysql Repair Commands

abhijeetm	# November 23, 2015, 1:17 pm \| Post: 1
Group: Virtualizor Team Post Group: Working Newbie Posts: 97 Status:	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
IP: --

SSH Mysql Repair Commands

batursoylu	# December 12, 2015, 3:11 am \| Post: 2
Group: Member Post Group: Newbie Posts: 46 Status:	/usr/local/apps/mysql/bin/mysqlcheck How command? Thank you for answer.
IP: --

SSH Mysql Repair Commands

nikhil89	# December 14, 2015, 2:26 pm \| Post: 3
Group: Softaculous Team Post Group: Elite Member Posts: 467 Status:	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.
IP: --

SSH Mysql Repair Commands

batursoylu	# December 14, 2015, 4:23 pm \| Post: 4
Group: Member Post Group: Newbie Posts: 46 Status:	Hi, Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect What problem? Thank you.
IP: --

SSH Mysql Repair Commands

abhijeetm	# December 17, 2015, 12:39 pm \| Post: 5
Group: Virtualizor Team Post Group: Working Newbie Posts: 97 Status:	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.
IP: --

Jump To :

Users viewing this topic
	1 guests, 0 users.

All times are GMT. The time now is April 20, 2024, 3:47 am.

Queries: 11 | Page Created In:0.020