THE Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

==== MySQL ====

=== Installation Windows ===

Download zip file from http://www.mysql.com/downloads/mysql/
Unzip to c:/mysql
Select an appropriate my.ini
Initial configuration of my.ini
add line:
datadir = D:\mysqldata

Configure users
set passwd for user root
   UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

create database


register user examples
  mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
  mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' WITH GRANT OPTION;

  mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
  mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;

  mysql> CREATE USER 'admin'@'localhost';
  mysql> GRANT RELOAD,PROCESS,CREATE,UPDATE ON *.* TO 'admin'@'localhost';

  mysql> CREATE USER 'admin'@'localhost';
  mysql> GRANT RELOAD,PROCESS,CREATE,UPDATE ON database.table TO 'admin'@'localhost';

  mysql> CREATE USER 'dummy'@'localhost';

set rights 
  FLUSH PRIVILEGES;