PDOException #1045 SQLSTATE[28000] [1045]…

Zdravím,
Som už na konci síl nedokážem sa nijak pripojiť na DB vždy mi vyhodí chybu:

**PDOException #1045**
**SQLSTATE[28000] [1045] Access denied for user 'vp_username'@'10.10.29.10' (using password: YES)**

Viem, že sa to už riešilo ale ani to mi nepomohlo

Toto je môj config.neon schválne som vytvoril prihlasovacie údaje do db s heslom 123456 ale nijak nepomohlo.
Porovnával som všetky moje súbory so súbormy v sandboxe všetko je ako má už fakt neviem kde robím chybu.

#
# SECURITY WARNING: it is CRITICAL that this file & directory are NOT accessible directly via a web browser!
#
# If you don't protect this directory from direct web access, anybody will be able to see your passwords.
# https://nette.org/en/security-warning
#
common:
	parameters:

	php:
		date.timezone: Europe/Prague
		# zlib.output_compression: yes

	nette:
		application:
			errorPresenter: Error

		database:
			dsn: 'mysql:host=localhost;dbname=vp_dbname'
			user: 'vp_username'
			password: '123456'

		session:
			expiration: 30 days


	services:
		authenticator: Authenticator
		routerFactory: RouterFactory
		router: @routerFactory::createRouter


	factories:


production < common:

development < common:

Môj Authenticator

<?php
use Nette\Security as NS,
    Nette\Utils\Strings;
/**
 * Select DB
 * Check connect
 */
class Authenticator extends Nette\Object implements NS\IAuthenticator
{
	/** @var Nette\Database\Connection */
	private $database;
	/**
	 * Construct Function DB Connect
	 * @return Nette\Database\Connection
	 */
	function __construct(Nette\Database\Connection $database)
	{
		$this->database = $database;
	}
	/**
	 * Performs an authentication.
	 * @return Nette\Security\Identity
	 * @throws Nette\Security\AuthenticationException
	 */
	function authenticate(array $credentials)
	{
		list($username, $password) = $credentials;
		$row = $this->database->table('users')->where('username', $username)->fetch();
		if(!$row)
		{
			throw new NS\AuthenticationException("Užívateľ '$username' nejnájdený", self::IDENTITY_NOT_FOUND);
		}
		if($row->password !== $this->calculateHash($password, $row->password))
		{
			throw new NS\AuthenticationException('Neplatné heslo', self::INVALID_CREDENTIAL);
		}
		unset($row->password);
		return new NS\Identity($row->id, NULL, $row->toArray());
	}
	/**
	 * Computes salted password hash.
	 * @param  string
	 * @return string
	 */
	public static function calculateHash($password, $salt = NULL)
	{
		if ($password === Strings::upper($password)) { // perhaps caps lock is on
			$password = Strings::lower($password);
		}
		return crypt($password, $salt ?: '$2a$07$' . Strings::random(22));
	}
}

A ešte moj AuthPresenter nie je síce dokončený pre registráciu ale prihlasovanie by malo fungovať

<?php
use Nette\Application\UI\Form,
    Nette\Utils\Html;
/**
 * Display Login & LogOut Form
 * @return Nette\Application\UI\Form
 */
class AuthPresenter extends BasePresenter
{
	/**
	 * Create a Form
	 * Display form in Template
	 */
	protected function createComponentLoginInForm()
	{
		$form = new Form;
		$form->addText('username', 'Prezývka:')
		     ->setRequired('Musíte zadať prezývku!', Form::FILLED);
		$form->addPassword('password', 'Heslo:')
		     ->setRequired('Musíte zadať heslo!', Form::FILLED);
		$form->addCheckBox('remember', 'Zapamätať si ma');
		$form->addSubmit('login', 'Prihlásiť');

		$form->onSuccess[] = $this->loginInFormSubmitted;
		return $form;
	}
	/**
	 * Check is User Success Login
	 * if is Success Login @return loginInFormSubmitted
	 */

	public function loginInFormSubmitted(Form $form)
	{
		try {
        $user = $this->getUser();
        $values = $form->getValues();
        if ($values->remember)
        {
            $user->setExpiration('+30 days', FALSE);
        }
        $user->login($values->username, $values->password);
        $this->flashMessage('Přihlášení bylo úspěšné.', 'success');
        $this->redirect('Homepage:');
    } catch (Nette\Security\AuthenticationException $e) {
        $form->addError('Neplatné uživatelské jméno nebo heslo.');
    }
	}
	/** Out Form */
	public function handleLogOut()
	{
		$this->getUser()->logout();
		$this->redirect('Index:index');
	}
	/**
	 * Create Register Form
	 * Display form in Template
	 */
	protected function createComponentRegisterInForm()
	{
		$form = new Form;
		$form->addText('username', 'Prezývka:')
		     ->setRequired('Musíte zadať prezývku!');
		$form->addPassword('password', 'Heslo:')
		     ->setRequired('Musíte zadať heslo!');
		$form->addText('email', 'Email:')
		     ->setRequired('Musíte zadať emailovú adresu')
		     ->addRule(Form::EMAIL, 'Nesprávne zadaná emailová adresa');
		$gen = array('m' => 'Muž', 'f' => 'Žena');
		$form->addRadioList('gander', 'Pohlavie:', $gen);
		$countries = array(
			'Europe' => array(
                'SK' => 'Slovensko',
                'CZ' => 'Česko',
                'HU' => 'Maďarsko'
				),
			'USA' => 'Spojené Štáty Americké'
			);
		$prompt = Html::el('option')->setText('Krajina')->class('prompt');
		$form->addSelect('country', 'Krajina:', $countries)
		     ->setPrompt($prompt);
		$form->addCheckBox('agree')
		     ->setOption('description', Html::el('span')
		     ->setHtml('Súhlasím s <a href="../docs/ListTerms">Podmienkamy</a>'))
		     ->addRule(Form::EQUAL, 'Musíte súhlasiť s podmienkamy!', TRUE);
		$form->addSubmit('subreg', 'Registrácia');
		$form->onSuccess[] = $this->registerIsSuccess;
		return $form;
	}
	/**
	 * If the value of the form sent to the correct
	 * Return a report on user success and redirect
	 * @return Success Page
	 */
	public function registerIsSuccess()
	{
		/** This @parameter return if is Success or Bad */

	}
}

hostujem u Websupportu.
Nette 2.0.10 pre PHP 5.3

Editoval SontoEremo (22. 3. 2013 13:04)