MySQL users and permissions

  • Hi folks,

    Trying to understand a concept from “Professional WordPress Design and Development” :

    In theory, MySQL setup for WordPress is trivial: Make sure MySQL is up and running, create a WordPress user in MySQL, and then have that user create a database to hold the WordPress tables. You can use the MySQL command line or tools such as phpMyAdmin or Chive for these tasks, but bear in mind that MySQL has its own set of users and permissions granted to those users, distinct from those used by your (or your hosting provider’s) operating system.

    1. What is a ‘WordPress user in MySQL’ ? I am using mamp, and as my understanding , there ir only one ‘MySQL server user and password’ which is usually ‘root’ and ‘root’. I don’t understand where does the ‘WordPress’ term fit in the MySQL server.
    2. “but bear in mind that MySQL has its own set of users and permissions granted to those users, distinct from those used by your (or your hosting provider’s) operating system.” –> Again… doesn’t MySQL comes with one username and password, which are ‘root’ and ‘root’ ? what ‘set of users’ does the author is referring to ? Distinct from me and my hosting provider? Don’t get this in any way…

      Will appreciate some light here….

Viewing 1 replies (of 1 total)

  • As a WordPress developer testing under localhost there is not much for you to worry about, understanding that there is a database user called root with password either root or empty is sufficient.

    What is happening is that in a generalised web hosting environment there can be many distinct websites, each with their own database. Different websites have different owners and managers. The operating system restricts access to different website files by assigning them to different logins, each with its own name and password, it also manages access to databases by also having various permissions restricted to a different set of usernames and passwords. Pt 2 above is trying to explain that the computer file access userlogin and password are distinct from the database users and passwords. It is easy to get confused when it is your computer and you are the only person using it, that these are still distinct concepts and identities.

    Be aware that when you move beyond using localhost and subscribe to shared hosting etc, that these points become more relevant.

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL users and permissions’ is closed to new replies.

Tags