Using root for MySQL session storage is not permissible because it is a security risk. The root user has access to all databases and can perform any action on them. Giving root access to a PHP application by allowing it to store sessions in that user's database allows for potential exploits to occur, as a compromised session could give access to the entire system. It is recommended to create a separate, restricted user with limited privileges for the application to use.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-05-05 22:50:02 +0000
Seen: 16 times
Last updated: May 05 '23
How can records be counted from a category that is retrieved through another PHP and SQL query?
What is the method for showing errors in mysqli_query?
How can Laravel establish a connection with a MySQL database located remotely?
How can a web application be developed to send distinct emails upon clicking the SUBMIT button?
How can a PHP function be used to retrieve an HTML table?
How can multiple queries be merged into a single stored procedure in MySQL?
What does "waiting for handler commit" mean in relation to the slow writes experienced in MySQL 8?