zmena nastaveni mysql (Lenny)

Založil hoffmann, 16. 02. 2010, 16:51:14

Předchozí téma - Další téma

hoffmann

Ahoj,
potreboval bych zmnenit nize uvedene promene v Mysql na cp1250_czech_cs.

collation connection     utf8_unicode_ci
(Globální hodnota)    latin1_swedish_ci
collation database    latin1_swedish_ci
collation server    latin1_swedish_ci

Predem dekuji.
Debian Jessie | Kernel 3.16.0-4-amd64 | XFCE 4.10,
- notebook HP630 Intel Pentium Dual Core B960 2,2 GHz | 6 GB DDR3 1333 MHz | Intel HD Graphics | HDD Toshiba 320 GB 5400 RPM S-ATA | DVD+/-RW SuperMulti DL s LightScribe 
- is dead notebook Asus A9RP Celeron M440 1,86 GHz | grafika ATI Radeon Xpress 200m | HD 60 GB | pamet DDR II 1024 MB | DVDRAM GSA-T40N HL-DT-ST | Wi-Fi ASUS

Linux user number: 480304

vlado.strenk

#1
tak posli IP a heslo na roota :-)
Dobra rada: zabudni na CP1250 pouzivaj UTF8
to czech_cs by mal byt czech_ci
utf8_czech_ci
Debian stable, XFCE

Roman Horník

CP-1250 = zmrvený ISO-8859-2 = obstarožní kódování odsouzený k zániku

Jak psal Vlado, UTF-8 rulezzz!
Debian Sid/Experimental 64bit + Mate Desktop Environment
* CPU: Intel i5 3570
* GPU: NVIDIA GTX650 1GD5
* MB: Lenovo IH61M
* RAM: 16GiB Deutsche Demokratische Republik 3 @ 1600MHz

vlado.strenk

Inak v /etc/mysql/my.cnf

[mysqld]
init_connect='SET CHARACTER SET utf8'
init_connect='SET collation_connection = utf8_czech_ci'
init_connect='SET NAMES utf8'
default-character-set = utf8
character-set-server  = utf8
collation-server      = utf8_czech_ci
Debian stable, XFCE

Erich Stark

Citace od: vlado.strenk kdy 25. 05. 2010, 15:14:49
tak posli IP a heslo na roota :-)
Dobra rada: zabudni na CP1250 pouzivaj UTF8
to czech_cs by mal byt czech_ci
utf8_czech_ci

Naco by ti bolo heslo ak by mal nastavene "PermitRootLogin no" ? :)
" The box said that I needed to have Windows XP or better ... so I installed Debian ."