Where Have My Users Gone?

[gutterboy]

Hey guys… I recently reinstalled Windows & hence had to reinstall SQLYog…. upon getting everything working again I opened up SQLYog & have all my old databases there & everything but when I go to the User Privleges menu the only users I see are.. root & pma.

I have a backup of all my SQLYog/MySQL/Application Data from my old installs….. could anyone tell me where to find this info so I can restore it?

Thanks!

[peterlaursen]

I think you are confused about what is stored client-side (with SQLyog) and server-side (with MySQL). MySQL users are stored server-side (in the mysql.user table). . You may execute (with any client)

Quote:

SELECT user, host from mysql.user

.. to see what users the MySQL server knows currently. SQLyog knows what the server knows – nothing more and nothing less.

If you have reinstalled MySQL on your local system, MySQL users-list have been reset . “the only users I see are.. root & pma” Looks like you did a fresh install of XAMPP or another 'bundled' MySQL distribution. 'pma' is not a user installed with official MySQL binaries (but with 'bundles' including phpMyAdmin only). You may install MySQL from http://www.mysql.com, Apache from http://www.apache.org and PHP from http://www.php.net instead of this 'bundle' (but nothing wrong with XAMPP or whatever – only it is difficult to upgrade a single component of the WAMP stack if you should want). 

SQLyog will query the server about user accounts information.  It does not (and cannot) have this information 'client-side'. User tables are stored by the server – not the client. If you have reinstalled Windows + MySQL you have deleted the users installed in MySQL – unless you backed up the 'mysql' database.

If you reinstall Windows + your Word Processor you will also lose everything unless you backed up your documents. What do you expect when you reinstall the OS? 

[gutterboy]

Yes… I realized that this had nothing to do with SQLYog after I posted it, but just thought I would leave the post anyway as maybe you would be able to guide me on where to find the users.

Quote:

SQLyog will query the server about user accounts information. It does not (and cannot) have this information 'client-side'. User tables are stored by the server – not the client. If you have reinstalled Windows + MySQL you have deleted the users installed in MySQL – unless you backed up the 'mysql' database.

If you reinstall Windows + your Word Processor you will also lose everything unless you backed up your documents. What do you expect when you reinstall the OS?

Well as I said above, I did make a backup of everything…. I was just wanting to find out where the user information was stored so I could restore it all… you mentioned the mysql database….. I actually did restore that folder but still didn't get my users back….. maybe I did something wrong…. I will try again.

Thanks! 🙂

[peterlaursen]

if you have a (file-based) backup of you mysql data folder, you can simply copy the …mysqluser folder and restart MySQL.  This can be done for MyISAM tables like this (and the 'mysql' database is solely MyISAM tables).

[gutterboy]

'peterlaursen' wrote on '28:

if you have a (file-based) backup of you mysql data folder, you can simply copy the …mysqluser folder and restart MySQL.  This can be done for MyISAM tables like this (and the 'mysql' database is solely MyISAM tables).

Hey there…… yeah, I tried this before but MySQL wouldn't start…. but ended up figuring out all I needed to copy over was the db.* & user.* files. 🙂

Thanks for your help!

[Author]

Posts