Multiple Users

[John Round]

Hi,

I was just wondering how to have multiple users in mySQL. I want them to only access their database, and I also need to know what rights I should give them.

They must only be able to access their database and nobody elses :)

TIA
John

[eva2000]

Originally posted by John Round
Hi,

I was just wondering how to have multiple users in mySQL. I want them to only access their database, and I also need to know what rights I should give them.

They must only be able to access their database and nobody elses :)

TIA
John take a read http://www.mysql.com/doc/U/s/User_Account_Management.html ;)

[John Round]

Bit hard ;)

Any guides for using phpmyadmin?

[Steve Machol]

The best advice I can give is to make sure you have an up-to-date backup prior to doing anything with phpMyAdmin. It's just too easy for an inexperienced user to mess up the database with it.