# 阿里云ECS 命令如下,登录ssh ``` <pre class="calibre16">``` mysql <span class="token">-</span>u root <span class="token">-</span>h localhost <span class="token">-</span>p use mysql update user set host<span class="token">=</span><span class="token4">'%'</span> where user<span class="token">=</span><span class="token4">'root'</span> and host<span class="token">=</span><span class="token4">'localhost'</span><span class="token2">;</span><span class="token6">//所有机器可连接</span> update user set host<span class="token">=</span><span class="token4">'106.39.178.131'</span> where user<span class="token">=</span><span class="token4">'root'</span> and host<span class="token">=</span><span class="token4">'localhost'</span><span class="token2">;</span><span class="token6">//指定ip可连接</span> GRANT ALL PRIVILEGES ON <span class="token">*</span><span class="token2">.</span><span class="token">*</span> TO <span class="token4">'用户'</span>@<span class="token4">'%'</span>IDENTIFIED BY <span class="token4">'密码'</span> WITH GRANT OPTION<span class="token2">;</span> 指定用户可远程连接 flush privileges<span class="token2">;</span> ``` ```