MySQL free install version common operation

It is said that the Windows platform under the Mysql,linux is not so troublesome.

Add and remove services:
run the command line as an administrator
{mysql_home}\bin\mysqld--install mysql/* Register for MySQL service * *
{mysql_home}\bin\mysqld--remove mysql/* Register for MySQL service * *

Start, stop service: Administrator Run command line net start MySQL, net stop MySQL

Custom configuration: From My-small.ini, My-medium.ini, My-large.ini, My-huge.ini, My-innodb-heavy-4g.ini Select an appropriate level (light to heavy) profile and copy it into the My.ini file

Configure custom Data directory: Add basedir= d:/mysql-noinstall-5.5.50-win32 (root directory), datadir= d:/under My.ini [mysqld] Node Mysql-noinstall-5.5.50-win32/data (data file storage directory), note cannot be \, must be/

Initial setting:
{Mysql_home}\bin\mysql Without parameter entry is not manageable, also can not see MySQL database,{mysql_home}\bin\mysql-u root enter, use MySQL; The initial user can be set.
Grant All on * * to [e-mail protected] '% ' identified by ' root ' with GRANT option; /* Set root password and allow access from any host * /

Flush privileges;

Set the character set:

In the My.ini [client] Set default-character-set = UTF8, you can use the Command Line window to correctly import utf-8 encoded SQL file (if the database is created when the selected character set is also uft-8), at this time is normal for the application, However, the command-line window displays garbled characters because the Windows command-line window does not encode and decode Chinese utf-8.

At the same time, set the Character-set-server=utf8 in [mysqld], so that the Chinese in the Java Code correctly access (if the database is created when the selected character set is also uft-8).

This article from "Empty" blog, declined reprint!

MySQL free install version common operation