This is a guide on How to Switch MySQL to listen on TCP By default, MySQL only allows connections from the localhost address. The configuration file is usually found in /etc/mysql/my.cnf
You will want to comment out the bind-address line by making it look like this:
#bind-address = 127.0.0.1
Next, you will need to restart the database server:
sudo /etc/init.d/mysql restart
This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP.Note
The skip_networking MySQL system variable affects the TCP/IP connection method. If disabled, use named pipes or shared memory (on Windows) or Unix socket files (on Unix).
The parameters for standard TCP/IP connections are:
Hostname: The host name or IP address of the MySQLserver.NoteThe host name “localhost” might resolve to “127.0.0.1” or “::1” on your host, so note this when checking permissions. For example, if a web application’s user only has access to “127.0.0.1” on a host, and a defined connection uses “localhost” that resolves to “::1”, this connection may lack the proper permissions to the aforementioned web application. Ping “localhost” on each host to determine where it resolves to.
Password: Optional password for the account used. If you enter no password here, you will be prompted to enter the password when MySQL Workbench attempts to establish the connection. MySQL Workbench can store the password in a vault (see Section 5.3.8, “The Password Storage Vault”).
Default Schema: When the connection to the server is established, this is the schema that will be used by default. It becomes the default schema for use in other parts of MySQL Workbench.
SSL parameters are:
Use SSL: This dropdown provides options related to enabling SSL encryption. Choose No to disable SSL, If available if the client library supports it, or Require to require SSL support for the MySQL connection to succeed. This option defaults to If available.
SSL Key File: Path to the Key file for SSL.
SSL CERT File: Path the Certificate file for SSL.
SSL CA File: Path to the Certification Authority file for SSL.
SSL Cipher: Optional list of permissible ciphers to use for SSL encryption.
SSL Wizard button: Generate SSL certificates for both the MySQL server and MySQL client. Requires access to OpenSSL binaries in the system’s PATH. For additional information, see Section 5.3.4, “SSL Wizard (Certificates)”.
Files button: Opens a file browser that points to the generated SSL files by the SSL Wizard. For additional information, see Section 5.3.4, “SSL Wizard (Certificates)”
The Advanced tab includes these check boxes:
Use compression protocol: If checked, the communication between the application and the MySQL server will be compressed, which may increase transfer rates. This corresponds to starting a MySQL command-line client with the --compress option. This option is unchecked by default.
Use ANSI quotes to quote identifiers: Treat “”” as an identifier quote character (like the “`” quote character) and not as a string quote character. You can still use “`” to quote identifiers with this mode enabled. With this option enabled, you cannot use double quotation marks to quote literal strings, because it is interpreted as an identifier. Note: If this option is checked, it overrides the server setting. This option is unchecked by default.
Enable Cleartext Authentication Plugin: Send the user password as text that is not encrypted. Required for some authentication methods. This option is unchecked by default.
Use the old authentication protocol: This option disables the Connector/C++ secure_auth option. This option is unchecked by default. Doing so means you can connect to MySQL Server with MySQL users that utilize the old mysql_old_password authentication plugin, which is not recommended. mysql_old_password support was removed in MySQL Server 5.7.NoteThis option was removed in Workbench 6.3.6, and did not function in Workbench 6.3.5. For information about upgrading passwords from the old authentication protocol, see Section 5.3.9, “Updating Old Authentication Protocol Passwords”.Also, MySQL Server 5.7 does not support the old authentication protocol, because secure_auth cannot be disabled. Using the old mysql_old_password has not been recommended since MySQL 4.1.
It also includes these options:
Timeout: Maximum time to wait before the connection is aborted. The connection times out in 60 seconds by default.
SQL_MODE: Override the default SQL_MODE used by the server.
Others: Other options for Connector/C++ as option=value pairs, one per line.
Permission to use quotation from any article is granted subject to full credit of the source being given by referencing the direct link of the article on NYONGESA SANDE However, reproducing any content on this site without explicit permission is strictly prohibited.