[SOLVED] PHP Myadmin problem

longstand · Nov 6th, 2007, 20:53

I recently installed XAMPP and i created a sql file database, imported it into PHP myadmin, and everythink went fine until i tried to go back into phpmyadmin, and i keep getting the following errors,

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Could someone please tell me were config.inc.php can befound??

Marc · Nov 6th, 2007, 21:10

It should be in this directory: C:\xampp\phpMyAdmin\config.inc.php.

Hope this helps!

longstand · Nov 6th, 2007, 21:14

It is were u said it would be but when i open the file the top line says,

/* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! */

So am confused

Marc · Nov 6th, 2007, 21:23

That must be an error, that's the file you are in!

longstand · Nov 6th, 2007, 21:58

Ok i have reinstalled XAMMP and it allowed me back into phpmyadmin, but the second time i tries to get back in i got this error again:

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

How exactly do i solve this problem

Marc · Nov 7th, 2007, 16:21

Is this your own PHP page? Are you trying to connect to the databse?

If you are, can i see your PHP connection data?

Cheers,

longstand · Nov 7th, 2007, 17:22

Hello Marc! How r u today?

Yer am trying to connect to my database that i have written myself and saved as a sql file called dbwikid, i open XAMMP control panel and load phpmyadmin, i also browsed to my sql file mentioned above and opened it using phpmyadmin and all queries came back ok, i then open dreamweaver and try to connect to the database, i use the setting below:

dbwikid

localhost

root

longstand

and then select my database, which is there but if u select it i get a messege explaining eye have password problems of some sort. Then after this i try to go back into phpmyadmin and i am barred out of the program, i the messege displayed in my last messege is displayed. Its a pain in the backside 2 b honest...

any suggestions...

Marc · Nov 7th, 2007, 17:35

Quote:

dbwikid

localhost

root

longstand

What are they, passwords, db names.. What?

dab42pat · Nov 7th, 2007, 17:44

ive had something similar.

the workaround is to open apache admin through the control panel, click on the security link (third link down i think),scroll down and click on
http://localhost/security/xamppsecurity.php

then set your password for your database.

this shoul get you in but you will be prompted for your password everytime you open up phpmyadmin.
Hope this helps.

longstand · Nov 7th, 2007, 20:32

Ok guys av loved me problem myself!!!

Here is the solution to the pesky Phpmyadmin homepage error!!

Below is the error:

Error
MySQL said:

#1045 - Access denied for user: 'root@localhost' (Using password: NO)

Below is the solution to fix the problem:

First, replace this line :

$cfg['PmaAbsoluteUri'] = '';

to the line typed below:

$cfg['PmaAbsoluteUri'] = 'localhost/phpmyadmin/';

This is to make disappear one of the error messages on phpmyadmin's homepage.

Now you just need to add your new password :

open config.inc.php and enter the same password you chosen when creating your privlegis in the phpmyadmin privleges page. The code below is located in the phpmyadmin folder and you enter your password were i have typed webforumz

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

Save your file and it's done...

You can now use this user with its new password in your php scripts.

Cheers

dab42pat · Nov 7th, 2007, 20:35

thanks for posting the solution.

longstand · Nov 7th, 2007, 20:38

No probs am just gutted i typed "loved" instead of "solved" in the top part of my solution!!!

DONT TYPE WHEN YER DRINKING BEER (its wrong i say)

Av added some rep for you both

Take it easy.