phpmyadmin?

Question

i am tring to set up a database but to do that i need to login i never created a username and password and it is not an option to do so and there is no forgot password username

so how do i find it
?

Answer 1

OK one question first, is this on your own machine or an internet server somewhere else? If it is your own machine you have to setup MySql with a username and password when you instal it. Then when you run phpMyAdmin you use that username and password to allow myadmin to run.

If the MySql is on a server that you do not have root account you will have to have your host setup your username and password first. (Or if you have Cpanel, WHM, Etc you can do that from the panel.)

Answer 2

In the directory that has your PHPMyAdmin software, there is a file called config.inc.php. Your name and password will be listed as follows:

$cfg['Servers'][$i]['user'] = 'username'; //MySQL user
$cfg['Servers'][$i]['password'] = 'password'; //MySQL password (only needed with 'config' auth_type)

These values should be down a fair ways, so you may need to search for the keys.

Answer 3

I have used PHPMyAdmin in the past but I like MySQL Control Center, which you can download from htt://www.mysql.com. I think it even comes bundled with the new releases of MySQL. I think it works faster and has a more efficient user interface.