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.
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:
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