[ManGoe]

[08:31:00] [MySQL] Error (0): Failed to connect. Access denied for user: 'root'@'@localhost' (password: YES).
[08:31:00] MySQL Connection not established!
Help me please.
And i also tried the host to be 127.0.0.1

[ManGoe]

Any reply? I am running that mYsql in wampserver and all services are on + working fine but cant connect.
Help me +rep

[amirab]

can you explain this ? why it has 2 @ ?

Код:

root'@'@localhost

[BroZeus]

Not sure but try this -
-> Go to C:\wamp\apps\phpmyadmin4.1
-> Open file named config.inc or config.inc.php with notepad
-> Find line $cfg['Servers'][$i]['password'] =";, replace this line with $cfg['Servers'][$i]['password'] = ' ';

If this doesn't work then go to ****** and type "how to reset mysql root pass wamp server"

[Lordzy]

Go to your wamp path's root/apps/phpmyadmin_* and open config.inc.php. Find $cfg['Servers'][$i]['password'] = ”; and replace it with your password, also find and edit $cfg['Servers'][$i]['AllowNoPassword'] = true and replace it with false. After doing all these, restart all the services.

EDIT : Late.

[ManGoe]

Removed.

[ManGoe]

PHP код:

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use setup/
 *
 * All directives are explained in documentation in the doc/ folder
 * or at <http://docs.phpmyadmin.net/>.
 *
 * @package PhpMyAdmin
 */
/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = 'a8b7c6d'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
/*
 * Servers configuration
 */
$i = 0;
/*
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
/*
 * phpMyAdmin configuration storage settings.
 */
 
// No warning on  pmadb tables
$cfg['PmaNoRelation_DisableWarning'] = true;
?>

[ManGoe]

Quote:

Originally Posted by amirab can you explain this ? why it has 2 @ ? Код: root'@'@localhost

For information
I use this .inc
SA:MP MySQL v2.1 Functions
* © Copyright 2011, StrickenKid

[Vince]

Set up a separate account for the SA-MP server. Don't use root. Not even for testing. Root is reserved for administrative tasks. Also you will need a password regardless of which user is used otherwise the plugin simply won't work. Doesn't matter if it's something simple like '123' or 'admin' or 'password' because it's only for testing and it's easy to remember. Goes without saying that you choose a strong password when you put it into production.

http://www.random.org/passwords/

[ManGoe]

Testing bro.