This is beacuse mysql server 5.7 have changed the the date time default field 0000-00-00 00:00:00 options. You can only have one field with the value 0000-00-00 00:00:00. Where fore you have to change the default indata mask to. datetime NOT NULL DEFAULT ‘1000-01-01 00:00:00’ortimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP exampel ALTER TABLE testdate CHANGE datestart […]
Author Archive for: erik
About Erik Svensson
This author has yet to write their bio.
Meanwhile lets just say that we are proud Erik Svensson contributed a whooping 6 entries.
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 […]
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 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 […]
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 […]
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 […]