Create a user in MySQL with full rights:Continue reading CREATE A USER IN MYSQL
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.Continue reading Mysql Workbench error #1064
You should not use phpmyadmin to export big tables from mysql. You may get partial exports because of php server timeouts.
Best way is to connect via SSH to the server and use mysqldump to export the dataset. Then you can download it and transfer it to the new server. There you could use the mysql command to import the dataset.
If you have installed MySQL and you cannot connect to it after installation, you may try the following:Continue reading Cannot connect to mysql after installation
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: