blocks|key|191685|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|191686|尝试telnet+3306。如果未打开连接，则可能是防火墙设置或服务器未在侦听(或未工作)。|ordered-list-item|offset|length|style|CODE|191687|191688|191689|在服务器上运行netstat+-an以查看服务器是否已启动。|191690|191691|191692|您可能不允许远程连接。|191693|191694|请参阅http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html|191695|entityMap|0|LINK|mutability|MUTABLE|url|http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html^0|0|2|B|0|0|0|7|B|0|0|0|0|0|3|2H|0|0^^$0|@$1|2|3|-4|4|5|6|10|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|11|7|@$D|12|E|13|F|G]]|8|@]|9|$]]|$1|H|3|-4|4|5|6|14|7|@]|8|@]|9|$]]|$1|I|3|-4|4|5|6|15|7|@]|8|@]|9|$]]|$1|J|3|K|4|C|6|16|7|@$D|17|E|18|F|G]]|8|@]|9|$]]|$1|L|3|-4|4|5|6|19|7|@]|8|@]|9|$]]|$1|M|3|-4|4|5|6|1A|7|@]|8|@]|9|$]]|$1|N|3|O|4|C|6|1B|7|@]|8|@]|9|$]]|$1|P|3|-4|4|5|6|1C|7|@]|8|@]|9|$]]|$1|Q|3|R|4|5|6|1D|7|@]|8|@$D|1E|E|1F|1|1G]]|9|$]]|$1|S|3|-4|4|5|6|1H|7|@]|8|@]|9|$]]]|T|$U|$4|V|W|X|9|$Y|Z]]]]

<ol>
<li>try <code>telnet 3306</code>. If it doesn't open connection, either there is a firewall setting or the server isn't listening (or doesn't work).
</li>
<li>run <code>netstat -an</code> on server to see if server is up.
</li>
<li>It's possible that you don't allow remote connections.
See <a href="http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html" rel="noreferrer">http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html</a>
</li>
</ol>

blocks|key|2814234|text|必须检查对端口3306的传入访问是否被防火墙拦截。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2814235|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Must check whether incoming access to port 3306 is block or not by the firewall.

blocks|key|2814237|text|编辑my.cnf文件：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2814238|vi+/etc/my.cnf|offset|length|style|CODE|2814239|确保：|2814240|bind-address=YOUR-SERVER-IP|2814241|如果你有一句台词：|2814242|skip-networking|2814243|请务必对其进行注释：|2814244|#skip-networking|2814245|别忘了重启：|2814246|/etc/init.d/mysqld+restart|2814247|entityMap^0|0|0|E|0|0|0|R|0|0|0|F|0|0|0|G|0|0|0|Q|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@$D|11|E|12|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|13|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|14|8|@$D|15|E|16|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|17|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|18|8|@$D|19|E|1A|F|G]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1B|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1C|8|@$D|1D|E|1E|F|G]]|9|@]|A|$]]|$1|T|3|U|5|6|7|1F|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1G|8|@$D|1H|E|1I|F|G]]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|Y|$]]

edit my.cnf file:

<code>vi /etc/my.cnf</code>:

make sure that:

<code>bind-address=YOUR-SERVER-IP</code>

and if you have the line:

<code>skip-networking</code>

make sure to comment it:

<code>#skip-networking</code>

don't forget to restart:

<code>/etc/init.d/mysqld restart</code>

blocks|key|194030|text|要直接登录到远程mysql控制台，请使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194031|mysql+-u+{username}+-p'{password}'+\
++++-h+{remote+server+ip+or+name}+-P+{port}+\
++++-D+{DB+name}|code-block|syntax|javascript|194032|例如|194033|mysql+-u+root+-p'root'+\
++++++++-h+127.0.0.1+-P+3306+\
++++++++-D+local|194034|在-p后面没有空格，如documentation中所指定|offset|length|style|BOLD|194035|您可以通过切换到上面提到的数据库直接进入mysql控制台。|194036|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/8.0/en/command-line-options.html^0|0|0|0|0|0|3|B|D|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@$M|15|N|16|O|P]]|9|@$M|17|N|18|1|19]]|A|$]]|$1|Q|3|R|5|6|7|1A|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

