hello all have a error please help [Solved]

[lvlasked]

right im compeletly new to this xampp stuff i downloaded it and installed it i then open the controll panel and click start and they both say RUNNING when i click the admin bottom for the mysql thing i get

MySQL said:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

and i have no idea why would reali like to get it working thanks

[hackattack142]

You can try binding it to localhost as this sometimes fixes that issue.

Open your my.ini file (/xampp/mysql/bin/my.ini) and change

Code: Select all

#bind-address="127.0.0.1"

to

Code: Select all

bind-address="127.0.0.1"

and restart MySQL if it is running.

Now, make sure to also manually refresh that phpMyAdmin page so you do not load a cached error page.

[lvlasked]

now im getting this

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\log.php on line 28
100,database connection error

[lvlasked]

any help be good please

[hackattack142]

I take it that is a file you added manually? Did you set a root password (it is not set by default)? You will need to check the connect statement in that file to make sure it is trying to use the right password for what is set on the server.

[lvlasked]

i tryed to sewt a password but now i get this


MySQL said:
Cannot connect: invalid settings.

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.

and and i dunno witch php file to edit it to sto any help

[lvlasked]

forgot to mention thats when i click the admin botton in on the control panel and it opens a page up in my browser then i get that message some up

[hackattack142]

Try opening up your /xampp/phpmyadmin/config.inc.php file and change

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'config';

to

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'cookie';

[lvlasked]

thanks mate but i sorted before your reply but thank you every much