Now that I’m the nominal MySQL DBA for PSU, it became my job to jimmy up the MySQL user privileges so that the new web server could connect. I’m not sure if this is the fastest, most efficient way to do it, but it worked quickly enough:
CREATE TABLE mysql.user_copy SELECT * FROM mysql.user;
DELETE FROM mysql.user_copy WHERE Host NOT LIKE 'OLD_HOST_NAME';
UPDATE mysql.user_copy SET Host = 'NEW_HOST_NAME';
INSERT INTO mysql.user SELECT * FROM mysql.user_copy;
DROP TABLE mysql.user_copy;
CREATE TABLE mysql.db_copy SELECT * FROM mysql.db;
DELETE FROM mysql.db_copy WHERE Host NOT LIKE 'OLD_HOST_NAME';
UPDATE mysql.db_copy SET Host = 'NEW_HOST_NAME';
INSERT INTO mysql.db SELECT * FROM mysql.db_copy;
DROP TABLE mysql.db_copy;
FLUSH PRIVILEGES;
Simply replace the OLD_HOST_NAME and NEW_HOST_NAME with the appropriate values. Most importantly, I didn’t have to know the passwords for each user to do this. This script simply copied the user info and gave them access from the new server.
Posted August 14, 2008 by Casey Bisson
Categories: Technology. Tags: copy users, duplicate users, mysql, mysql users, privileges, users.
No Comments
No comments yet.
Comments RSS
TrackBack Identifier URI
Leave a comment
User contributed tags for this post:
WORLEDSEX (12) - bangladeshhotsex (11) - mysql copy users (10) - mysql copy privileges (8) - mysql copy user privileges (6) - mysql copy user (6) - mysql (6) - www.indiasexy.com (4) - www.best-teens.com (4) - BANGLADESHHOTSEX] (3) - sexsamera (2) - mysql backup user privileges (2) - za3ror (2) - wwwsexy (2) - www.za3ror.com (2) - copy user privileges mysql (1) - mysql usernames (1) - copy database user mysql (1) - mysql copy user database (1) - copy mysql users new server (1) - mysql copy user table (1) - mysql duplicate user (1) - mysql flush priveleges (1) - copy user, mysql (1) - copy user from my_sql to my_sql (1) - copy myasql user (1) - copy mysql users (1) - backup user privileges mysql (1) - copy privileges mysql (1) - mysql copy OR clone users (1) - sexv vedio (1) - WWW.BEST-TEENS (1) - www.89.ar.com (1) - mysql and select * from database where (1) - fastest way to update MySQL Table? (1) - MySQL privelege types (1) - copy users mysql (1) - how to update a table without copying-mysql (1) - mysql update priveleges (1) - teen worledsex (1) - copy users from mysql 4 to 5 (1) - mysql copy a user (1) - Copy mysql users to new server (1) - sex samera sex (1) -
