Home arrow Faq arrow Installation Mysql server
Installation Mysql server

INSTALLATION MYSQL SERVER v5.0.45

Site of developer: http://www.mysql.com/
Download " Windows (x86) ZIP/Setup.EXE " archive from page of distribution kits, unpack him and start Setup.exe.

 

  • Further those dialogue windows in which it is necessary to make any choice will be shown.
  • Отметьте в данном окне выборочную установку компонентов
  • Note in the given window custom installation of components.

  • Image
  • Here you can choose additional components and replace an adjusting directory of the program.

  • Image
  • Choose " Skip Sign-Up " for transition to the following page.

  • Image
  • Now we shall start option MySQL of a server.

  • Image
  • We choose the detailed option - " Detailed Configuration ".

  • Image
  • We mark item " Server Machine ".

  • Image
  • Having chosen item " Multifunctional Database ", you can work as with tables such as InnoDB (with an opportunity of use of transactions), and with high-speed MyISAM (as a rule for webs-development this type of tables is used).

  • Image
  • Choice of a disk and directory for storage of tables such as InnoDB (it is simple Next).

  • Image
  • In the given dialogue window the greatest possible amount of connections to server MySQL gets out. At a choice " Decision Support (DSS)/OLAP ", the maximum quantity of connections will be limited to twenty of that more than it is enough at installation of a server on a domestic computer and absence of a plenty of simultaneous connections. If it is planned connections большечем 20, choose Manual Setting and ставте necessary to you amount.

  • Image
  • Having noted " Enable TCP/IP Networking " we include support TCP/IP of connections and we choose port through which they will be carried out. For server MySQL the port 3306 is standard. Having noted " Enable Strict Mode ", we set a mode of strict conformity to standard SQL (the given option is recommended to be left included).

  • Image
  • Pay attention to exhibiting options of the given window. Having noted " Manual Selected Default Character Set / Collation " and having chosen from the falling menu "cp1251" it is determined, that for tables coding Cyrillic Windows (cp1251) will be initially used, that means correct work with Russian in the given coding.

  • Image
  • If to note " Install As Windows Service ", the server will be started as service that is recommended way of start. Below, in the falling list, the name of service is set. Also put a tick near to " Include Bin Directory in Windows PATH " is will allow to establish visibility of a directory "bin", for a command line.

  • Image
  • Establish the password of the user "root". And necessarily it remember, only do not leave a field empty, it will save you from possible troubles further. Also establish a tick " Enable root access from remote machines " if plan to work with base on a network, the user root.

  • Image
  •  In the given window pay attention to a line " Write configuration file " which specifies a site of configuration file MySQL - "my.ini"

  • The End.