Importing users and privileges once again

This topic is empty.

Viewing 9 reply threads

Author

Posts
- April 25, 2005 at 3:26 pm #8938
  
  turigeza
  Member
  
  Sorry I'm newbie I just wanted to clarify something …
  
  When I syncronize two databases on different hosts are USER privileges (global and also DB/table level) and USER details (name password) syncronised too!???
  
  Thank you for helping !
  
  Regards
  
  Geza Turi
- April 25, 2005 at 3:46 pm #17521
  
  peterlaursen
  Participant
  
  No!
  
  Users and their privileges are stores in the DB named “mysql”.
  
  The sync tool only syncronizes the table data in the tables/columns you specify.
  
  Try viewing (probably you must be ROOT) the “user” table in the “mysql” database, and you'll se what I mean.
  
  I YOU have the privileges then in principple tou could syncronize the relevant tables within the “mysql” DataBase
  
  (tables “user” “user_info “columns_priv” and so on. But don't do that if the mySQL versions are not the same, since the format of these tables varies with different version.
- April 25, 2005 at 4:19 pm #17522
  
  turigeza
  Member
  
  Of course:))
  
  Thank you very much !!
  
  Geza
- April 25, 2005 at 4:32 pm #17523
  
  turigeza
  Member
  
  Maybe it would make a nice product feature !? To be able to transfer users and their previleges to a different server. You would of course need to have the right previleges to do this but least mysqlyog could keep track of the different versions of mySQL servers and transfer data accordingly!?
  
  ?
  
  If you think it's any good I could post it on the relevant forum. I would find it very useful!
  
  Kind Regards
  
  Geza
- April 26, 2005 at 12:49 am #17524
  
  peterlaursen
  Participant
  
  By the way I don't think you will be able to transfer passwords at all (sync or any other method).
  
  Passwords are encrypted in the base.
- April 26, 2005 at 9:06 pm #17525
  
  turigeza
  Member
  
  I don't know what encrypted “in the base” means. 🙂 Sorry!
  
  As far as I know if you type the same passwords for two different user the encripted version is the same. I don't see why it wouldn't work.
  
  In my case the two MySQL server is different version so I'm not going to mess about with it. But I just thought it would be great feature of the product if it was able to transfer users as well as databases 🙂
  
  ?? Do you not think so ?
  
  Geza
- April 26, 2005 at 9:43 pm #17526
  
  peterlaursen
  Participant
  
  I'm not sure..
  
  But probably the KEY used for encrytion is different with different MySQL installations.
  
  It's quite simple to test it if you have two servers. Make two identical user on each, SHOW the password and compare.
  
  It would be bad security if Passwords were portable.
- April 28, 2005 at 2:06 am #17527
  
  Ritesh
  Member
  
  Transferring user/db privileges between two MySQL DBs is not good from security point of view. Doing this would require modification of the MySQL system tables which is not recommended.
  
  Also, MySQL keeps changing their User privilege system from version to version therefore making the above option very dangerous.
- April 30, 2005 at 9:49 pm #17528
  
  turigeza
  Member
  
  Fair enough …. Just want thank you for your help!
  
  R.
  
  Geza Turi
- May 3, 2005 at 12:05 pm #17529
  
  Shadow
  Member
  
  MySql does not encrypt passwords, it merely creates a hash and stores that instead of password.
Author

Posts