<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>SysBlog &#187; PHP</title>
	<atom:link href="http://blog.interakt.hr/?cat=5&#038;feed=rss2" rel="self" type="application/rss+xml" />
	<link>https://blog.interakt.hr</link>
	<description>...mic po mic...</description>
	<lastBuildDate>Tue, 24 Mar 2026 11:53:38 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.1.2</generator>
		<item>
		<title>MySql: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication</title>
		<link>https://blog.interakt.hr/?p=40</link>
		<comments>https://blog.interakt.hr/?p=40#comments</comments>
		<pubDate>Tue, 19 Apr 2011 10:31:12 +0000</pubDate>
		<dc:creator>SysBlog</dc:creator>
				<category><![CDATA[MYSQL Database Development]]></category>
		<category><![CDATA[PHP]]></category>

		<guid isPermaLink="false">http://systasis.biz/blog/?p=40</guid>
		<description><![CDATA[Problem: Prilikom spajanja na mysql bazu php javlja grešku u konekciji: Rješenje: Updejtamo stari password istim takvim pomoću sljedeće naredbe:]]></description>
			<content:encoded><![CDATA[<p><strong>Problem:</strong><br />
Prilikom spajanja na mysql bazu php javlja grešku u konekciji:</p>
<pre class="brush: plain; title: ; notranslate">mysqlnd cannot  connect to MySQL 4.1+ using the old insecure authentication. Please use  an administration tool to reset your password with the command SET  PASSWORD = PASSWORD('your_existing_password'). This will store a  new, and more secure, hash value in mysql.user. If this user is used in  other scripts executed by PHP 5.2 or earlier you might need to remove  the old-passwords flag from your my.cnf file</pre>
<p><strong>Rješenje:</strong><br />
Updejtamo stari password istim takvim pomoću sljedeće naredbe:</p>
<pre class="brush: sql; title: ; notranslate">UPDATE mysql.user SET Password=PASSWORD('lozinka') WHERE User='korisnik';

FLUSH PRIVILEGES;</pre>
]]></content:encoded>
			<wfw:commentRss>https://blog.interakt.hr/?feed=rss2&#038;p=40</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
