Posts

Showing posts from October, 2015

Upgrade Moddle Database From 2.5 to Innodb and convert to innodb Baracuda

you can try this on a test environment first. mysql> select version();         +------------+         | version()  |         +------------+         | 5.5.24-cll |         +------------+         1 row in set (0.00 sec) mysql> show variables like "%innodb_file%";  +--------------------------+----------+    Variable_name            | Value    |  +--------------------------+----------+  | innodb_file_format       | Antelope |  | innodb_file_format_check | ON       |  | innodb_file_format_max   | Antelope |  | innodb_file_per_table    | ON       |  +--------------------------+----------+  4 rows in set (0.00 sec) mysql> SET GLOBAL innodb_file_format = barracuda;      Query OK, 0 rows affected (0.00 sec) mysql> show variables like "%innodb_file%";    +--------------------------+-----------+    | Variable_name            | Value     |    +--------------------------+-----------+    | innodb_file_format       | Barracuda |    | inno

To enable root login for SSH

To enable root login for SSH first enable root account by giving password to root sudo passwd Now, you need to edit /etc/ssh/sshd_config gksudo gedit /etc/ssh/sshd_config Remove the (#) comment from this line: PermitRootLogin without-password directly under it add this:      change without-password to yes PermitRootLogin yes Now restart SSH: sudo service ssh restart