简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

如何设置MySQL远程连接_MySQL

WBOY
Release： 2016-06-01 13:51:58
Original
978 people have browsed it

登录到MySQL服务器端，在mysql库下执行grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';即可

如果要设置为任何客户端都可以以root连接的话，可以这么写：
grant all on *.* to 'root'@'%' identifiied by 'root的密码'

Related labels：
mysql how server
source：php.cn
Previous article：InnoDB的索引_MySQL Next article：mysqlhotcopy正则使用小技巧_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
CSS styles not applied to site I'm making a website using Bootstrap5 but the index.css properties are not being applied t...
From 2024-04-06 17:12:23
0
1
336
CSS bottom border on navigation bar I have a navigation bar and I have added a red line at the bottom when any item in the lis...
From 2024-04-06 15:04:41
0
2
347
Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
From 2024-04-06 14:53:12
0
1
425
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
Should we use SSG to deploy dashboards created with Nuxt.js? We will develop a dashboard for internal use using Nuxt.js. Since this will be an internal...
From 2024-04-06 13:17:44
0
1
493
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！