<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[Форум PHP-MyAdmin.RU &mdash; 1045 - Access denied for user 'root_admin'@' (using password: YES)]]></title>
		<link>https://forum.php-myadmin.ru/viewtopic.php?id=2459</link>
		<atom:link href="https://forum.php-myadmin.ru/extern.php?action=feed&amp;tid=2459&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[Недавние сообщения в теме «1045 - Access denied for user 'root_admin'@' (using password: YES)».]]></description>
		<lastBuildDate>Sat, 28 Jan 2012 16:18:05 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: 1045 - Access denied for user 'root_admin'@' (using password: YES)]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=18765#p18765</link>
			<description><![CDATA[<p>По идее, либо в корне, либо в includes. Посмотрите документацию скрипта, это будет быстрее.</p>]]></description>
			<author><![CDATA[null@example.com (Hanut)]]></author>
			<pubDate>Sat, 28 Jan 2012 16:18:05 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=18765#p18765</guid>
		</item>
		<item>
			<title><![CDATA[Re: 1045 - Access denied for user 'root_admin'@' (using password: YES)]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=18760#p18760</link>
			<description><![CDATA[<p>config.php - это искать в директории сайта <a href="http://www.site.com/admin/">www.site.com/admin/</a>...</p><p>или где-то в другом месте?</p>]]></description>
			<author><![CDATA[null@example.com (Gish)]]></author>
			<pubDate>Sat, 28 Jan 2012 10:47:00 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=18760#p18760</guid>
		</item>
		<item>
			<title><![CDATA[Re: 1045 - Access denied for user 'root_admin'@' (using password: YES)]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=18759#p18759</link>
			<description><![CDATA[<p>По коду не понятно где конфигурационный файл. Поищите что-то вроде config.php.</p>]]></description>
			<author><![CDATA[null@example.com (Hanut)]]></author>
			<pubDate>Sat, 28 Jan 2012 10:44:59 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=18759#p18759</guid>
		</item>
		<item>
			<title><![CDATA[Re: 1045 - Access denied for user 'root_admin'@' (using password: YES)]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=18758#p18758</link>
			<description><![CDATA[<p>ААААА, подождите!</p><p>Точно! Я вспомнил! </p><p>Я поменял пароль MSQl. Кактеперь вбить новый пароль, что бы нормально входило? Куда его вписать нужно?</p><p>блин, лучше бы не менял</p>]]></description>
			<author><![CDATA[null@example.com (Gish)]]></author>
			<pubDate>Sat, 28 Jan 2012 10:38:16 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=18758#p18758</guid>
		</item>
		<item>
			<title><![CDATA[Re: 1045 - Access denied for user 'root_admin'@' (using password: YES)]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=18757#p18757</link>
			<description><![CDATA[<div class="codebox"><pre><code>&lt;?php


include (&#039;includes/top.php&#039;);

if (isset ($_SESSION[&#039;customer_id&#039;])) {
    os_redirect(os_href_link(FILENAME_ACCOUNT, &#039;&#039;, &#039;SSL&#039;));
}
//$osTemplate = new osTemplate;


if ($session_started == false) {
    os_redirect(os_href_link(FILENAME_COOKIE_USAGE));
}

if (isset ($_GET[&#039;action&#039;]) &amp;&amp; ($_GET[&#039;action&#039;] == &#039;process&#039;)) {
    $email_address = os_db_prepare_input($_POST[&#039;email_address&#039;]);
    $password = os_db_prepare_input($_POST[&#039;password&#039;]);

    // Check if email exists
    $check_customer_query = os_db_query(&quot;select customers_id, customers_vat_id, customers_firstname,customers_lastname, customers_gender, customers_password, customers_email_address, login_tries, login_time, customers_default_address_id from &quot;.TABLE_CUSTOMERS.&quot; where customers_email_address = &#039;&quot;.os_db_input($email_address).&quot;&#039; and account_type = &#039;0&#039;&quot;);
    if (!os_db_num_rows($check_customer_query)) {
        $_GET[&#039;login&#039;] = &#039;fail&#039;;
        $info_message = TEXT_NO_EMAIL_ADDRESS_FOUND;
    } else {
        $check_customer = os_db_fetch_array($check_customer_query);

// Check the login is blocked while login_tries is more than 5 and blocktime is not over
    $blocktime = LOGIN_TIME;                                                                                   // time to block the login in seconds
    $time = time();                                                                                  // time now as a timestamp
    $logintime = strtotime($check_customer[&#039;login_time&#039;]);  // conversion from the ISO date format to a timestamp
    $difference = $time - $logintime;                                             // The difference time in seconds between the last login and now
  if ($check_customer[&#039;login_tries&#039;] &gt;= LOGIN_NUM and $difference &lt; $blocktime) {
        // Action for bцse ?
    $osTemplate-&gt;assign(&#039;CAPTCHA_IMG&#039;, &#039;&lt;img src=&quot;&#039;.FILENAME_DISPLAY_CAPTCHA.&#039;&quot; alt=&quot;captcha&quot; /&gt;&#039;);    
    $osTemplate-&gt;assign(&#039;CAPTCHA_INPUT&#039;, os_draw_input_field(&#039;captcha&#039;, &#039;&#039;, &#039;size=&quot;6&quot; maxlength=&quot;6&quot;&#039;, &#039;text&#039;, false));
    if ($_POST[&#039;captcha&#039;] == $_SESSION[&#039;captcha_keystring&#039;]){
    // code ok
        // Check that password is good
        if (!os_validate_password($password, $check_customer[&#039;customers_password&#039;])) {
            $_GET[&#039;login&#039;] = &#039;fail&#039;;
      // Login tries + 1
          os_db_query(&quot;update &quot;.TABLE_CUSTOMERS.&quot; SET login_tries = login_tries+1, login_time = now() WHERE customers_email_address = &#039;&quot;.os_db_input($email_address).&quot;&#039;&quot;);        
            $info_message = TEXT_LOGIN_ERROR;
        } else {
            if (SESSION_RECREATE == &#039;True&#039;) {
                os_session_recreate();
            }
      // Login tries = 0            $date_now = date(&#039;Ymd&#039;);
          os_db_query(&quot;update &quot;.TABLE_CUSTOMERS.&quot; SET login_tries = 0, login_time = now() WHERE customers_email_address = &#039;&quot;.os_db_input($email_address).&quot;&#039;&quot;);        
          
            $check_country_query = os_db_query(&quot;select entry_country_id, entry_zone_id from &quot;.TABLE_ADDRESS_BOOK.&quot; where customers_id = &#039;&quot;.(int) $check_customer[&#039;customers_id&#039;].&quot;&#039; and address_book_id = &#039;&quot;.$check_customer[&#039;customers_default_address_id&#039;].&quot;&#039;&quot;);
            $check_country = os_db_fetch_array($check_country_query);

            $_SESSION[&#039;customer_gender&#039;] = $check_customer[&#039;customers_gender&#039;];
            $_SESSION[&#039;customer_first_name&#039;] = $check_customer[&#039;customers_firstname&#039;];
            $_SESSION[&#039;customer_last_name&#039;] = $check_customer[&#039;customers_lastname&#039;];
            $_SESSION[&#039;customer_id&#039;] = $check_customer[&#039;customers_id&#039;];
            $_SESSION[&#039;customer_vat_id&#039;] = $check_customer[&#039;customers_vat_id&#039;];
            $_SESSION[&#039;customer_default_address_id&#039;] = $check_customer[&#039;customers_default_address_id&#039;];
            $_SESSION[&#039;customer_country_id&#039;] = $check_country[&#039;entry_country_id&#039;];
            $_SESSION[&#039;customer_zone_id&#039;] = $check_country[&#039;entry_zone_id&#039;];



            os_db_query(&quot;update &quot;.TABLE_CUSTOMERS_INFO.&quot; SET customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1 WHERE customers_info_id = &#039;&quot;.(int) $_SESSION[&#039;customer_id&#039;].&quot;&#039;&quot;);
            os_write_user_info((int) $_SESSION[&#039;customer_id&#039;]);
            // restore cart contents
            $_SESSION[&#039;cart&#039;]-&gt;restore_contents();

            if ($_SESSION[&#039;cart&#039;]-&gt;count_contents() &gt; 0) {
                os_redirect(os_href_link(FILENAME_SHOPPING_CART, &#039;&#039;, &#039;SSL&#039;));
            } else {
                os_redirect(os_href_link(FILENAME_DEFAULT));
            }

        }
    }else{
    // code falsch
    $info_message = TEXT_WRONG_CODE;
    // Login tries + 1
        os_db_query(&quot;update &quot;.TABLE_CUSTOMERS.&quot; SET login_tries = login_tries+1, login_time = now() WHERE customers_email_address = &#039;&quot;.os_db_input($email_address).&quot;&#039;&quot;);        
    }        
    } else {
        // Check that password is good
        if (!os_validate_password($password, $check_customer[&#039;customers_password&#039;])) {
            $_GET[&#039;login&#039;] = &#039;fail&#039;;
      // Login tries + 1
          os_db_query(&quot;update &quot;.TABLE_CUSTOMERS.&quot; SET login_tries = login_tries+1, login_time = now() WHERE customers_email_address = &#039;&quot;.os_db_input($email_address).&quot;&#039;&quot;);        
            $info_message = TEXT_LOGIN_ERROR;
        } else {
            if (SESSION_RECREATE == &#039;True&#039;) {
                os_session_recreate();
            }
      // Login tries = 0            $date_now = date(&#039;Ymd&#039;);
          os_db_query(&quot;update &quot;.TABLE_CUSTOMERS.&quot; SET login_tries = 0, login_time = now() WHERE customers_email_address = &#039;&quot;.os_db_input($email_address).&quot;&#039;&quot;);        
          
            $check_country_query = os_db_query(&quot;select entry_country_id, entry_zone_id from &quot;.TABLE_ADDRESS_BOOK.&quot; where customers_id = &#039;&quot;.(int) $check_customer[&#039;customers_id&#039;].&quot;&#039; and address_book_id = &#039;&quot;.$check_customer[&#039;customers_default_address_id&#039;].&quot;&#039;&quot;);
            $check_country = os_db_fetch_array($check_country_query);

            $_SESSION[&#039;customer_gender&#039;] = $check_customer[&#039;customers_gender&#039;];
            $_SESSION[&#039;customer_first_name&#039;] = $check_customer[&#039;customers_firstname&#039;];
            $_SESSION[&#039;customer_last_name&#039;] = $check_customer[&#039;customers_lastname&#039;];
            $_SESSION[&#039;customer_id&#039;] = $check_customer[&#039;customers_id&#039;];
            $_SESSION[&#039;customer_vat_id&#039;] = $check_customer[&#039;customers_vat_id&#039;];
            $_SESSION[&#039;customer_default_address_id&#039;] = $check_customer[&#039;customers_default_address_id&#039;];
            $_SESSION[&#039;customer_country_id&#039;] = $check_country[&#039;entry_country_id&#039;];
            $_SESSION[&#039;customer_zone_id&#039;] = $check_country[&#039;entry_zone_id&#039;];



            os_db_query(&quot;update &quot;.TABLE_CUSTOMERS_INFO.&quot; SET customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1 WHERE customers_info_id = &#039;&quot;.(int) $_SESSION[&#039;customer_id&#039;].&quot;&#039;&quot;);
            os_write_user_info((int) $_SESSION[&#039;customer_id&#039;]);
            // restore cart contents
            $_SESSION[&#039;cart&#039;]-&gt;restore_contents();

            if ($_SESSION[&#039;cart&#039;]-&gt;count_contents() &gt; 0) {
                os_redirect(os_href_link(FILENAME_SHOPPING_CART, &#039;&#039;, &#039;SSL&#039;));
            } else {
                os_redirect(os_href_link(FILENAME_DEFAULT));
            }

        }
     }
    }
}

$breadcrumb-&gt;add(NAVBAR_TITLE_LOGIN, os_href_link(FILENAME_LOGIN, &#039;&#039;, &#039;SSL&#039;));
require (dir_path(&#039;includes&#039;).&#039;header.php&#039;);

//if ($_GET[&#039;info_message&#039;]) $info_message = $_GET[&#039;info_message&#039;];
$osTemplate-&gt;assign(&#039;info_message&#039;, $info_message);
$osTemplate-&gt;assign(&#039;account_option&#039;, ACCOUNT_OPTIONS);

$osTemplate-&gt;assign(&#039;BUTTON_NEW_ACCOUNT&#039;, button_continue(  os_href_link(FILENAME_CREATE_ACCOUNT, &#039;&#039;, &#039;SSL&#039;)  ) );

       $_array = array(&#039;img&#039; =&gt; &#039;button_login.gif&#039;, &#039;href&#039; =&gt; &#039;&#039;, &#039;alt&#039; =&gt; IMAGE_BUTTON_LOGIN, &#039;code&#039; =&gt; &#039;&#039;);
    
       $_array = apply_filter(&#039;button_login&#039;, $_array);    
    
       if (empty($_array[&#039;code&#039;]))
        {
           $_array[&#039;code&#039;] =  os_image_submit($_array[&#039;img&#039;], $_array[&#039;alt&#039;]);
       }
         
       
$osTemplate-&gt;assign(&#039;BUTTON_LOGIN&#039;, $_array[&#039;code&#039;]);

$osTemplate-&gt;assign(&#039;BUTTON_GUEST&#039;, button_continue(  os_href_link(FILENAME_CREATE_GUEST_ACCOUNT, &#039;&#039;, &#039;SSL&#039;)  ));

$osTemplate-&gt;assign(&#039;FORM_ACTION&#039;, os_draw_form(&#039;login&#039;, os_href_link(FILENAME_LOGIN, &#039;action=process&#039;, &#039;SSL&#039;)));
$osTemplate-&gt;assign(&#039;INPUT_MAIL&#039;, os_draw_input_field(&#039;email_address&#039;));
$osTemplate-&gt;assign(&#039;INPUT_PASSWORD&#039;, os_draw_password_field(&#039;password&#039;));
$osTemplate-&gt;assign(&#039;LINK_LOST_PASSWORD&#039;, os_href_link(FILENAME_PASSWORD_DOUBLE_OPT, &#039;&#039;, &#039;SSL&#039;));
$osTemplate-&gt;assign(&#039;FORM_END&#039;, &#039;&lt;/form&gt;&#039;);

$osTemplate-&gt;assign(&#039;language&#039;, $_SESSION[&#039;language&#039;]);
$osTemplate-&gt;caching = 0;
$main_content = $osTemplate-&gt;fetch(CURRENT_TEMPLATE.&#039;/module/login.html&#039;);
$osTemplate-&gt;assign(&#039;main_content&#039;, $main_content);

$osTemplate-&gt;assign(&#039;language&#039;, $_SESSION[&#039;language&#039;]);
$osTemplate-&gt;caching = 0;
 $osTemplate-&gt;load_filter(&#039;output&#039;, &#039;trimhitespace&#039;);
$template = (file_exists(_THEMES_C.FILENAME_LOGIN.&#039;.html&#039;) ? CURRENT_TEMPLATE.&#039;/&#039;.FILENAME_LOGIN.&#039;.html&#039; : CURRENT_TEMPLATE.&#039;/index.html&#039;);
$osTemplate-&gt;display($template);
include (&#039;includes/bottom.php&#039;);
?&gt;</code></pre></div><p>содержимое файла login.php</p>]]></description>
			<author><![CDATA[null@example.com (Gish)]]></author>
			<pubDate>Sat, 28 Jan 2012 10:31:15 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=18757#p18757</guid>
		</item>
		<item>
			<title><![CDATA[Re: 1045 - Access denied for user 'root_admin'@' (using password: YES)]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=18756#p18756</link>
			<description><![CDATA[<p>простите, но где их можно посмотреть?</p>]]></description>
			<author><![CDATA[null@example.com (Gish)]]></author>
			<pubDate>Sat, 28 Jan 2012 10:29:02 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=18756#p18756</guid>
		</item>
		<item>
			<title><![CDATA[Re: 1045 - Access denied for user 'root_admin'@' (using password: YES)]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=18755#p18755</link>
			<description><![CDATA[<p>Смотрите login.php в котором прописаны данные для подключения к MySQL.</p><p>Сообщение говорит о том, что для пользователя root_admin не верно указан пароль.</p>]]></description>
			<author><![CDATA[null@example.com (Hanut)]]></author>
			<pubDate>Sat, 28 Jan 2012 10:11:01 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=18755#p18755</guid>
		</item>
		<item>
			<title><![CDATA[1045 - Access denied for user 'root_admin'@' (using password: YES)]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=18753#p18753</link>
			<description><![CDATA[<p>Помогите, пожалуйста! У меня паника! </p><br /><p>28/01/2012 12:01:54 | 1045 - Access denied for user &#039;root_admin&#039;@&#039;localhost&#039; (using password: YES) | connect | /login.php</p><br /><p>было всё норм. Потом, после добавления новой таблицы, index.php да и вообще все остальные php страницы стали отображать данное сообщение </p><br /><p>28/01/2012 12:01:54 | 1045 - Access denied for user &#039;root_admin&#039;@&#039;localhost&#039; (using password: YES) | connect | /login.php</p><br /><p>что это такое, а главное, как исправить? пожалуйста, мне очень нужно. Долго очень делал сайт. Не хотелось бы начать всё сначала!</p>]]></description>
			<author><![CDATA[null@example.com (Gish)]]></author>
			<pubDate>Sat, 28 Jan 2012 10:04:32 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=18753#p18753</guid>
		</item>
	</channel>
</rss>
