MySQL Grant Practice

I. Preparatory work

Ubuntu1404

Two hosts on the same network segment with MySQL installed

MySQL version

192.168.141.128 Master

MySQL--version

MySQL Ver 14.14 distrib 5.5.46, for Debian-linux-gnu (x86_64) using ReadLine 6.3

192.168.141.129 from

MySQL--version

MySQL Ver 14.14 distrib 5.5.35, for Debian-linux-gnu (x86_64) using ReadLine 6.3

NIC Configuration

Keep the initialization configuration, do not change

Network status

Two hosts need to be interoperable.

Two. Entity operations

Modification of the master server configuration file

sudo vi/etc/mysql/my.cnf

Comment out bind-address = 127.0.0.1 rows (otherwise the primary server cannot be found from the server)

The primary server is licensed from the server user

Grant all on * * to [e-mail protected] identified by ' 123456 ';

Verify the Mysql.user table on the primary server

Mysql> select User,host from user;

+------------------+-----------------+

| user | Host |

+------------------+-----------------+

| Root | 127.0.0.1 |

| Root | 192.168.10.122 |

| test129 | 192.168.141.129 |

| Root | :: 1 |

| Debian-sys-maint | localhost |

| Root | localhost |

| Test | localhost |

| Root | Ubuntu |

+------------------+-----------------+

8 rows in Set (0.00 sec)

Log on to the master server database from the server

mysql-utest129-h192.168.141.128-p123456

Three. Verification

When a data table is created from the server, the primary server verifies that there is

MySQL Grant Practice