View Single Post
Old 17th August 2012, 21:13
dannypb dannypb is offline
Junior Member
Join Date: Oct 2011
Posts: 15
Thanks: 0
Thanked 4 Times in 3 Posts

oh also, btw.... this is really ugly, but i used this to add records to the mysql.user table and the other tables in the mysql database that were missing on the move. This script will not over write a database, table or record so I used it on the mysql database. I then ran:

update user set password = PASSWORD(user) where not user in('root','ispconfig');
flush privileges;

This added the permissions necessary for my users, resetting all of their passwords to their id (which they will be forced to change when we go live).

There may be some null fields that were missing in the insert, since I was going from mysql 4 to mysql 5, but it all seems to work so far, and I can certainly handle the changes later.

Be sure before you do this very stupid thing that you run the query:

select user from user;

and use that list of IDs for your "not user in" part of the password change update.
Reply With Quote