This is an old revision of the document!

MySQL (*nix setup)

problems?

TODO

shutdown MySQL
start MySQL with `mysqld_safe –skip-grant-tables &`
set password either with :

`mysqladmin -u root flush-privileges password “newpwd”`

  or
    `mysql -u root mysql`
    
    Issue the following commands in the mysql client:
    mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
    mysql> FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON *.* TO myuser@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;

Convert a db to UTF8 after upgrading to MySQL 4.1

 mysqldump --user=username --password=password --default-character-set=latin1 --skip-set-charset dbname > dump.sql
 chgrep latin1 utf8 dump.sql
 mysql --user=username --password=password --execute="DROP DATABASE dbname; CREATE DATABASE dbname; CHARACTER SET utf8 COLLATE utf8_general_ci;"
 mysql --user=username --password=password --default-character-set=utf8 dbname < dump.sql

From MySQL 4.x (latin1) to MySQL 5.x (latin2) and UTF8 data :)

variables:

	MySQL 4.1	MySQL 5.x
character_set_client	latin1	latin1
character_set_connection	latin1	latin1
character_set_database	latin1	latin2
character_set_results	latin1	latin1
character_set_server	latin1	latin2
character_set_system	utf8	utf8
collation_connection	latin1_swedish_ci	latin1_swedish_ci
collation_database	latin1_swedish_ci	latin2_general_ci
collation_server	latin1_swedish_ci	latin2_general_ci

 # mysqldump --default-character-set=latin1 -skip-set-charset --create-options -n -c --opt > shema
 # mysqldump --default-character-set=latin1 --skip-set-charset --create-options -n -c --extended-insert -t > data
 # sed -i "s/latin1/utf8/g" shema.sql
 # cat shema| mysql --default-character-set=utf8
 # cat data| mysql --default-character-set=latin2