Editing Mika/Notes

==Movies==

===Movies I liked===

* Trouble the water

==Computer Stuff==

Writing down things I've learned. Some miscellaneous stuff are:

* AJAX example: Checks if the username you entered is taken.
* Javascript example: Drag choices up and down.

===MySQL===

====Cheat Sheet====

* mysql_connect()
* mysql_select_db()
* mysql_query()
* mysql_num_rows()
* [http://php.net/manual/en/function.mysql-free-result.php mysql_free_result()]
* mysql_close()

'''Problem'''
I tried to write a php and connect to mysql in it but I got an error:

 Fatal Error: undefined function mysql_connect()

'''Solution'''

[http://www.webmasterworld.com/forum88/5216.htm This page] suggested that mysql isn't enabled by dafault in php5. I installed php5-mysql and restarted apache2 (don't know if that was necessary) and now it works.

----
'''Problem'''
I restarted my computer because I couldn't start gimp unless I was root. Clint told me that I should sudo /etc/init.d/dbus restart , which basically restarted my whole computer. Since then, I couldn't use mysql because I kept getting this error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

'''Solution'''

I followed [http://forums.mysql.com/read.php?11,42525,46765#msg-46765 this] and restarted mysql by:

/etc/init.d/mysql restart

But it fails. It seems like I touched my.cnf and didn't restart mysql, so when my computer restarted, it incorporated the changes I made in my.cnf and mysql stopped working. I reinstalled mysql-server through apt-get, restarted mysql and now it's fine. 

 
----
'''Problem'''
I have a bunch of text files from USDA, which contain bits and pieces USDA ASCII databases. I want to put them into mysql. 

'''Solution'''

1. I found schema.sql that Erik created, so I'm going to borrow it rather than creating my own.

mysql databasename < schema.sql -p


'''Problem:'''

mysql> create database newdatabase;

ERROR 1044 (42000): Access denied for user 'user'@'localhost'...

'''Solution:''' 

[http://dev.mysql.com/doc/refman/5.1/en/creating-database.html mysql]

1. Check grants for 'user'@'localhost' in mysql:

mysql> show grants for 'user'@'localhost';

2. Log into mysql as root (has all privileges) and change grants for a specific user:

mysql> grant all privileges on *.* to 'user'@'localhost';

Query OK, 0 rows affected (0.00 sec)

3. Log back into mysql as user (now has all privileges) and try creating a new database again.


----

===Django===
----

*Tried setting up Django on my computer by following this [http://itpro.nikkeibp.co.jp/article/COLUMN/20081031/318265/?ST=develop&P=4 tutorial]

'''Problem:'''

It worked mostly ok but I couldn't go further than the second to the last coding box on page 4. I kept getting long error messages. 

'''Solution:'''

[http://docs.djangoproject.com/en/dev/intro/tutorial02/ Django tutorial about django.contrib.admin]

1. Check if I typed in the correct codes.

2. Check if the output are the same everwhere:

Although the codes were correct, they didn't create all the necessary things, so it couldn't find the index.html. 

* I went to setting.py to specify:
** the absolute path for Template_Dir. Don't forget the , after '/path/' .
** two additional Installed_Apps: myprj_myapp (where I save my project) and django.contrib.admin . Run python manage.py syncdb afterwards.

This created myapp_post and django_admin_log in mysql database.

----

===Javascript===
----

[http://java-script.seesaa.net/category/2493027-1.html JS Tutorial]

----

===HTML===
----

'''Problem:'''

I didn't know what <form name="form1"> meant.

'''Solution:'''

"A form is an area that can contain form elements.

Form elements are elements that allow the user to enter information (like text fields, textarea fields, drop-down menus, radio buttons, checkboxes, etc.) in a form."
[http://www.tohoho-web.com/js/index.htm　とほほのjavascript]
@@ Line 1: / Line 1: @@
-'''This is where I keep notes on things that I will probably need to read again.
+==Movies==
-'''
-* I moved Computer Stuff to a [http://wiki.mako.cc/Mika/Notes/Computer_Stuff new page]
-* [http://wiki.mako.cc/Mika/Notes/Biking Biking] information on a separate page.
-* Moved to [http://wiki.mako.cc/Mika/Notes/Public_Health Public Health].
-* Made a [http://wiki.mako.cc/Mika/Notes/Beer Beer] page
-=Miscellaneous=
-* Banach-Tarski paradox.
+===Movies I liked===
-* minipimer
-* Temblor Range
+* Trouble the water
-* Khalil Gibran
-* Making of 3 'Idiots'
+==Computer Stuff==
-* <strike/> 野菜寿し ポタジエ Yasai Sushi </strike>
-* ヴィーガンメニューが提供されているのは、権八の銀座・渋谷・西麻布店
+Writing down things I've learned. Some miscellaneous stuff are:
-* 8tablish
-* Sundial Atelier
+* AJAX example: Checks if the username you entered is taken.
-* MOCORO モコロ vacuum
+* Javascript example: Drag choices up and down.
-* 丸ゆべし
-* Fly Geyser
+===MySQL===
-* Bar Yamamoto
-* Wall bar
+====Cheat Sheet====
-* Rage bar
-* Tapas Molecular Bar at Mandarin Oriental, Tokyo
+* mysql_connect()
-* [http://daikokuyu.com/index.html daikokuyu]
+* mysql_select_db()
-* ディマシオ美術館
+* mysql_query()
-* MERIDA X BASE
+* mysql_num_rows()
-* 御殿場MTBパークFUTAGO
+* [http://php.net/manual/en/function.mysql-free-result.php mysql_free_result()]
-* notNeutral cups
+* mysql_close()
-* おふろcafeハレニワの湯 - cheap fun sento in Saitama
-* Kerala Onam festival
+'''Problem'''
-* オレンジ食堂
+I tried to write a php and connect to mysql in it but I got an error:
-* hijikawa arashi
-* 狸サイクル
+ Fatal Error: undefined function mysql_connect()
+'''Solution'''
+[http://www.webmasterworld.com/forum88/5216.htm This page] suggested that mysql isn't enabled by dafault in php5. I installed php5-mysql and restarted apache2 (don't know if that was necessary) and now it works.
+----
+'''Problem'''
+I restarted my computer because I couldn't start gimp unless I was root. Clint told me that I should sudo /etc/init.d/dbus restart , which basically restarted my whole computer. Since then, I couldn't use mysql because I kept getting this error:
+ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
+'''Solution'''
+I followed [http://forums.mysql.com/read.php?11,42525,46765#msg-46765 this] and restarted mysql by:
+/etc/init.d/mysql restart
+But it fails. It seems like I touched my.cnf and didn't restart mysql, so when my computer restarted, it incorporated the changes I made in my.cnf and mysql stopped working. I reinstalled mysql-server through apt-get, restarted mysql and now it's fine.
+----
+'''Problem'''
+I have a bunch of text files from USDA, which contain bits and pieces USDA ASCII databases. I want to put them into mysql.
+'''Solution'''
+. I found schema.sql that Erik created, so I'm going to borrow it rather than creating my own.
+mysql databasename < schema.sql -p
-=Gardening=
-* I can use agar to grow Kaiware seeds etc.
+'''Problem:'''
-=Bicycle=
+mysql> create database newdatabase;
-* Brakes
+ERROR 1044 (42000): Access denied for user 'user'@'localhost'...
-** Change brake pads before the grooves are gone: http://www.jimlangley.net/wrench/brake1.htm
-** U-brake (Center pulled calliper brake) are what's on my red bike.
-* Items that may be useful for touring trips
-** Portable Water Heater - SunRocket Solar Thermos and Kettle - Boil Water With Only Sunlight
-=Hiking=
+'''Solution:'''
-* Potential summer hike ideas
+[http://dev.mysql.com/doc/refman/5.1/en/creating-database.html mysql]
-:: [http://www.wta.org/go-hiking/seasonal-hikes/summer-destinations/mount-st.-helens-hikes Mt. St. Helens]
-=Concert=
+. Check grants for 'user'@'localhost' in mysql:
-* Chopin Piano Concerto #1
+mysql> show grants for 'user'@'localhost';
-* Ravel Piano Concerto in G major
-* Gruppen (Stockhausen)　(2012 May NY Philharmonic?)
-* Symphony No. 3 (Górecki)
-=Piano=
+. Log into mysql as root (has all privileges) and change grants for a specific user:
-* Balakirev / Glinka "The Lark"
+mysql> grant all privileges on *.* to 'user'@'localhost';
-* Liszt "Gnomenreigen"
-* Chopin 3rd Sonata
-* Beethoven Sonata 31
-* ラヴェル／鏡より「道化師の朝の歌」
-=Movies=
+Query OK, 0 rows affected (0.00 sec)
-I liked these movies:
+. Log back into mysql as user (now has all privileges) and try creating a new database again.
-* Trouble the water
-* Cube
-* MST3K Pumaman
-* Tokyo!
-* Annabel Chong
-* I love me
-I want to watch these movies:
+----
+===Django===
+----
-* Uncle Boonmee Who Can Recall His Past Lives
+*Tried setting up Django on my computer by following this [http://itpro.nikkeibp.co.jp/article/COLUMN/20081031/318265/?ST=develop&P=4 tutorial]
-* Faust by Alexander Sokurov
-* ビルマVJ 消された革命
-* Sleeping Beauty (2011)
-* Amour
-* Pee Wee's big adventure
-* White Dog, The Naked Kiss, Shock Corridor by Samuel Fuller
-* スープ
-* Kings of Pastry
-* Streetwise (1984)
-=Books=
+'''Problem:'''
-* 1Q84
+It worked mostly ok but I couldn't go further than the second to the last coding box on page 4. I kept getting long error messages.
-* AIDS and Accusation (Paul Farmer)
-* 農協との３０年戦争 岡本重明
-* Saturday is for Furnerals (Max Essex)
-* クォンタム・ファミリーズ
-* Penguin and Leviathan (Yochai Benkler)
-* The Price of Civilization (Jeffrey Sachs)
-* Godel, Escher, Bach
-* 百年の孤独
-*Ramesh S. Arunachalam, 2011: The Journey of Indian Micro-Finance: Lessons for the Future.
-* 石の花 (坂口尚)
-* Reassembling the Social
-* reread: biology as ideology
-* reread: the structure of scientific revolution
-* 最貧困女子
-* On Food and Cooking: The Science and Lore of the Kitchen (Hardcover)
-* Les Animaux tels qu'ils sont
-=Articles=
+'''Solution:'''
-* Happy Land
+[http://docs.djangoproject.com/en/dev/intro/tutorial02/ Django tutorial about django.contrib.admin]
-* Ashtrays
-* Wasteland
-=Places=
+. Check if I typed in the correct codes.
-* Xkeken
+. Check if the output are the same everwhere:
-* Shark Bay
-* スコトラ島
-* Kayangan Lake
-* Perchten festival in the western Austrian village of Heitwerwang
-* 坊主バー　in Yotsuya: http://vowz-bar.com/
-* cycling museum in osaka
-* キットカット　ショコラトリー
-* ベーカリー兎座LEPUS うさぎ型食パン
-* EdiTion Koji Shimomura: French restaurant with some veg options; near Roppongi
-* Veganic to go: burger place near Roppongi
-* Japanese [https://vegewel.com/ja/cuisine/93 website] for finding veg restaurants
-=Diving=
+Although the codes were correct, they didn't create all the necessary things, so it couldn't find the index.html.
-* Jewfish
+* I went to setting.py to specify:
-* Basking shark
+** the absolute path for Template_Dir. Don't forget the , after '/path/' .
-* Mola mola
+** two additional Installed_Apps: myprj_myapp (where I save my project) and django.contrib.admin . Run python manage.py syncdb afterwards.
-* Turtles
-=Wines=
+This created myapp_post and django_admin_log in mysql database.
-* majo norante "ramitello" rosso biferno molise at Nook. Can't remember the year.
+----
-* Denavolo Dinavolo Vino da Tavola 2007 at The Remedy.
-=Traveling tips=
+===Javascript===
+----
-* How to send things from UK:
+[http://java-script.seesaa.net/category/2493027-1.html JS Tutorial]
-: You can get a small, medium, or large box at post office (haven't tried royal mail but they're similar?). You can send a ''small parcel'' = less than 2kg internationally for a reasonable price. From UK to Japan is about 25 quid for 2kg.
-==Tokyo Bars==
+----
-Good:
+===HTML===
+----
-* BAR ORCHARD (Ginza)
+'''Problem:'''
-* High Five (Ginza)
-* Mori Bar (Ginza)
-* Bar Hoshi (Ginza)
-* Ben Fiddich (Shinjuku)
-* The SG Club (Shibuya)
+I didn't know what <form name="form1"> meant.
-Ok:
+'''Solution:'''
-* Star Bar (Ginza)
-* swrl (Shibuya)
-* Gen Yamamoto (Azabujuban)
-* グランドファイン (Nakameguro)
-List of subpages:
+"A form is an area that can contain form elements.
-* [[Mika/Notes/2016]]
+Form elements are elements that allow the user to enter information (like text fields, textarea fields, drop-down menus, radio buttons, checkboxes, etc.) in a form."
-* [[Mika/Notes/Beer]]
+[http://www.tohoho-web.com/js/index.htm　とほほのjavascript]
-* [[Mika/Notes/Beer/Imperial IPA 2017]]
-* [[Mika/Notes/Computer Stuff]]
-* [[Mika/Notes/Computer Stuff/Debian Installation]]
-* [[Mika/Notes/Computer Stuff/Debian Maintenance]]
-* [[Mika/Notes/Computer Stuff/R]]
-* [[Mika/Notes/Phrontistery 2015]]
-* [[Mika/Notes/Public Health]]
-* [[Mika/Notes/Seattle]]
-* [[Mika/Notes/Todo]]
-* [[Mika/Notes/Travel]]
-* [[Mika/Notes/Travel/2015 FridayHarbor]]
-* [[Mika/Notes/moving]]
-* [[Mika/Temp/WikiFCD/FCTtemplate]]
-* [[Mika Books]]
-* [[Modularity and FOSS]]