WAMP配置

--- Launch phpMyAdmin
When starting phpMyAdmin, you will be asked for a user name and password.
After installing Wampserver 3, the default username is "root" (without quotes) and there is no password, which means that you must leave the form Password box empty.
There will be a warning:
You are connected as 'root' with no password, which corresponds to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'.
This is not a problem as long as access to Phpmyadmin remain locally.
However, some web applications or CMS asking that the MySQL user has a password. In which case, you will create a user with password via the PhpMyAdmin Accounts Users tab.


--- Using the menus and submenus of Wampmanager
Do not use the keyboard to navigate through the menus and submenus of Wampmanager icon.


--- For questions regarding Wampserver 3
Please use the specific forum: http://forum.wampserver.com/list.php?2
Do not use an existing discussion, but create your own thread:
New Topic

after having read  READ BEFORE YOU ASK A QUESTION in this forum.

——————————————————————————————————————————————————————————————————————

how to update phpmyadmin:

https://john-dugan.com/upgrade-phpmyadmin-wamp/ 

_____________________________________________________________________________________________________________________________

show and change mysql default character set

https://makandracards.com/makandra/2529-show-and-change-mysql-default-character-set

https://mathiasbynens.be/notes/mysql-utf8mb4 

______________________________________________________________________________________________________________________________

intro to pdo (mysql)

https://www.conetix.com.au/blog/why-you-should-use-pdo-instead-mysqli 

https://phpdelusions.net/pdo#why 

________________________________________________________________________________________________________________________________

Why switch emulation to ‘false’?

The main reason for this is that having the database engine do the prepare instead of PDO is that the query and the actual data are sent separately, which increases security. This means when the parameters are passed to the query, attempts to inject SQL into them are blocked, since MySQL prepared statements are limited to a single query. That means that a true prepared statement would fail when passed a second query in a parameter.

The main argument against using the database engine for the prepare vs PDO is the two trips to the server – one for the prepare, and another for the parameters to get passed – but I think the added security is worth it.  Also, at least in the case of MySQL, query cachinghas not been an issue since version 5.1.