1,106
edits
FeministWiki:Server setup: Difference between revisions
→Recreate SQL users
Technician (talk | contribs) |
Technician (talk | contribs) |
||
| Line 222: | Line 222: | ||
If the versions of MariaDB on the old and new server are compatible enough, you might be able to dump the {{C|mysql.user}} table and import it on the new server, but it's safer to recreate the users from scratch. To do so, run this on the new server: | If the versions of MariaDB on the old and new server are compatible enough, you might be able to dump the {{C|mysql.user}} table and import it on the new server, but it's safer to recreate the users from scratch. To do so, run this on the new server: | ||
sql << EOF | /root/bin/sql << EOF | ||
create user blogs@localhost identified by '$(cat ~/pwd/mysql-blogs)'; | create user blogs@localhost identified by '$(cat ~/pwd/mysql-blogs)'; | ||
grant all on blogs.* to blogs@localhost; | grant all on blogs.* to blogs@localhost; | ||