Database (MySQL) root user

Support
1

Issue Summary

MySQL “root” user should never be used for the WordPress database user. This is a HUGE security issue. I don’t see any security related topic in this Community. User have no idea of the risk and they use root user and root password when they publish the website I guess.

Troubleshooting Questions

You can use any pen test for troublesoothing this issue.

Resolution

You can use MySQL Workbench to:

  1. Create a new user account.
  2. Assign all necessary privileges to the new user account.
  3. Reflects changes in the wp-config.php and my.cnf.hbs
  4. Restart Local

You can watch the following video as reference for using MySQL Workbench which is free and much superior than HeidiSQL: How to Change MYsql Password Using MySQL Workbench - YouTube

I hope this helps. Jane

System Details

  • Local version 6.3.x

  • OS is not relevant

Security Reminder

Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

1 Like
2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.