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??
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 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
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.
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
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
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
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
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
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
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?
# ls
11 matches
Mail list logo