To directly login to a remote mysql console, use the below command:
<pre><code>mysql -u {username} -p'{password}' \
 -h {remote server ip or name} -P {port} \
 -D {DB name}
</code></pre>
For example
<pre><code>mysql -u root -p'root' \
 -h 127.0.0.1 -P 3306 \
 -D local
</code></pre>
no space after -p as specified in the <a href="http://dev.mysql.com/doc/refman/8.0/en/command-line-options.html" rel="noreferrer">documentation</a>
It will take you to the mysql console directly by switching to the mentioned database.

blocks|key|2814265|text|尝试使用此命令mysql+-uuser+-hhostname+-PPORT+-ppassword。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2814266|我遇到了类似的情况，后来当使用命令输入主机的mysql端口时，问题就解决了。|2814267|entityMap^0|7|15|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

Try this command <code>mysql -uuser -hhostname -PPORT -ppassword</code>.

I faced a similar situation and later when mysql port for host was entered with the command, it was solved.

blocks|key|192016|text|你应该把你的密码加上'p‘|type|unstyled|depth|inlineStyleRanges|entityRanges|data|192017|mysql+-u+root+-u+1.1.1.1+-p'MyPass'|code-block|syntax|javascript|192018|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You should put your password with 'p' 

<pre><code>mysql -u root -u 1.1.1.1 -p'MyPass'
</code></pre>

blocks|key|2814317|text|这个解决方案对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2814318|在您的远程计算机(例如:+295.13.12.53)上有权访问您的目标远程计算机(运行mysql服务器)|2814319|ssh+-f+-L+295.13.12.53:3306:10.18.81.36:3306+user@295.13.12.53|code-block|syntax|javascript|2814320|解释：|2814321|ssh+-f+-L+your_ssh_mashine_ipaddress:your_ssh_mashine_local_port:target_ipaddress:target_port+user@your_ip_address+-N|2814322|your_ssh_mashine_ipaddress+-它不是本地ip地址，而是您ssh到的ip地址，在本例中为295.13.12.53|2814323|your_ssh_mashine_local_port+-this的自定义端口不是22，在本例中为3306。|2814324|target_ipaddress+-您尝试转储数据库的计算机的ip。|2814325|target_port+-+3306这是MySQL服务器的实际端口。|2814326|user@your_ip_address+-这是您连接的ssh+mashine的ssh凭据|2814327|完成所有这些操作后，返回到您的机器并执行以下操作：|2814328|mysqldump+-h+295.13.12.53+-P+3306+-u+username+-p+db_name+>+dumped_db.sql|2814329|将要求输入密码，输入您的密码即可连接。希望这能有所帮助。|2814330|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|16|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|17|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|18|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|19|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1C|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1D|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1F|8|@]|9|@]|A|$G|H]]|$1|10|3|11|5|6|7|1G|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|13|$]]

this solution worked for me:

On your remote machine (example: 295.13.12.53) has access to your target remote machine (which runs mysql server)

<pre><code>ssh -f -L 295.13.12.53:3306:10.18.81.36:3306 user@295.13.12.53
</code></pre>

Explained:

<pre><code>ssh -f -L your_ssh_mashine_ipaddress:your_ssh_mashine_local_port:target_ipaddress:target_port user@your_ip_address -N
</code></pre>

your_ssh_mashine_ipaddress - it is not local ip address, it is ip address
that you ssh to, in this example 295.13.12.53

your_ssh_mashine_local_port -this is custom port not 22, in this example it is 3306.

target_ipaddress - ip of the machine that you trying to dump DB.

target_port - 3306 this is real port for MySQL server.

user@your_ip_address - this is ssh credentials for the ssh mashine that you connect

Once all this done then go back to your machine and do this:

<pre><code>mysqldump -h 295.13.12.53 -P 3306 -u username -p db_name &gt; dumped_db.sql
</code></pre>

Will ask for password, put your password and you are connected.
Hope this helps.

blocks|key|2814341|text|简单地把这个放在ubuntu的终端上：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2814342|mysql+-u+username+-h+host+-p|code-block|syntax|javascript|2814343|现在按enter键|2814344|终端将询问您的密码，输入密码即可进入数据库服务器|2814345|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

simply put this on terminal at ubuntu: 

<pre><code>mysql -u username -h host -p
</code></pre>

Now hit enter

terminal will ask you password, enter the password and you are into database server

blocks|key|189818|text|我假设您的机器上安装了MySQL。填写缺少的详细信息后，执行以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|189819|mysql+-uUSERNAME+-pPASSWORD+-hHOSTNAME+-P3306+|code-block|syntax|javascript|189820|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I assume you have MySQL installed on your machine. Execute the command below after filling missing details:

<pre><code>mysql -uUSERNAME -pPASSWORD -hHOSTNAME -P3306 
</code></pre>

blocks|key|3027010|text|我也收到了同样的错误。但通过在远程mysql服务器和连接上创建新的mysql用户，发现它很有用。在远程服务器上运行以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3027011|CREATE+USER+'openvani'@'localhost'+IDENTIFIED+BY+'some_pass';
GRANT+ALL+PRIVILEGES+ON+*.*+TO+'openvani'@'localhost+WITH+GRANT+
OPTION;
CREATE+USER+'openvani'@'%25'+IDENTIFIED+BY+'some_pass';
GRANT+ALL+PRIVILEGES+ON+*.*+TO+'openvani'@'%25'+WITH+GRANT+OPTION;
FLUSH+PRIVILEGES;|code-block|syntax|javascript|3027012|现在，您可以使用以下命令连接到远程mysql。|3027013|mysql+-u+openvani+-h+'any+ip+address'-p|3027014|以下是完整的帖子：|3027015|http://openvani.com/blog/connect-remotely-mysql-server/|offset|length|3027016|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|0|1J|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Z|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|11|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|12|8|@]|9|@$O|13|P|14|1|15]]|A|$]]|$1|Q|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|N]]]]

I was too getting the same error.
But found it useful by creating new mysql user on remote mysql server ans then connect. Run following command on remote server:

<pre><code>CREATE USER 'openvani'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'openvani'@'localhost WITH GRANT 
OPTION;
CREATE USER 'openvani'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'openvani'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
</code></pre>

Now you can connect with remote mysql with following command.

<pre><code>mysql -u openvani -h 'any ip address'-p
</code></pre>

Here is the full post:

<a href="http://openvani.com/blog/connect-remotely-mysql-server/" rel="nofollow noreferrer">http://openvani.com/blog/connect-remotely-mysql-server/</a>

blocks|key|194158|text|试试这个，它是有效的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194159|mysql+-h+{主机名}-u{用户名}-p{密码}+-N+-e“{查询执行}”|offset|length|style|BOLD|194160|entityMap^0|0|0|15|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Try this, Its working:

mysql -h {hostname} -u{username} -p{password} -N -e "{query to execute}"

blocks|key|2814537|text|如果您不想使用ssh隧道，则必须使用本地ip地址(192.168.1.100)在my.cnf或mysqld.cnf中更改127.0.0.1，才能访问Lan。示例如下：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2814538|sudo+nano+/etc/mysql/mysql.conf.d/mysqld.cnf|code-block|syntax|javascript|2814539|在my.cnf或mysqld.cnf中搜索绑定地址|2814540|bind-address++++++++++++=++127.0.0.1|2814541|并将127.0.0.1更改为192.168.1.100+(本地ip地址)|2814542|bind-address++++++++++++=++192.168.1.100|2814543|要应用您所做的更改，必须使用next命令重新启动mysql服务器。|2814544|sudo+/etc/init.d/mysql+restart|2814545|修改lan访问的用户根(在您想要访问的远程服务器上运行下面的查询)|2814546|root@192.168.1.100:~$+mysql+-u+root+-p|2814547|。。|2814548|CREATE+USER+'root'@'%25'+IDENTIFIED+BY+'password';
GRANT+ALL+PRIVILEGES+ON+*.*+TO+'root'@'%25'+WITH+GRANT+OPTION;
FLUSH+PRIVILEGES;|2814549|如果您只想访问特定ip地址，请将'root'@'%25'更改为'root'@'(+ip地址或主机名)‘|2814550|CREATE+USER+'root'@'192.168.1.100'+IDENTIFIED+BY+'password';
GRANT+ALL+PRIVILEGES+ON+*.*+TO+'root'@'192.168.1.100'+WITH+GRANT+OPTION;
FLUSH+PRIVILEGES;|2814551|然后，您可以连接：|2814552|nobus@xray:~$+mysql+-h+192.168.1.100+-u+root+-p|2814553|在ubuntu18.04服务器上测试的|2814554|entityMap^0|P|D|14|6|1B|A|1O|9|0|0|1|6|8|A|L|4|0|0|2|9|E|D|0|0|0|0|A|1|0|0|0|0|G|A|T|K|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1G|8|@$9|1H|A|1I|B|C]|$9|1J|A|1K|B|C]|$9|1L|A|1M|B|C]|$9|1N|A|1O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|1P|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|1Q|8|@$9|1R|A|1S|B|C]|$9|1T|A|1U|B|C]|$9|1V|A|1W|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|1X|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|1Y|8|@$9|1Z|A|20|B|C]|$9|21|A|22|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|H|7|23|8|@]|D|@]|E|$I|J]]|$1|S|3|T|5|6|7|24|8|@]|D|@]|E|$]]|$1|U|3|V|5|H|7|25|8|@]|D|@]|E|$I|J]]|$1|W|3|X|5|6|7|26|8|@$9|27|A|28|B|C]]|D|@]|E|$]]|$1|Y|3|Z|5|H|7|29|8|@]|D|@]|E|$I|J]]|$1|10|3|11|5|6|7|2A|8|@]|D|@]|E|$]]|$1|12|3|13|5|H|7|2B|8|@]|D|@]|E|$I|J]]|$1|14|3|15|5|6|7|2C|8|@$9|2D|A|2E|B|C]|$9|2F|A|2G|B|C]]|D|@]|E|$]]|$1|16|3|17|5|H|7|2H|8|@]|D|@]|E|$I|J]]|$1|18|3|19|5|6|7|2I|8|@]|D|@]|E|$]]|$1|1A|3|1B|5|H|7|2J|8|@]|D|@]|E|$I|J]]|$1|1C|3|1D|5|6|7|2K|8|@]|D|@]|E|$]]|$1|1E|3|-4|5|6|7|2L|8|@]|D|@]|E|$]]]|1F|$]]

If you want to not use ssh tunnel, in my.cnf or mysqld.cnf you must change 127.0.0.1 with your local ip address (192.168.1.100) in order to have access over the Lan. example bellow: 

<pre><code>sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
</code></pre>

Search for bind-address in my.cnf or mysqld.cnf

<pre><code>bind-address = 127.0.0.1
</code></pre>

and change 127.0.0.1 to 192.168.1.100 ( local ip address )

<pre><code>bind-address = 192.168.1.100
</code></pre>

To apply the change you made, must restart mysql server using next command.

<pre><code>sudo /etc/init.d/mysql restart
</code></pre>

Modify user root for lan acces ( run the query's bellow in remote server that you want to have access )

<pre><code>root@192.168.1.100:~$ mysql -u root -p
</code></pre>

..

<pre><code>CREATE USER 'root'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
</code></pre>

If you want to have access only from specific ip address , change 'root'@'%' to 'root'@'( ip address or hostname)'

<pre><code>CREATE USER 'root'@'192.168.1.100' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.100' WITH GRANT OPTION;
FLUSH PRIVILEGES;
</code></pre>

Then you can connect:

<pre><code>nobus@xray:~$ mysql -h 192.168.1.100 -u root -p
</code></pre>

tested on ubuntu 18.04 server

blocks|key|192141|text|对于Mac，请使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|192142|mysql+-u+app+-h+hostaddress+-P+port+-D+dbname+-p|code-block|syntax|javascript|192143|然后在出现提示时输入密码。|192144|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

For Mac, use the following command:

<pre><code>mysql -u app -h hostaddress -P port -D dbname -p
</code></pre>

and then enter the password when prompted.

blocks|key|194203|text|mysql服务器通常配置为仅侦听本地主机(127.0.0.1)，web应用程序在本地主机上使用mysql服务器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194204|如果是这样，但您拥有对服务器的SSH访问权限，则可以创建一个ssh隧道并通过该隧道进行连接。|194205|在本地计算机上，创建隧道。|194206|ssh+-L+3307:127.0.0.1:3306+-N+$user@$remote_host|code-block|syntax|javascript|194207|(此示例使用本地端口3307，以防您还在本地计算机上运行mysql并使用标准端口3306)|194208|现在您应该可以连接到ale了|194209|mysql+-u+$user+-p+-h+127.0.0.1+-P+3307|194210|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|V|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|H|7|Y|8|@]|9|@]|A|$I|J]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

