Some of the links in this article are "affiliate links", a link with a special tracking code. This means if you click on an affiliate link and purchase the item, we will receive an affiliate commission.
The price of the item is the same whether it is an affiliate link or not. Regardless, we only recommend products or services we believe will add value to our readers.
By using the affiliate links, you are helping support our Website, and we genuinely appreciate your support.
To access MySQL server and phpMyAdmin on a Windows Server 2019, you’ll first need to install them. Here’s a step-by-step guide on how to install and access them:
Installing MySQL Server:
- Download MySQL: Visit the MySQL Community Server download page (https://dev.mysql.com/downloads/mysql/) and download the MySQL installer for Windows.
- Install MySQL: Run the installer file that you downloaded. During the installation process, you’ll be prompted to choose a setup type. Choose “Server only” or “Full” depending on your needs.
- Configure MySQL: After the installation, you’ll be asked to configure the MySQL server. Here, you can set the root password and other settings. Remember the password because you’ll need it to access the MySQL server later.
- Download phpMyAdmin: Visit the phpMyAdmin download page (https://www.phpmyadmin.net/downloads/) and download the latest version of phpMyAdmin.
- Install phpMyAdmin: Extract the downloaded file to your server’s web root directory (this could be something like
C:inetpubwwwrootif you’re using IIS or
C:/xampp/htdocsif you’re using XAMPP).
- Configure phpMyAdmin: Rename the
config.sample.inc.phpfile in the phpMyAdmin directory to
config.inc.php. Open this file with a text editor and change the ‘localhost’ in the following line to the IP address of your MySQL server:
$cfg['Servers'][$i]['host'] = 'localhost';. Also, set the controluser and controlpass with the username and password of your MySQL server.
Accessing MySQL Server and phpMyAdmin:
- Access MySQL Server: You can access the MySQL server using the command line. Open Command Prompt and type the following command:
mysql -u root -p. Then enter your root password when prompted.
- Access phpMyAdmin: You can access phpMyAdmin using a web browser. Type the following in your browser’s address bar:
your-server-ipwith the actual IP address of your server.
Please note that phpMyAdmin requires a web server and PHP to be installed on your Windows Server. If you don’t have these installed, you may want to consider using a solution stack like XAMPP or WAMP, which bundles Apache, MySQL, PHP, and phpMyAdmin together in a single installation.