mysql phpmyadmin user password for database

Question

I am using phpMyAdmin; I created a database; now I want to locate the username and password for this new database I created. Note, I am not sys admin, I am only the developer, but I do have access to create db on MySQL in phpMyAdmin. Does my sys admin needs to tell me the username and password to access this db, or I can telnet and get it?

Answer 1

Steps for phpmyadmin GUI:

Select your Database name -> Privileges (here you can see your Privileges).

if you want change password click on the edit privileges icon in the action column

Answer 2

You can access that database with the user/password used to login on the phpMyAdmin.

You can also create new users (if you have permission to) under the tab Privileges > Add new User. Here you can create pairs of user-database with the same name and auto-permission-granting.

Answer 3

In MySQL creating a database doesn't automatically create a user to go with it. You must explicitly create the user and grant acess.

http://dev.mysql.com/doc/refman/5.1/en/adding-users.html