![]() You’ll see the added port in the list of “Forwarded ports”. ![]() This will create a secure tunnel by forwarding a port (the “destination port”) on the remote server to a port (the “source port”) on the local host (127.0.0.1 or localhost).Ĭlick the “Add” button to add the secure tunnel configuration to the session. Remember that if you are redirecting HTTP requests to the HTTPS port, you must use destination port 443 instead of 80. In the “Connection -> SSH -> Tunnels” section, add a new forwarded port by introducing the following values: Once you have your SSH client correctly configured and you have confirmed that you can successfully access your instance using SSH, you need to create an SSH tunnel in order to access phpMyAdmin. In the instructions below we have selected PuTTY, a free SSH client for Windows and UNIX platforms. In order to access phpMyAdmin via SSH tunnel, you need an SSH client. TIP: Refer to these instructions to learn how to obtain your private key. Watch the following video to learn how to easily access phpMyAdmin on Windows through an SSH tunnel: In this case, modify the steps below to use ports 81 or 443 respectively instead of port 80 for the tunnel endpoint. Similarly, if you have enabled Varnish (TM) or HTTPS redirection, your stack’s Web server might be accessible on port 81 (Varnish (TM)) or port 443 (SSL). If this port is already in use by another application on your local machine, replace it with any other port number greater than 1024 and modify the steps below accordingly. NOTE: The steps below suggest using port 8888 for the SSH tunnel. IMPORTANT: Before following the steps below, ensure that your Web and database servers are running. This implies that you must be able to connect to your server over SSH in order to access these applications remotely. To access it from a remote system, you must create an SSH tunnel that routes requests to the Web server from 127.0.0.1. ![]() Video: WordPress website migration – manually.For security reasons, phpMyAdmin is accessible only when using 127.0.0.1 as the hostname. I’ll provide a link, that should take you to the video’s time of 7:48 where PhpMyAdmin use is shown briefly. I made a long tutorial video on website migration, where I also show working within PhpMyAdmin. Now you will get a menu for adding privileges: Check the privileges you wish (1) and click on “Go” (2) Or add another user by clicking on “Add user account” (4) If you wish to give the privileges to another user (you had created), this is the procedure: Select the database you wish (1)Ĭlick on “Edit privileges” for the user you wish (3) ![]() User you logged in with and created the database usually automatically gets all the privileges. Now a database should be created: Click on “Databases” and enter a database name (1), then click on “Create” (2) ![]() If it is being done on a local computer, open a browser and type this address: The explanation is simple, brief, pictures speak for themselves: Separate posts explain this part:Įither way, if you need to use a database (for installing WordPress for example), you will need to create it, and a user, with needed access rights / privileges. Though you can install it manually within a subdirectory, or as a part of WAMP, or LAMP installation, on your local (home) computer. If you are using one of the above mentioned control panels, they contain an icon for starting PhpMyAdmin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |