Tag Archives: MySQL

Import and export SQL tables

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.

Continue reading Import and export SQL tables

Advertisements

Cannot connect to mysql after installation

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.

 

References:

https://askubuntu.com/questions/766334/cant-login-as-mysql-user-root-from-normal-user-account-in-ubuntu-16-04