Entries by

How to change mysql table engine MyISAM to InnoDB



login to mysql shell as root.locate the database where the tables are situated. SET @DATABASE_NAME = ‘name_of_your_db’; // name_of_your_db = the database you want to change table engine.SELECT CONCAT(‘ALTER TABLE ‘, table_name, ‘ ENGINE=InnoDB;’) AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = @DATABASE_NAME AND ENGINE = ‘MyISAM’ AND TABLE_TYPE = ‘BASE TABLE’ ORDER BY […]

[ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist



This error ocurs then the database mysql is missing or corrupt.Stop the mysql server “service mysql-server stop”Make a backup of /var/db/mysql “mv /var/db/mysql /var/db/mysql.old”.To rebuild the database execute “/usr/local/libexec/mysqld –initialize”You will get a temporary password. Remember the password for later use.Start the mysql server “service mysql-server start”To start upp the new configuration “mysql_secure_installation”. Use the […]

Config Cisco Nexus L3 vlan routing IPv6



Config Cisco Nexus L3 vlan routing IPv6 This is a simple how to make a nexus switch L3 routeing and the connected access switches still on L2 switching. If you have a router connected between internet and the router switch. Make shure you have a static route configured to the two vlan network. Router Switch […]

Config Cisco Nexus L3 vlan routing IPv4



This is a simple how to make a nexus switch L3 routeing and the connected access switches still on L2 switching. If you have a router connected between internet and the router switch. Make shure you have a static route configured to the two vlan network. Router Switch no system default interface-vlan autostate (brings up […]

MySQL 5.7 and mysql_secure_installation



If you are using mysql:secure_installation witch you should, beware of that the script reset all passwords in the SQL server database mysql. To fix this problem use the following.Root password:ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘MyNewPass’;Session password:ALTER USER ‘mysql.session’@’localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; Exampel error messages:ERROR 1820 (HY000): You must reset your password using […]