Note that any changes available in the pending modifications queue are also applied. With this option any pending modifications will be asynchronously applied as soon as possible, regardless of the maintenance window configured for the selected database instance. Select Apply immediately to apply the changes right away.Select Apply during the next scheduled maintenance window to apply the changes automatically during the next scheduled maintenance window.The valid port numbers that can be used are 1150 to 65535 for MySQL/MariaDB/Aurora/PostgreSQL/Oracle and 1150 to 65535 except for 1434, 3389, 47001, 49152, and 49152-49156 for SQL Server.Ġ6 Choose Continue and review the configuration changes that you want to apply, available in the Summary of modifications section.Ġ7 In the Scheduling of modifications section, perform one of the following actions based on your workload requirements: "ConstraintDescription": "Must contain only alphanumeric characters."ĭescription: Change the Default Database Port NumberĬonstraintDescription: Must begin with a letter and must not end with a hyphenĬonstraintDescription: Must provide a valid DB instance type.ĭescription: The size of the database (GiB)ĬonstraintDescription: Must be between 6 GiB.ĬonstraintDescription: Must begin with a letter and contain only alphanumericĭescription: Username for database accessĭescription: Password for database accessĬonstraintDescription: Must contain only alphanumeric characters.ĭBInstanceIdentifier: !Ref 'DBInstanceName'ĪllocatedStorage: !Ref 'DBAllocatedStorage'Ġ1 Sign in to the AWS Management Console.Ġ3 In the navigation panel, under Amazon RDS, choose Databases.Ġ4 Select the Amazon RDS database instance that you want to reconfigure and choose Modify.Ġ5 On the Modify DB instance: page, in the Connectivity section, replace the database default port number available in the Database port box with your custom port number. "Description": "Password for database access", "Description": "Username for database access", "ConstraintDescription": "Must begin with a letter and contain only alphanumeric characters." "ConstraintDescription": "Must be between 6 GiB." "Description": "The size of the database (GiB)", "ConstraintDescription": "Must provide a valid DB instance type." "ConstraintDescription": "Must begin with a letter and must not end with a hyphen or contain two consecutive hyphens." "Description": "RDS database instance name", Then I tested the connection in the MySQL Workbench successfully."Description": "Change the Default Database Port Number", Then I was able to verify port 3306 was available. Great thing about this virtual machine is that it rebooted in less than minute on my old laptop. ![]() Again out of laziness, I just rebooted to reset the configurations of the database & firewall. Set the firewall to allow connections on port 3306. Then save & close the my.cnf configuration file.ģ. Change the “127.0.0.1” to ” :: “, and this will allow any IP address to access the database (don’t do this on your production MariaDB servers, or it will fail any auditor security scans). The only parameter that need to be changed is the bind_address. ![]() To correct the problem above, the my.cnf file will need to be edited: sudo vi /opt/bitnami/mariadb/conf/my.cnf If you see that port 3306 is enabled only for 127.0.0.1, then only connections on that server can be made using that port.Ģ. Check netstat to see if the port is enabled for only the local server. ![]() Out of laziness, I am using the default bitnami OS user account and the root user for the MariaDB, credentials found: cat /home/bitnami/bitnami_credentials Instructions: Enable or disable the SSH server – Debianģ. Enabled the virtual machine for SSH connections for Debian, so I can make putty connections. Using the DHCP address enabled by default on virtual machine (laziness – should set static IP address), my only configuration was enabling the network connection in my VM Workstation.Ģ. I wanted to connect to the MariaDB database located on a Bitnami MariaDB Virtual Machine with the MySQL Workbench on my laptop’s software.Īlready done to the Bitnami MariaDB Virtual Machine:ġ. Sometimes they can be a challenge when I want to use other software with them. Bitnami virtual machines are great for quickly enabling an environment for testing or learning.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |