<?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>Różności ... &#187; MySQL</title>
	<atom:link href="http://www.jaceksen.pl/wordpress/?cat=20&#038;feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://www.jaceksen.pl/wordpress</link>
	<description>czyli moje notki</description>
	<lastBuildDate>Sun, 14 Nov 2021 16:21:49 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0.3</generator>
		<item>
		<title>mysql access denied for user root@localhost</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4617</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4617#comments</comments>
		<pubDate>Mon, 01 Jul 2019 07:55:38 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[MySQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4617</guid>
		<description><![CDATA[sudo mysql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; With a single query we are changing the auth_plugin to mysql_native_password and setting the root password to root (feel free to change it in the query) Now you should be able to login with root. More information can be found in mysql documentation (exit mysql console with Ctrl + D [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4617</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>MySql konwersja ISO8859-2 do UTF-8</title>
		<link>http://www.jaceksen.pl/wordpress/?p=3785</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=3785#comments</comments>
		<pubDate>Wed, 19 Jun 2013 15:46:16 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[MySQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=3785</guid>
		<description><![CDATA[/usr/bin/mysqldump &#8211;user=root &#8211;password=haslo &#8211;max_allowed_packet=99M &#8211;default-character-set=latin1 -c &#8211;insert-ignore &#8211;skip-set-charset -r 130619_latin1_biblioteka.sql biblioteka file nazwa_pliku_dumpa.sql (pokazuje w jakim jest kodowaniu) iconv -f ISO8859-2 -t UTF-8  nazwa_pliku_dumpa.sql &#62; nazwa_pliku_dumpa-utf-8.sql drop database CREATE DATABASE nazwa_bazy_danych CHARACTER SET utf8 COLLATE utf8_general_ci mysql -uroot -ppassword --default-character-set=utf8 nazwa_bazy_danych &#60; nazwa_pliku_dumpa-utf-8.sql zmiana templateów: for i in *.tpl; do iconv -f ISO8859-2 -t UTF-8 [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=3785</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>MySQL &#8211; podstawy</title>
		<link>http://www.jaceksen.pl/wordpress/?p=159</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=159#comments</comments>
		<pubDate>Sat, 25 Dec 2010 21:45:09 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[MySQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=159</guid>
		<description><![CDATA[mysql&#62; SELECT * FROM Cars INTO OUTFILE '/tmp/cars.csv' -&#62; FIELDS TERMINATED BY ','; http://zetcode.com/databases/mysqltutorial/exportimport/ łączenie do MySQL mysql przetargi --host=153.19.105.4 -p sql&#62; grant all privileges on nazwabazy.* to user@localhost identified by "jakieshaslo"; mysql&#62; set character_set_client=latin2; mysql&#62; set character_set_connection=utf8; mysql&#62; load data infile "/tmp/przyswajalne" into table strony fields terminated by ';' LINES TERMINATED BY '\r\n' (nazwa_html,zawartosc); [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=159</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>MySQL &#8211; zwiększenie rozmiaru bazy danych</title>
		<link>http://www.jaceksen.pl/wordpress/?p=117</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=117#comments</comments>
		<pubDate>Fri, 24 Dec 2010 13:00:48 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[MySQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=117</guid>
		<description><![CDATA[mysql&#62; show engines; mysql&#62; show table status; aby dodać miejsce (INNODB) trzeba zamknąć bazę: mysqladmin -u root -p shutdown a następnie w /etc/my.cnf trzeba dodać kolejny plik innodb_data_file_path = dbdata1:200M;dbdata2:200M;dbdata3:512M i uruchomić bazę ponownie.]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=117</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
