9/21/2023 0 Comments Sequel pro connect to localhostHowever, it looks from the netstat output as if mysql is still listening on localhost rather than on the public IP. To my mind, because I have i) UFW/firewall set to default allow incoming traffic and ii) I've configured the bind-address option in MySQL to the server's public IP, then the connection should work. Unix 2 STREAM LISTENING 2836458 /run/user/1000/systemd/private Unix 2 STREAM LISTENING 14228 /var/run/fail2ban/fail2ban.sock Unix 2 STREAM LISTENING 12686 /run/uuidd/request Unix 2 STREAM LISTENING 12683 /var/run/dbus/system_bus_socket Unix 2 STREAM LISTENING 8017 /run/systemd/journal/stdout Unix 2 STREAM LISTENING 2837069 /var/run/mysqld/mysqld.sock Unix 2 SEQPACKET LISTENING 8009 /run/udev/control Unix 2 STREAM LISTENING 8006 /run/systemd/fsck.progress Unix 2 STREAM LISTENING 14105 /var/run/sendmail/mta/smcontrol Unix 2 STREAM LISTENING 2127878 /run/systemd/private Proto RefCnt Flags Type State I-Node Path Proto Recv-Q Send-Q Local Address Foreign Address StateĪctive UNIX domain sockets (only servers) Which gave me the following output: Active Internet connections (only servers) > Unable to connect to host 139.161.234.123, or the request timed out.īe sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds). When I try to connect via Sequel Pro, I get: # The files must end with '.cnf', otherwise they'll be ignored. # * IMPORTANT: Additional settings that can override those from this file! # -print-defaults to see which it would actually understand and use. # Run program with -help to get a list of available options and with # One can use all long options that the program supports. # - "~/.my.cnf" to set user-specific options. # - "/etc/mysql/my.cnf" to set global options, # The MySQL database server configuration file. I've also edited /etc/alternatives/my.cnf (which is symlinked to /etc/mysql/mysql.cnf) so it looks like this:.I also have the following explicit UFW rules (where 81.123.67.94 is my laptop's current IP address) Temporarily changed the UFW firewall settings to "sudo ufw default allow incoming". So far, I have taken the following steps: I need to be able to connect using a standard connection (no SSH key-pair). However, this is using the 'SSH' option and key-pair authentication. Using Sequel Pro, I can already connect to target database using targetuser. I've created a new database user ( target user) which has the correct privileges for targetdb. I'm trying to make an existing MYSQL database ( target_db) on this server available for remote connection by a separate, remote (trusted) PHP application. LAMP is successfully installed and we already have a production website working well. ssh secrets MYSQL.I have a Linode 1024 running Ubuntu 16.04 LTS. Open a new window terminal window and issue this on your local machine: # connect to the database Your App > Access. Once the tunnel is up, you can connect to the remote MySQL database with the mysql console client. This command is not supposed to print a confirmation message. :3306 local 13306 is just an example, any port in the range 1025-65535 can be used. Usually there is a configuration file which is used from the App to connect to the fortrabbit database. How to access & configure the common database on fortrabbit.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |