Two passwords

I have two databases in mySQL.

The first database is named "onlyMe".
The second database is named "together".

I can access to the databases with ID "root" and password "1111".
at the moment.

Can I make the password of "onlyMe" is "1111", and the password of "together" is "2222".



I like to access to "onlyMe" exclusively, and I like to access to "together" with one of my cooporative potential partners.

Can I make it possible?

I don't understand what is your problem, try to be more specific.

Hi,

you will not be able to use two passwords for the same ID. You may create a new ID and then give the appropriate rights to this new account. The following chapter of the manual may suit your needs:


http://dev.mysql.com/doc/mysql/en/Adding_users.html

I meant two IDs.

I admit I wrote poorly about my problem.

It's not because I wrote it careless. but it it's because I didn't know what's the key point in my problem.

I've solved my problem now.

anyway thank you