Haack's Wiki

User Tools

Site Tools

Trace:
computing:migratewp

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
computing:migratewp [2019/12/30 02:37] – oemb1905computing:migratewp [2022/01/29 01:06] – oemb1905
Line 41: Line 41:
   EXIT;   EXIT;
   CREATE USER 'newdatabaseuser'@'%' IDENTIFIED BY 'temporarypassword';   CREATE USER 'newdatabaseuser'@'%' IDENTIFIED BY 'temporarypassword';
-  GRANT ALL PRIVILEGES ON *.* TO 'newdatabaseuser'@'%' WITH GRANT OPTION;+  GRANT ALL ON newdatabase.* TO 'newdatabase'@'localhost' IDENTIFIED BY 'temporarypassword';
      
 Now, you need to create databases and grant privileges to the surrogate user for each of them.  You do this as follows: Now, you need to create databases and grant privileges to the surrogate user for each of them.  You do this as follows:
computing/migratewp.txt · Last modified: 2022/09/03 23:11 by oemb1905

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
GNU Free Documentation License 1.3 Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki