919
modifications
« FeministWiki:Server setup » : différence entre les versions
→Recreate SQL users
| Ligne 222 : | Ligne 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; | ||