Appserv: username and password for entering mysql and phpmyadmin
I recently started to learn PHP. I heard that LAMP (Linux + Apache + MySQL + PHP) is usually installed in PHP. of course, we usually use Windows systems now, so we can skip it in Linux, however, I heard that it is very troublesome to install and manage Apache + MySQL + PHP, so I installed an Integrated PHP runtime environment created by Thai people-appserv 2.6.0.
Despite the ease of installation, you only need to fill in the installation path and domain name during installation (if you do not have your own domain name, generally write localhost), mailbox (this does not matter, I wrote my own 163 mailbox), port number (retain the default 80), and root password. The installation is successful.
However, the next step is hard to explain. although appserv integration is easier than the previous decentralized management of the three software, it is still a little troublesome. First, it is basically a command line management, always go to the Internet to find the desired command.
I read a book and said I could use phpmyadmin to manage MySQL. so I tried and found the following problems:
1. enter http: // localhost/phpmyadmin/in the browser and cannot connect to the www folder of appserv at all. you must use http: // 127.0.0.1/phpmyadmin/to access, in the past, it seems that the two were the same, but they were different only after practice.
2. after you enter http: // 127.0.0.1/phpmyadmin/, a dialog box appears asking you to enter the user name and password, at first I thought it was root and password (the root password I wrote when I installed it), but I couldn't input it several times, so I checked it online and tried again, enter admin and password blank, and click OK. unexpectedly, the logon was successful.
The default username and password for accessing phpmyadmin after appserv is installed are admin and empty, not the username and password written in appserv/www/phpmyadmin/config. inc. php! I have searched the entire file and found no admin information or password related to it. Although I do not know where they are saved till now, I have learned how to access phpmyadmin through practice.
Login, go to appserv/mysql/bin/, enter mysql-h localhost-u root-p, and press enter to wrap the line, then ask you to enter the password: enter the password you wrote when installing appserv, and you can log on to the root user account of the localhost host. in the previous red command:
-H indicates the host. localhost indicates your host name, which is the one you entered during installation;
-U indicates the user, and root indicates the default full-permission account of mysql;
-P indicates the password, which is the password corresponding to the user.
