Option 3: the command line Tried and true, the command line will always be the most efficient—though not the most friendly way—to accomplish a database export/import.

Whether you're running a LAMP stack on Ubuntu or CentOS, you need to back up your MySQL databases. Learn how to do this with the help of the mysqldump command.

Not only have you configured MySQL 8 for remote connections, you’ve also created a user with access to all databases and connected to the remote server with both the command line and a GUI.

Also, I use MariaDB instead of MySQL in my examples, because that's what I have installed, and because I like the improvements MariaDB includes in both the command-line client and in the database ...

MySQL Connector/Net software installation. Once the ADO driver has been installed, you'll then need to download some PowerShell code that's already been created to do this. You will be using a ...

I tried using the following commands to shutdown and startup MySQL and although it did, it also changed the permissions on the databases and I could no longer work with them in phpmyadmin until i ...

As the world's most popular open source database, MySQL's speed, reliability, and ease of use have made user-generated content and social media available to the masses. In the 18 months since the ...

When running non-interactive MySQL commands one may submit MySQL credentials on the command line (we'll share with you a better option after the break), e.g.: mysql --password=secret --user=username ...