So you really shouldn't be using DB privileges different from the default DB privileges recommended by the manual, unless you know what you're doing, have very specific needs, and won't forget your have custom DB privileges. If your setup miss any DB privileges, you may run into issues as you upgrade WordPress and add more plug-ins. The WordPress source code (both present and future) assumes the WordPress DB user has all DB privileges for the given WordPress database. Even on a production site, you shall try stick to the user manual.Īs someone who contributes code to WordPress core and a few plug-ins, I recommend you retain the default DB privileges as suggested in the user manual ( GRANT ALL PRIVILEGES ON wpdatabasename.* TO ). My opinion is the same as above, as well as the sources he referenced: GRANT ALL is necessary in ensuring your site is functional and future proof. Only major point upgrades (3.7 to 3.8, forĮxample) will alter the schema. Screens will then detect the old version and allow you to run the Return it back to that old version and the WordPress administration To an old version, granting the proper permissions, and then letting A failedĭatabase upgrade can usually be solved by restoring the database back You have tested are valid and that can be easily restored. This for security reasons, then please make sure that you have a solidīackup plan in place first, with regular whole database backups which Problems when database schema changes occur. Perhaps "CREATE" should be added to the list? Does anyone have information regarding this? - using Hostgator cPanel, March 2016 -)Īttempting updates without having these privileges can cause (Edit: I notice however that I DO NOT SEE "GRANT" in the list of privileges anymore when creating or updating a user. Type '\c' to clear the current input statement.Regarding the "Note" in redburn's post, the Wordpress Codex also has a Warning you should also read about updates and database schema changes. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Login to MySQL shell with newly created user and password. You can also view the allowed permission to a user in MySQL. * TO ' all priviledges to on specific database including permissions to grant other users. mysql> GRANT SELECT,INSERT,DELETE ON dbname. * TO ' the following option to grant specific permissions like SELECT,INSERT,DELETE on a specific database to. Use the following option to grant all privileges on specific database to. GRANT OPTION -Allow user to grant or remove other user privileges.ALTER – Allow user to alter the structure of a table or to create triggers on a table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |