Troubleshoot MySQL

The errors could be related to a full MySQL disk:

1. Ensure that you've followed the system requirements and that the MySQL server hardware is at least as described (specifically, enough RAM, CPU, and storage).
2. For the MySQL server, ensure that:
   1. You installed MySQL using the installer provided by Google 
   2. There is no other MySQL instance on the server
   3. There is no antivirus or antimalware software installed
   4. If you installed a firewall, you allowed ingress traffic on port 3306 

For more information about freeing up space in a full disk, go to Troubleshoot full MySQL disk.

The errors could indicate a network issue:

1. Make sure that:
   • The MySQL server meets the system requirements.

     For details, go to Hardware requirements.

   • You installed the MySQL software using the installer provided by Google.

     For details, go to Download the installers.

   • You completed all the steps in Configure database settings.
   • All servers in the Google Workspace Migrate cluster are on the same network with no firewalls or filters between them.
   • No other software is installed on the Windows Server used by MySQL.
   • You haven't modified the default Windows Firewall settings.
2. Connect remotely to the server that can't reach the MySQL server, and open a PowerShell window as administrator.
3. To install the Telnet Client, enter the following command:

   Install-WindowsFeature -name Telnet-Client

4. Reboot the MySQL server and the server that can't connect and try again. If you still have issues, continue to step 6.
5. To run a telnet test, enter the following command:

   telnet MySQL-server-ip-address 3306

6. Assess the result of your telnet test. If you:
   • Don’t get an error or if, after a few seconds, you get a Connection to host lost message, there's probably no network issue. Try reproducing the error again by opening the Google Workspace Migrate platform and repeating the action that previously failed.
   • Can connect using telnet but you can’t connect using Google Workspace Migrate (from the same node or the platform), a local firewall might be blocking outgoing connections. Check the firewall settings on the local server.
   • Get an error, such as Could not open connection to the host, on port 3306: Connect failed, follow the steps in the next table to troubleshoot.

You might see a blank screen when you sign in to the platform and this error in the service host logs:

[MySqlException; HRESULT -2147467259] : Your password has expired. To log in you must change it using a client that supports expired passwords.

This error occurs because MySQL passwords expire by default after approximately a year. To fix the issue: 

1. If you don't have the MySQL root password, complete Reset MySQL root password (on this page) first.
2. Sign in to the MySQL machine and open a command prompt.
3. To connect to MySQL, enter the following command:

   C:\MySQL\bin\mysql.exe -h 127.0.0.1 -u root -pRootPassword

   Substitute the MySQL root password in place of RootPassword. There is no space between -p and the password.

4. To set the password to never expire, enter the following command:

   ALTER USER USER() IDENTIFIED BY 'RootPassword';
   ALTER USER 'root'@'127.0.0.1' PASSWORD EXPIRE NEVER;
   ALTER USER 'migrate'@'%' PASSWORD EXPIRE NEVER;
   FLUSH PRIVILEGES;

5. On the platform server, restart the Google Workspace Migrate service and connect normally.

Google Workspace Migrate uses the migrate password to communicate with MySQL. Follow the steps below if you need to reset this password.

Step 1: Reset password

1. If you don’t have the MySQL root password, complete Reset MySQL root password (later on this page) first.
2. Sign in to the MySQL machine, and open a command prompt.
3. To connect to MySQL, enter the following command:

   C:\MySQL\bin\mysql.exe -h 127.0.0.1 -u root -pRootPassword

   Substitute the MySQL root password in place of RootPassword. There is no space between -p and the password.

4. To update the password for the migrate user, enter the following command:

   ALTER USER 'migrate'@'%' IDENTIFIED BY 'NewUserPassword'; FLUSH PRIVILEGES;

   Substitute the new migrate user password in place of NewUserPassword.

Step 2: Update the platform

Choose an option:

I can access the Google Workspace Migrate platform:

1. In the Google Workspace Migrate platform, at the top, click Settings Database settings.
2. Enter the new password for MySQL and the Apache CouchDB software.

   Both passwords are required. If you don’t have the CouchDB password, go to I can’t access the Google Workspace Migrate platform (below).

3. Click Continue.

I can’t access the Google Workspace Migrate platform:

1. Sign in to the machine that's running the platform. 
2. On the taskbar, right-click Google Workspace Migrate and select Edit host settings.
3. For MySQL settings, click Password and enter the new password.
4. Click Save & CloseOK.
5. On the taskbar, right-click Google Workspace Migrate and select Stop Google Workspace Migrate service. Then, restart the service. 

Step 3: Reassociate the nodes

You need to complete this step to propagate the new database settings to the nodes.

1. In the Google Workspace Migrate platform, at the top, click Servers.
2. Select all the nodes and click Delete .
3. Add the nodes either using a CSV file or enter them manually.

   For details, go to Add the node servers.

In the steps below, substitute your new MySQL root password in place of NewRootPassword.

1. Sign in to the MySQL machine.
2. Open an elevated command prompt, and go to C:\MySQL\bin.
3. To stop the MySQL service, enter the following command:

   for /f %a in ('net start ^| find /I "mysql"') do @net stop %a

4. To prepare the command file that sets the new password, enter the following command:

   echo|set /p="ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY 'NewRootPassword';" > password-reset-init.txt

5. Record the new password in a secure location.
6. To reset the password, enter the following command:

   mysqld --defaults-file="C:\MySQL\my.ini" --init-file="C:\MySQL\bin\password-reset-init.txt" --console

7. When logging stops, press Ctrl+Pause or Ctrl+Break to end the command.
8. To delete the command file, enter the following command:

   del password-reset-init.txt

9. To start MySQL again, enter the following command:

   for /f %a in ('net start ^| find /I "mysql"') do @net start %a

10. Sign in to the database using the root user and, to test the new password, enter the following command:

    C:\MySQL\bin\mysql.exe -h 127.0.0.1 -u root -p

11. Enter the new password.

    If the new password is unsuccessful, repeat the steps to reset the password.