Re: upgraded 6.2 and mysql lost all privileges

In the last episode (Mar 06), Noah said: > okay you got me on the right track. > I can see mysql files in that directory. but mysql is not aware of the > users in the "user files" > > is there something that I need to tell to mysql to use those files to > reincorporate the mysql related users?

Re: upgraded 6.2 and mysql lost all privileges

I dont think that is the issue. the problem is with the mysql virtual users they do not appear in the /etc/passwd or /etc/master.passwd files. so that is the wrong direction. cheers, Noah Steve Bertrand wrote: In the last episode (Mar 06), Noah said: yeah - I have about 15 other user accou

Re: upgraded 6.2 and mysql lost all privileges

In the last episode (Mar 06), Noah said: yeah - I have about 15 other user accounts specific to my mysql installation that were not in the /etc/passwd file. where were those stored? If you're just talking about mysql users, those are in /var/db/mysql/mysql/user.* . An OS upgrade shouldn't hav

Re: upgraded 6.2 and mysql lost all privileges

Dan, okay you got me on the right track. I can see mysql files in that directory. but mysql is not aware of the users in the "user files" is there something that I need to tell to mysql to use those files to reincorporate the mysql related users? # ls -l /var/db/mysql/mysql total 648 -rw-

Re: upgraded 6.2 and mysql lost all privileges

binary install. okay I backed up teh dir let me look for them now cheers, Noah Dan Nelson wrote: In the last episode (Mar 06), Noah said: yeah - I have about 15 other user accounts specific to my mysql installation that were not in the /etc/passwd file. where were those stored? If you'r

Re: upgraded 6.2 and mysql lost all privileges

In the last episode (Mar 06), Noah said: > yeah - I have about 15 other user accounts specific to my mysql > installation that were not in the /etc/passwd file. where were those > stored? If you're just talking about mysql users, those are in /var/db/mysql/mysql/user.* . An OS upgrade shouldn't

Re: upgraded 6.2 and mysql lost all privileges

thanks Vince, yeah - I have about 15 other user accounts specific to my mysql installation that were not in the /etc/passwd file. where were those stored? Cheers, Noah Vince Hoffman wrote: user accounts are held in /etc/passwd the default UIDs created by ports are listed in /usr/ports/U

Re: upgraded 6.2 and mysql lost all privileges

user accounts are held in /etc/passwd the default UIDs created by ports are listed in /usr/ports/UIDs including mysql mysql:*:88:88:MySQL Daemon:/var/db/mysql:/sbin/nologin you can either re-add it using pw or just paste the line in using vipw Vince Noah wrote: > the user accounts are gone. whe

Re: upgraded 6.2 and mysql lost all privileges

the user accounts are gone. where does that information reside? I dont know how else to say or ask that question. Cheers, Noah Björn König wrote: Noah schrieb: Hi there, I just upgraded to 6.2 and now I do not see my mysql privileges. is there an easy way to get them back in place. I

Re: upgraded 6.2 and mysql lost all privileges

Noah schrieb: Hi there, I just upgraded to 6.2 and now I do not see my mysql privileges. is there an easy way to get them back in place. I thought they would magically appear in the /var/db/mysql directory and stuff. Is there an easy way to recover these accounts or do I need to readd the

upgraded 6.2 and mysql lost all privileges

Hi there, I just upgraded to 6.2 and now I do not see my mysql privileges. is there an easy way to get them back in place. I thought they would magically appear in the /var/db/mysql directory and stuff. Is there an easy way to recover these accounts or do I need to readd them manually??