phpmyadmin issue - Page 2

[scorpionz]

Ok Guys i will
When i will reach home tonight after my office
I will first do this thing and let the things in your concern that what are the things happening now...
Thanks a lot u both guys
I will let u know at night.

Regards
Scorpion

[richie513]

No worries scorpionz, Good luck and here from you tonight:)

[scorpionz]

Hi Guys
How are u .. Hoping for your best fitness, now let me come straight to the point
first of all Hurrah!!! i got Login screen.... but how.... ?? let me share this knowledge with you guys too... here is my config file

$cfg[$i] = 'localhost'; // MySQL hostname or IP address
$cfg[$i] = ''; // MySQL port - leave blank for default port
$cfg[$i] = ''; // Path to the socket - leave blank for default socket
$cfg[$i] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg[$i] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg[$i] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg[$i] = 'pma'; // MySQL control user settings
// (this user must have read-only
$cfg[$i] = 'secret'; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg[$i] = 'cookie'; // Authentication method (config, http or cookie based)
$cfg[$i] = 'root'; // MySQL user
$cfg[$i] = 'root'; // MySQL password (only needed
// with 'config' auth_type)
$cfg[$i] = ''; // If set to a db-name, only
// this db is displayed in left frame
// It may also be an array of db-names, where sorting order is relevant.
$cfg[$i] = ''; // Verbose name for this host - leave blank to show the hostname

$cfg[$i] = 'phpmyadmin'; // Database used for Relation, Bookmark and PDF Features
// (see scripts/create_tables.sql)
// - leave blank for no support

Consider this line

$cfg[$i] = 'cookie'; // Authentication method (config, http or

if we replace above line with this:
$cfg[$i] = 'config'; // Authentication method (config, http or

then it will not give us login screen...
but finally i got it...Thanks After all
and important thing is that.... it is not login even i got the login screen.....
Please check this config file above i paste it....
and important thing....
I use to run localhost as
http://localhost:800/

not

http://localhost/

So also check ... if is there any problem in line of localhost,port... if any change there is required in config please let me know....

Thanks and Regards
Scorpion

[richie513]

Hi scorpionz, hey that's great news that you have a login screen. I know that the port that MySQL listens on is 3306, but don't change this. Your phpmyadmin needs to run from your apache, this should be listening on port :80. This is a default setting and you would not be getting the login screen if it wasn't listening on the port, so everything is fine there. Your should only type

"http://localhost/"

and not

"http://localhost:800/".

So just point your browser to http://localhost/ for now onwards. In this case to access phpmyadmin you would type, http://localhost/phpmyadmin.

Now for the login, Now since you have the config type from "config" to "cookie" you should be able to login with out a password for the root user.

But before attempting this, change this line:

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

to:

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

Note that I have removed the password! Now save the file and close it and then restart your apache.

Just try opening up your login page and type "root" without the quotes in the username and leave the password field empty. Then press login.

Something to note. phpmyadmin will not work with any other username or password until "root" has been fixed up. So this is what we need to concentrate on first. I found this out through the phpmyadmin site. Let us know how you go:)

[scorpionz]

Great and Great Great!!!
first of all the important things tat has to be mention here is that....
Richie the things you mention here are absolutely perfect and

Important points too

1- phpmyadmin should not be run like http://localhost:800/phpmyadmin.
It must be always http://localhost/phpmyadmin... and should be always not any other too....

2- Richie said in last post
" the port that MySQL listens on is 3306, but don't change this. Your phpmyadmin needs to run from your apache, this should be listening on port :80"

Point no 2 absolutely correct....

3-The user: root .... must always have an empty password... at first run...

That is all ....
Now First of all Thanks to Both of you Richie and Naveen... and me too i am in this thread too haha
Finally I got enter into phpmyadmin
and I think this thread is now very important, that it has got so much knowledge.
What u both say Naveen and Richie?

After all Thanks

Regards
ScorpionZ

[richie513]

Congrats scorpionz!! That is great news. And yes I agree about the thread, I think we covered just about every possible solution. So if someone can't get there phpmyadmin running after reading right through this thread, then a re-install of both MySQL and phpmyadmin will be in order lol. Once again scorpions , that is absolutly great news:):)

[nav33n]

:) lol.. congrats ! finally the problem is solved!