A Website or another web app such as an online store or e-commerce is a special application that runs on a web server. To open the website page, you need to use a web browser such as Google Chrome, Mozilla Firefox, or Microsoft Edge. You first need to run your browser and then type the URL of the website page you want to visit in the address bar of the browser you use.
Generally, in creating or testing a new website, most people will choose to do on a local web server on their PC. This is to ensure whether the website has worked and run well as expected before it can be accessed online. You can turn your PC or laptop into a local web server. To create a local web server, you need to install software like Apache Web Server, PHP, MySQL, and phpMyAdmin and then configure them to connect to each other.
Configuring all software manually to create a local web server is not easy. It takes knowledge and understanding to do it right. An easier way is you can use a web application stack like WampServer. You no longer need to configure Wampserve because WampServer will be configured automatically during the installation process. After installation process of WampServer is complete, your computer has a local web server with software like Apache web server, PHP, MySQL, and phpMyAdmin installed.
WampServer is easy to install and use. By default, to access the MySQL server in WampServer, the username is root and the password is blank. The default settings of WampServer are quite risky. If you use a computer that is also used by others, you should do protection by giving a password to MySQL database. If other people also know WampServer, they will think that you are still using the default settings. Unbeknownst to you, that person can access an unprotected MySQL database and then do the things you do not want.
The default settings of WampServer are quite risky. If the computer you are using is also used by others, you should do protection by giving password for MySQL database. If other people also know WampServer, they can think that you are still using the default settings. Unbeknownst to you, that person can access an unprotected MySQL database and then do the things you do not want.
Protecting a MySQL database on a local web server of WampServer is also important to your new web project save. You need to prevent anything that could cause your project risk. Changing the root password of the MySQL database in WampServer is not difficult. You just write a little command through the MySQL console. If you want to do, here's how:
Run WampServer, click the Show hidden icons button (1), click the button with the WampServer logo (2), next select MySQL (3), and then select the MySQL console (4).
In the MySQL command line window that appears, press the Enter key without entering a password because, by default, MySQL root password is blank. Now you can directly access the MySQL server. To change the blank password by giving a new password, type SET PASSWORD FOR root @ localhost = PASSWORD ('admin345'); where admin345 is your new password for the MySQL root password (2), and then press Enter key.
Now every time you access MySQL server via the MySQL console, you need to enter password admin345.
