Grant all privileges on your_database_name.* to privileges Ħ. Now let’s create the database user(s) and import database(s). Type n for password validation, and enter your password for root. Now remove any mysql sudo apt purge mysql-* Ii mysql-common 1:10.8.2+maria~focal all MariaDB database common files (e.g. Ii mysql-client-core-8.0 8.0.28-0ubuntu0.20.04.3 amd64 MySQL database core client binaries Ii mysql-client-8.0 8.0.28-0ubuntu0.20.04.3 amd64 MySQL database client binaries Ii mysql-client 8.0.28-0ubuntu0.20.04.3 all MySQL database client (metapackage depending on the latest version) Ii libmysqlclient21:amd64 8.0.28-0ubuntu0.20.04.3 amd64 MySQL database client library Ii libdbd-mysql-perl:amd64 4.050-3 amd64 Perl5 database interface to the MariaDB/MySQL database

Ii automysqlbackup 2.6+debian.4-2 all daily, weekly and monthly backup for your MySQL database Ii mariadb-server-core-10.8 1:10.8.2+maria~focal amd64 MariaDB database core server files Ii mariadb-server-10.8 1:10.8.2+maria~focal amd64 MariaDB database server binaries

Ii mariadb-server 1:10.8.2+maria~focal all MariaDB database server (metapackage depending on the latest version) Ii mariadb-common 1:10.8.2+maria~focal all MariaDB common configuration files Ii mariadb-client-core-10.8 1:10.8.2+maria~focal amd64 MariaDB database core client binaries Ii mariadb-client-10.8 1:10.8.2+maria~focal amd64 MariaDB database client binaries Ii mariadb-client 1:10.8.2+maria~focal all MariaDB database client (metapackage depending on the latest version) Ii libmariadb3:amd64 1:10.8.2+maria~focal amd64 MariaDB database client library Scp address:/home/user/Databases/* /home/user/Databases/ ġ730046 -rw-rw-r- 1 user user 1001188 Apr 14 14:43 your_database_name.sqlĬopy the file(s) to the local machine for safe keeping. Mysqldump -opt -Q -u your_database_user_id -p your_database_name > ~/Databases/your_database_name.sqlġ730043 drwxrwxr-x 2 user user 4096 Apr 14 14:44. Confirm the database name, user ID, and password from. Check for host IP address or localhost as this is important when dealing with the database, 2. But first a couple of gotchas to be mindful of: 1. | your_database_user_id | IP address | * | Note that I have removed some lines in the output. Open an ssh session and use the following commands to list your database and database user. This is straightforward with Linode: from the Linode screen, click on the ellipsis, and select ‘Clone’.

To avoid downtime while making the changes, I recommend cloning the server. However, the guide should work equally well on other platforms. I use an Ubuntu 20.04 LTS server hosted on Linode. Ghost 5+ requires MySQL 8, as it’s a breaking change, so upgrade now if you’re running MariaDB.

Install mysql mac 10.11