MySQL sets remote connection, mysql

MySQL sets remote connection, mysql

The basic idea is to add a record for the mysql. user table: 'hadoop '@' % '. In this way, the user 'hadoop' on any host can remotely connect to the MySQL database. Enter the following command:

 

Mysql> insert into mysql. user (Host, User, Password) VALUES ('%', 'hadoop ', '1 ');

 

The result is incorrect:

1364-Field 'ssl _ cipher 'doesn' t have a default value

This is because the strict mode is specified and users cannot be directly inserted into the mysql. user table:

SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

 

You can only enter the following two commands for implementation:

Mysql> grant all privileges on *. * TO 'hadoop '@' % 'identified by '1' with grant option; mysql> flush privileges;

In this way, the user 'hadoop 'on any host can remotely connect to the MySQL database with the password '1.