How to modify server uuid in Mysql

Source of the problem:

If the slave server is the cloned master server, then the value of server-uuid must be the same, otherwise the master-slave replication will report error 1593. After modification, restart MySQL

Let me introduce you to the relevant solutions below. Without further ado, let’s take a look at the detailed introduction.

Workaround

1. First, find the installation address of MySQL

show variables like 'datadir';

+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| datadir | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.00 sec)

//Then generate a uuid through mysql for recording and will be used to modify select uuid()

+--------------------------------------+
| uuid() |
+--------------------------------------+
| 2674149f-5083-11e8-be4b-080027a1f331 |
+--------------------------------------+

2. Then enter the datadir directory

cd /var/lib/mysql/
vi auto.cnf
//Modify server-uuid

3. Restart mysql

service mysqld restart

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support for 123WORDPRESS.COM.