![]() 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. Modify the available memory for the virtual machineįor security reasons, phpMyAdmin is accessible only when using 127.0.0.1 as the hostname.Auto-configure a Let's Encrypt certificate.Connect to the virtual machine from another host.Configure the application's IP address or hostname.Learn about the Bitnami Configuration Tool.Configure third-party SMTP for outbound emails.Modify the default login password for the virtual machine.Understand what data Bitnami collects from deployed Bitnami stacks.Learn about Bitnami PHP application modules deprecation.Understand the default directory structure.Learn about the SSH warning 'REMOTE HOST IDENTIFICATION HAS CHANGED'.Configure password-based SSH authentication.You can now sign in to WordPress with your new username and password.Frequently Asked Questions for Virtual Machines You have created yourself a new username. unmeta_id – leave this blank (it will be auto-generated).Select Insert tab again and under Value column, add the following information: user_id – This will be the user id we created in the previous step.unmeta_id – You can leave it blank (it will be auto-generated).This table might be called wp_usermeta in your menu. ![]() From the left-side menu, select usermeta table. Now, we are going to add the values to usersmeta table. display_name – use the name you would like to display for this user (you can use your user_nicename value as well).user_registered – pick the date and time when this user will be registered.user_url – this would be the url of your website.user_email – add the email address you want to associate with this user account.user_nicename – add a nickname for user.Make sure you select MD5 in the functions menu (Please refer to the screenshot below). user_pass – pick a password for this username.user_login – add the username you want to use for accessing the WordPress dashboard.ID – Pick a number which isn’t already used by another user (in our example, we will use the number 7).We will need to add our new admin user’s information. Select Insert from the top menu, as highlighted in the above screenshot. This table might be called wp_users in your menu. Once you have selected the correct database, look for users and usermeta tables. Select the correct database from a list of available databases in your phpMyAdmin from the left side menu. (Below is a screenshot taken from a Bluehost cPanel) Login to your cPanel account and access phpMyAdmin and locate your WordPress database. This tutorial would require you to have a basic understanding of how phpMyAdmin works. Note: Please take a backup of your database before making any MySQL edits. In this article, we will cover a detailed step by step guide for you on how to create an admin user to the WordPress Database via cPanel using phpMyAdmin. We thought of coming up with an article which can help our clients and users in general if they find themselves in similar situation. It can be a very difficult situation if your original WordPress administrator account is compromised or you are not able to access the WordPress dashboard to create a new admin user account.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |