neat trick with symbolic link!

[sfullman]

did you know you can do a symbolic link in linux for your database?

#cd /var/lib/mysql
#ln -s cpm177 cpm177b

this creates a "mirror" of database cpm177 called cpm177b.

you can then do this:
grant all privileges on cpm177b.* to cpm177b@localhost identified by 'someone-else';

I have a website/database system where the linux username is what the system looks for as the database. with this I can have two sites depend on the same database.

just thought that was cool and worth sharing!

[Weedpacket]

bradgrafelman wrote:

Nothing unique to *nix, you can do the same in Windows.

Yup:

fsutil hardlink create c:\path\to\new\name c:\path\to\existing\file

[dagon]

two names for the same thing are not a mirror. they are a maintenance nightmare.

[Weedpacket]

sfullman wrote:

where the linux username is what the system looks for as the database

This would only make sense if there was a guaranteed 1:1 relation between linux users and databases. As soon as one user has two databases or one database has two users, kludges like this happen. Users are not databases.