#likept | Explore Tumblr Posts and Blogs

vanimeiy · 1 year

Text

#0612 #bright #film photography #likept

4 notes · View notes

knicksspindicate · 5 years

Photo

BBALLBREAKDOWN: The New Frank Ntilikina Gives Knicks Fans Playoff Hope by Likept https://www.reddit.com/r/NYKnicks/comments/d97bzh/bballbreakdown_the_new_frank_ntilikina_gives/?utm_source=ifttt

#knicks #nyKnicks #nba

0 notes

globalmediacampaign · 4 years

Text

How To Restore MySQL Users And Passwords During Migration

In any MySQL replication or migration, generally, we’ll skip the mysql database from the dump file. Since it has the current server’s settings, users, etc. So we should not create a mess on the target server with this source mysql database dump. But one downside of this approach is we’ll not get the users on the target MySQL server. Maybe you tried some approaches that are mentioned here. But whenever I don’t the credentials list during the migration and don’t have time to explore/install any tools likept-show-grants, then I’ll use this trick. DISCLAIMER You should try this approach when you don’t any user credentials on the source DB. Take a backup of the MySQL database on the target DB side. Do this with your DBA’s help. And it is tested in MySQL 5.6 and 5.7 Step #1: Get the grant: -- Get grants mysql -h SOURCE_DB_IP_ADDRES -u root -p'PASSWORD' --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user''" | mysql -h IP_ADDRES -u root -p'PASSWORD' --skip-column-names -A | sed 's/$/;/g' > user_grants.sql -- clean up the password field sed -i 's/IDENTIFIED BY PASSWORD //g' user_grants.sql Step #2: Generte create user statement: -- MySQL 5.6 mysql -h source_DB -u root -p'password' --skip-column-names -A mysql -e "SELECT Concat('create user '', user, ''@'', host, '' IDENTIFIED WITH 'mysql_native_password' AS '', password,'';') FROM mysql.user where user not in ('mysql.session','mysql.sys','debian-sys-maint','root');" > create_user.sql -- MySQL 5.7 mysql -h source_DB -u root -p'password' --skip-column-names -A mysql -e "SELECT Concat('create user '', user, ''@'', host, '' IDENTIFIED WITH 'mysql_native_password' AS '', authentication_string,'';') FROM mysql.user where user not in ('mysql.session','mysql.sys','debian-sys-maint','root');" > create_user.sql Step #3: Restore the users: mysql -u target_db_ip -u root -p myqsl https://thedataguy.in/how-to-restore-mysql-users-passwords-during-migration/

0 notes

vanimeiy · 1 year

Text