archive-com.com » COM » S » SEQUELPRO.COM

Total: 92

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Query View | Sequel Pro
    Shortcut 5 Query Favourites The Query Favourites are a powerful feature that makes it easy to rerun saved queries or to write dynamic and customisable reusable queries Learn more about Query Favorites Tab Trigger A tab trigger is used as keyboard short cut to insert the corresponding query favorite into the Custom Query Editor It can contain any alphanumeric character but no spaces or punctuation signs Tab Snippet A tab

    Original URL path: http://www.sequelpro.com/docs/Query_View (2016-02-10)
    Open archived version from archive


  • What type of connection do I have? | Sequel Pro
    eg it is behind a firewall you will have to use a SSH connection For more details see Connecting to a MySQL Server on a Remote Host At the moment Sequel Pro does not support SSL encryption If possible use a SSH connection instead Standard Connection A standard connection is an unencrypted connection using TCP IP Such a connection is usually made over the network or over the internet to a remote server To specify which server to connect to you must provide its IP address or DNS resolvable name IP Address 192 168 0 11 66 78 91 2 DNS resolvable name Crema X Serve local intranet mycompany com mysql webhosting com If you use the special address 127 0 0 1 you can connect to a server on your own computer Note Some web hosting companies may give you access to MySQL running on the server that is hosting your website often by adding your IP address to a whitelist In this case your web host will provide you with an IP address or a domain name on a server located on the internet that has a port open for you to connect to If this is unavailable to you you may need to connect to MySQL via an SSH Tunnel Required Fields Host Enter the host name or IP address of the host Username The default username for a mysql install is root Optional Fields Name The name you want to give the favourite Password The default password for a mysql install is an empty string If that s the case you should change the root password right away Database If you enter a database it will be selected when the connection to the server is established Otherwise you can select one of the databases on the

    Original URL path: http://www.sequelpro.com/docs/what-type-of-connection-do-i-have (2016-02-10)
    Open archived version from archive

  • Connect to a Local MySQL Server | Sequel Pro
    running open Activity Viewer from Applications Utilities Choose All Processes in the popup menu Type mysqld into the search field If you see a mysqld process MySQL is running Connecting via a socket connection Open Sequel Pro Choose a Socket Connection You must only specify the username and password if any Most MySQL installations use the default username root and a blank password If you leave the socket field empty Sequel Pro will try several common socket file locations If Sequel Pro can t find your socket file or if you have multiple MySQL servers running on your computer you must enter the location of the socket file See Where are MySQL s Files for common socket file locations Note the popular MAMP package uses root as default password See Connecting to MAMP or XAMPP Connecting via a standard connection Open Sequel Pro Choose a Standard Connection Enter 127 0 0 1 for the host The default username for a new MySQL installation is root with a blank password You can leave the port field blank unless your server uses a different port than 3306 Note MAMP uses port 8889 per default and root as the password See Connecting to

    Original URL path: http://www.sequelpro.com/docs/Connecting_to_a_local_MySQL_Server (2016-02-10)
    Open archived version from archive

  • Connect to a Remote MySQL Server | Sequel Pro
    how MySQL decides if you are allowed to connect if the server is behind a firewall the firewall must be configured to accept MySQL connections The firewall must be configured to allow incoming TCP connections on the port used by MySQL Per default MySQL uses port 3306 You must be able to reach the MySQL server directly If the MySQL server is behind a NAT gateway you may not be able to reach the server SSH connections You can use a SSH connection to circumvent some of the restrictions of standard conections A SSH connection is actually not really a different kind of connection but rather a standard connection made through a SSH tunnel While a standard connection involves only two hosts your computer and the host on which the MySQL server is running a SSH connection involves a third host the SSH host The SSH host can be the same as the MySQL host but it doesn t have to be Figure 1 An SSH connection can be used to connect through a firewall if the firewall allows SSH tunnels sshd is a process that accepts SSH connections and mysqld is the MySQL server process If you use a SSH connection Sequel Pro first creates a SSH tunnel to the SSH host Then it uses this tunnel to connect via a standard connection from the SSH host to the MySQL host This complicated procedure allows you to Connect to a server behind a firewall If a firewall prevents direct access to the MySQL server you might still be able to connect via SSH to a computer behind the firewall or the MySQL server itself and from there to the MySQL server Encrypt the connection If you use a SSH connection the connection between your computer and the SSH host are encrypted Please note that the connection between the SSH host and the MySQL host is not encrypted Of course SSH connections don t solve every problem The following requirements are necessary like above the MySQL server must accept network connections the MySQL server must allow access from the SSH host you must be able to reach the SSH host If the SSH host is behind a firewall it must be configured to allow SSH connections Also if the SSH host is behind a NAT it must also be configured correctly Choosing a SSH Host The SSH host can basically be any computer that can access the MySQL server You could for example use your desktop computer at work to connect to your company s MySQL server from home A hosting provider might tell you to connect to their MySQL server via a specific SSH host You need a username and a password for the computer you want to use as the SSH host and it must support remote access via SSH Almost all Unix Linux systems and Mac OS X have built in SSH support On Mac OS SSH ist called Remote Login and can be enabled in the

    Original URL path: http://www.sequelpro.com/docs/Connecting_to_a_MySQL_Server_on_a_Remote_Host (2016-02-10)
    Open archived version from archive

  • Connect to MySQL on an Amazon AWS server | Sequel Pro
    Working with data Core Features MySQL Reference Bundles Core Bundles Contributed Bundles How to use Create your own Submit a bundle Contribute Coding Localization Get Involved Contact Us Amazon RDS Relational Database Service Java development 2 0 Play ing with Amazon RDS Sequel Pro Donate Get Involved CocoaMySQL Blog Download Nightly Build Server Release Notes Release Archive Issue Tracker Documentation Developers Feature Requests Contact Us FAQs MySQL on Mac OS

    Original URL path: http://www.sequelpro.com/docs/Connecting_to_Amazon_AWS (2016-02-10)
    Open archived version from archive

  • Connect to MySQL on a Media Temple Grid Service (gs) | Sequel Pro
    Keyboard Shortcuts Frequently Asked Questions Reference Working with data Core Features MySQL Reference Bundles Core Bundles Contributed Bundles How to use Create your own Submit a bundle Contribute Coding Localization Get Involved Contact Us Something about Media Temple Sequel Pro Donate Get Involved CocoaMySQL Blog Download Nightly Build Server Release Notes Release Archive Issue Tracker Documentation Developers Feature Requests Contact Us FAQs MySQL on Mac OS X Getting Connected Set

    Original URL path: http://www.sequelpro.com/docs/Connecting_to_Media_Temple_GS (2016-02-10)
    Open archived version from archive

  • Structure View | Sequel Pro
    to use Create your own Submit a bundle Contribute Coding Localization Get Involved Contact Us In the structure tab you can edit the fields that make up your tables We also make it easy to see the indexes for your table by incorporating them into the same view Shortcut 1 Sequel Pro Donate Get Involved CocoaMySQL Blog Download Nightly Build Server Release Notes Release Archive Issue Tracker Documentation Developers Feature

    Original URL path: http://www.sequelpro.com/docs/Structure_View (2016-02-10)
    Open archived version from archive

  • Content View | Sequel Pro
    Coding Localization Get Involved Contact Us The content view in Sequel Pro gives you direct editing access to all of the rows in your tables The content view is super fast and allows you to manage text and binary files you have stored in your database including images audio files PDFs and many other file types Shortcut 2 Sequel Pro Donate Get Involved CocoaMySQL Blog Download Nightly Build Server Release

    Original URL path: http://www.sequelpro.com/docs/Content_View (2016-02-10)
    Open archived version from archive



  •