SQL Help - Printable Version

SQL Help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQL Help (/showthread.php?tid=553707)

SQL Help - ManGoe - 31.12.2014

[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

Re: SQL Help - ManGoe - 31.12.2014

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

Re: SQL Help - amirab - 31.12.2014

can you explain this ? why it has 2 @ ?

Код:

root'@'@localhost

Re: SQL Help - BroZeus - 31.12.2014

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"

Re: SQL Help - Lordzy - 31.12.2014

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.

Re: SQL Help - ManGoe - 31.12.2014

Removed.

Re: SQL Help - ManGoe - 31.12.2014

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;



?>

Re: SQL Help - ManGoe - 31.12.2014

Quote:

Originally Posted by amirab

can you explain this ? why it has 2 @ ?

Код:

root'@'@localhost

Re: SQL Help - Vince - 31.12.2014

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/

Re: SQL Help - ManGoe - 31.12.2014

Testing bro.