mysql servers are usually configured to listen only to localhost (127.0.0.1), where they are used by web applications.

If that is your case but you have SSH access to your server, you can create an ssh tunnel and connect through that.

On your local machine, create the tunnel. 

<pre><code>ssh -L 3307:127.0.0.1:3306 -N $user@$remote_host
</code></pre>

(this example uses local port 3307, in case you also have mysql running on your local machine and using the standard port 3306)

Now you should be ale to connect with

<pre><code>mysql -u $user -p -h 127.0.0.1 -P 3307
</code></pre>

blocks|key|2814633|text|有一个简单的命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2814634|mysql+-h+{hostip}+-P+{port}+-u+{username}+-p+{database}|code-block|syntax|javascript|2814635|示例|2814636|mysql+-h+192.16.16.2+-P+45012+-u+rockbook+-p+rockbookdb|2814637|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

There is simple command.

<pre><code>mysql -h {hostip} -P {port} -u {username} -p {database}
</code></pre>

Example

<pre><code>mysql -h 192.16.16.2 -P 45012 -u rockbook -p rockbookdb
</code></pre>

blocks|key|191903|text|这对我在MySQL8中很有效，用你的主机名替换hostname，用你的port_number替换port_number，如果他不是根用户，你也可以改变你的mysql_user|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|191904|++++++mysql+--host=host_name+--port=port_number+-u+root+-p|code-block|syntax|javascript|191905|Further+Information+Here|191906|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/connecting.html^0|N|8|1C|B|0|0|0|O|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|D|@$9|11|A|12|1|13]]|E|$]]|$1|M|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

This one worked for me in mysql 8, replace <code>hostname</code> with your hostname and <code>port_number</code> with your port_number, you can also change your mysql_user if he is not root 

<pre><code> mysql --host=host_name --port=port_number -u root -p
</code></pre>

<a href="https://dev.mysql.com/doc/refman/8.0/en/connecting.html" rel="nofollow noreferrer">Further Information Here</a>

blocks|key|192166|text|如果您使用的是windows，请尝试Visual+Studio+Code+with+MySQL+plugins，这是一种在windows计算机上访问MySQL数据的简单且集成的方法。和列出的数据库表，并且可以执行任何自定义查询。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|192167|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you are on windows, try Visual Studio Code with MySQL plugins, an easy and integrated way to access MySQL data on a windows machine. And the database tables listed and can execute any custom queries.

blocks|key|2814656|text|可以使用以下代码连接到远程MY+SQL数据库|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2814657|mysql+-u+{database_user}+-p{db_password}+-h+{host_name}+-P+{port_number}
mysql+-u+admin+-p'your_password'+-h+your-company.aws.com+-P+3306|code-block|syntax|javascript|2814658|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

you can use the following code to connect to a remote MY SQL database
<pre><code>mysql -u {database_user} -p{db_password} -h {host_name} -P {port_number}
mysql -u admin -p'your_password' -h your-company.aws.com -P 3306
</code></pre>

I have a server with Rackspace. I want to access the database from my local machine command line.
I tried like:
<pre><code>mysql -u username -h my.application.com -ppassword
</code></pre>
But it gives an error:
<blockquote>
ERROR 2003 (HY000):
Can't connect to MySQL server on 'my.application.com' (10061)
</blockquote>
What causes this error and how can I connect to the remote database?

Access mysql remote database from command line

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个带有Rackspace的服务器。我想从我的本地机器命令行访问数据库。我试着这样做：mysql -u username -h my.application.com -ppassword但它给出了一个错误：错误2003 (HY000)：无法连接到'my.application.com‘上的MySQL服务器(1006...

问从命令行访问mysql remote数据库
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从命令行访问mysql remote数据库EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从命令行访问mysql remote数据库
EN