User Tools

Site Tools


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 revision
Previous revision
Next revisionBoth sides next revision
computing:migratewp [2019/08/17 20:06] 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:
Line 67: Line 67:
     DROP USER 'newdatabaseuser'@'localhost';     DROP USER 'newdatabaseuser'@'localhost';
  
- --- //[[netcmnd@jonathanhaack.com|oemb1905]] 2019/06/15 23:42//  + --- //[[jonathan@haacksnetworking.com|oemb1905]] 2019/12/30 02:37//
      
computing/migratewp.txt · Last modified: 2022/09/03 23:11 by oemb1905