MySQL (*nix setup)

• problems?

TODO

1. shutdown MySQL
2. start MySQL with `mysqld_safe –skip-grant-tables &`
3. 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;

 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