SuSe Logins and mySql

mindjet · 04-21-2006, 08:44 PM

Hey, how can i link my suse logins to the mysql server?

i want i can have a database per user and each can have their own phpMyAdmin with view to only their database.
Sorry if this has been covered already, i searched but didn't find it.

I think it's prob a security risk if opened up onto the web now because the user databases connect with root mysql password!

leandean · 04-21-2006, 11:33 PM

Please see this article regarding logins::

http://dev.mysql.com/doc/refman/4.1/en/user-names.html

You can grant permissions to individual databases. Only the user you grant said permissions to will be able to access that database. It would be something like::

grant select,insert,delete,etc. on mydb.* to 'johndoe'@'localhost' identified by 'passwordgoeshere';

Use .htaccess for phpMyAdmin security. That way only people with user/pass can access the db via phpMyAdmin and will only be able to see 'their' database.

mindjet · 04-23-2006, 07:04 AM

Thanks for taking the time to point me in the right direction.