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;