ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login
    1. Topics
    2. Tags
    3. wp
    Log in to post
    • All categories
    • JaredBuschJ

      WP-CLI and database users

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion wp-cli wp wordpress security
      26
      0 Votes
      26 Posts
      2k Views
      1

      @JaredBusch said in WP-CLI and database users:

      @Pete-S said in WP-CLI and database users:

      @JaredBusch said in WP-CLI and database users:

      @Pete-S said in WP-CLI and database users:

      And when you use -e you should have it after user and password so the SQL commands you want to execute comes after the -e.

      That was a once off artifact of me doing it on this system after the root password has been set.

      OK, so maybe this then:

      sudo mysql -e "CREATE USER $DB_USER@localhost IDENTIFIED by '$DB_PASS';" sudo mysql -e "GRANT ALL ON $DB_NAME.* TO $DB_USER@localhost;" sudo mysql -e "FLUSH PRIVILEGES;"

      right. Updating the guide. but half tempted to leave the single quotes everywhere it that causes no error in order to protect against spaces by others. Though I am using pwgen to to this.

      It's kind of f*cked up to have spaces in user names and passwords. Personally I don't use something unless it's specifically needed but either way works.

    • wrx7mW

      WordPress - Plugins to Manage and Extend User Roles/Permissions

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion wordpress wp wp-admin permissions roles website plugins plugin
      40
      1 Votes
      40 Posts
      2k Views
      S

      @IRJ You are passionate about computers, you love to write code. Well, what's more exciting than being able to create your own plugins.

      When you know that WordPress is today one of the most used CMS on the web, it would be really interesting to see how a plugin is made and to be able to create it yourself. [Check it here] (http://bit.ly/2KxPChJ)

    • 1 / 1