Two Methods of Mysql Remote Connection Configuration
- 2021-08-31 09:29:54
- OfStack
Two Methods of Mysql Remote Connection Configuration
When you work in a company, you often encounter mysql database stored on someone's computer. If you want to connect to mysql service, the computer equipped with mysql service must open remote connection.
Type 1:
root@ubuntu:/usr/local/MySQL# mysql -hlocalhost -uroot -proot;
mysql>use mysql;
mysql>insert into user (
host,
user,
password,
Select_priv,
Insert_priv,
Update_priv,
Delete_priv,
Create_priv,
Drop_priv,
Reload_priv,
Shutdown_priv,
Process_priv,
File_priv,
Grant_priv,
References_priv,
Index_priv,
Alter_priv,
Show_db_priv,
Super_priv,
Create_tmp_table_priv,
Lock_tables_priv,
Execute_priv,
Repl_slave_priv,
Repl_client_priv,
Create_view_priv,
Show_view_priv,
Create_routine_priv,
Alter_routine_priv,
Create_user_priv,
Event_priv,
Trigger_priv,
Create_tablespace_priv
)VALUES (
'%', // Fixed IP Replace %
'cap',
password('cap'),
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y',
'Y'
);
mysql> FLUSH PRIVILEGES ;
Type 2:
root@ubuntu:/usr/local/mysql# mysql
-hlocalhost -uroot -proot;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'test'@'%'IDENTIFIED BY 'test' WITH GRANT OPTION; // Fixed IP Replace %
mysql> FLUSH PRIVILEGES ;
Thank you for reading, hope to help everyone, thank you for your support to this site!