• Allgemeines
  • Migrate mySQL user to new server

    To mirgrate databases to a new server we need two things: User information (password, grants) the database In order to get the userinformation we need to execute the following query which returns a list of commands to show the users grants and encrypted passwords. SELECT DISTINCT CONCAT( ’show grants for ‚, user, ‚@‘, host, ‚;‘ […]