![]() Use the same password you used when previously configuring the server to accept remote connections. Have you checked for issues outside of mySQL, such as a firewall or a routing issue Stese at 6:56 Add a comment 6 Answers Sorted by: 29 Try to add bind-address 0.0.0.0 to your mysqld section of your my.cnf and restart mysqld. Installation To install MySQL, run the following command from a terminal prompt: sudo apt install mysql-server Once the installation is complete, the MySQL server should be started automatically. If the connection is successful, click “OK” to save the connection.ĭouble-click the new connection to launch the MySQL Workbench SQL Editor. Configure your MySQL/MariaDB server to listen on your IP address by setting the following parameter in my.cnf: bind-addressIPaddress or bind-address0.0.0.0 for all IP interfaces on your server. Select “Standard (TCP/IP)” as the “Connection Type”.Įnter your cloud server’s IP address in the “Hostname” field.Ĭlick “Test Connection” to test the connection. Connect to the server running the MySQL database and check if the MySQL server is actively running by running this command mysqladmin -u root -p status (which. Follow these steps:Ĭlick the “+” symbol in the “MySQL Connections” tab to add a new connection.Įnter a name for the connection in the “Connection Name” field. Once your MySQL server is configured to accept remote connections, you can connect to it using MySQL Workbench. To connect to your remote MySQL database server using MySQL Workbench, you have to allow remote connections to the server. NOTE: This section assumes that you have downloaded and installed MySQL Workbench. The output of the command indicates which database server (MySQL or MariaDB) is used by the installation, and will allow you to identify which guides to follow in our documentation for common database-related operations. port MySQL port to use, default is usually OK. database Database to use, None to not use a particular one. To identify which database server is used in your stack, run the command below: $ test -d /opt/bitnami/mariadb & echo "MariaDB" || echo "MySQL" Each service has a default port: The Apache web server typically uses port 80, and the MySQL database server uses port 3306. Parameters: host Host where the database server is located. ![]() On account of these changes, the file paths and commands stated in this guide may change depending on whether your Bitnami stack uses MySQL or MariaDB. NOTE: We are in the process of modifying the configuration for many Bitnami stacks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |