Migrating a MySQL Server to Alibaba Cloud

Prerequisites

Deciding How to Host

Creating the Cloud Server

Connecting to the Server

  1. Log into the server as shown above and use the “vim” editor (not described here) to edit /etc/my.cnf file. In the [mysqld] section of the file, add the line skip-grant-tables.
  2. Restart the server instance
  3. Log into the server and type the command mysql –u root –p
  4. Enter the root password when prompted. You should now be at a MySQL command prompt
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xyz';

Migrating Data

Summary

Original Source:

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com