You can use terminal to log on to linuxmysql. the reason for Port 3306 being disabled is bitsCN.com.
Linux suse11 can log on to terminal to perform various operations normally. jdbc web program running on tomcat has an exception:
Com. mysql. jdbc.
Mysql opens remote port 15.04 and port 3306 in ubuntu 15.043306.
Ubuntu 15.04 opens mysql remote port 3306. All of the following operations are performed in the terminal.
First, check whether netstat-an | grep 3306 is enabled on the port.
This
There are two major strides in opening MySQL's remote login account:1. Determine that the firewall on the server does not block port 3306.MySQL default port is 3306, need to determine the firewall does not block 3306 port, otherwise remote is unable
1. Network detection1) Ping the host can;2) Telnet host 3306 port can not;Telnet host 22 port can be;The description is not related to the native network;2. Port detection1) netstat-ntpl |grep 3306TCP 0 0::: 3306:::* LISTEN-2) Netstat-ntpl |grep
Enable remote port 16.04 and 16.04mysql5.7.17 for mysql5.7.17 in ubuntu 3306
Enable MySQL Remote Access Permissions
By default, mysql users do not have the permission for remote access. Therefore, when the program is not on the same server as the
Turn on MySQL remote access permissionThe default MySQL user does not have remote access permission, so when the program is not on the same server as the database, we need to turn on MySQL remote access.There are two main ways to change the table
Set up the second mysql instance bitsCN.com with Port 3306 in the case of the mysqld service.
Create a mysql instance with the second port 3306 in the case of the original port 3308 mysqld service
1 download the tar.gz [root @ 472322 tmp] #
Background NotesThere are several ways to install MySQL, such as binary installation, source code compilation and installation, Yum installation, and so on. Yum installation can only install MySQL version 5.1, the source code installation and
In linux, mysql enables remote access and opens port 3306 through the firewall.
Enable mysql Remote Access Permissions
By default, mysql users do not have the permission for remote access. Therefore, when the program is not on the same server as the
In linux, mysql enables the remote access permission firewall to open port 3306 and mysql3306.
Enable mysql Remote Access Permissions
By default, mysql users do not have the permission for remote access. Therefore, when the program is not on the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.