This is an incompatibility (assuming the database model is correct) between MySQL workbench and MySQL Server. For example, this could occur occasionally by installing XAMPP 3.2.2 and latest MySQL Workbench 8.
For example: XAMPP 3.2.2 installs Maria DB 10.1.37 which is compatible with MySQL 5.7 but MySql workbench 8 is compatible with MySQL 8.0.
The solution would be to either upgrade MySQL to 8.0 so that it is compatible with MySQL workbench or downgrade the MySQL workbench model:
- Open MySQL workbench and desired model
- Go to Edit, Preferences, then Modeling section, MySQL
- set MySQL version to 5.7.
- forward engineer
There are now two better solutions:
1. Disable dynamic tick
- Open Command prompt (Admin) to bring up elevated command prompt.
- Type BCDEDIT /SET DISABLEDYNAMICTICK YES command and press Enter to fix the high DPC latency
- restart the computer
2. Install and use TCP optimizer:
- Download TCP optimizer
- Set settings to optimal
- restart the computer
If the above does not work, you can try the older solutions mentioned below.
Continue reading Audio staggering in Windows 10
You have a Linux distribution with Xorg and you have configured the keyboard layout switcher to use alt+shift to switch between languages. But once you do that, keyboard shortcuts that use alt+shift+<key> combinations cannot be used. The same could happen if you have selected ctrl+shift as a shortcut to change language which disables all ctrl+shift+<key> combinations.
Continue reading Unable to use ctrl+shift+? shortcuts with keyboard layout switcher
- Linux store the time on the hardware clock as UTC by default
- Windows store the time on the hardware clock as the local time by default
Since both operating systems access the hardware clock you may encounter problems when you dual boot between them.
A comment for the geeks:
The advantage of having the hardware clock as UTC is that you don’t need to change the hardware clock when moving between timezones or when Daylight Savings Time (DST) begins or ends as UTC does not have DST or timezone offsets. Continue reading Clock messed up when dual booting
If you have installed MySQL and you cannot connect to it after installation, you may try the following:
sudo mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
Replace the password with the one you want.
After installation, Krusader reports unsupported protocol for fish, smb etc.
You need to install kio-extras:
sudo apt-get install kio-extras
Display a list of running processes:
show full processlist;
Then kill any process you want with kill command:
if, while you are trying to load data, you receive the following error:
Error Code: 1148. The used command is not allowed with this MySQL version
you should perform the following steps:
Continue reading MySQL Load Data error 1148