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

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

Answer 2

In your situation, it is highly likely that the login you used to create the database can be used to access the database.

Answer 3

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 4

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