Some MySQL knowledge and go language Operation Mysql,mysqld Service

This is a creation in Article, where the information may have evolved or changed.

Go language operation MySQL premium link: http://www.cnblogs.com/hupengcool/p/4143238.html

Database driver:

Just touching a database is using a database in a command box, and data driven is the ability to invoke SQL statements in other ways.

Also to operate the database, data storage.

MySQL User management:

Change root username password: http://book.51cto.com/art/200904/120306.htm

MySQL is a multi-user database with a powerful access control system that allows you to specify the permissions allowed for different users.

MySQL users can be divided into root users and ordinary users.

The root user is a super Administrator with all permissions, including administrative privileges such as creating users, deleting users, and modifying user passwords;

Ordinary users have only the various permissions granted.

User management includes managing user accounts, permissions, and so on.

Show GRANTS; View permissions

Login root user, can not directly open mysql.exe, should be in the file directory with Mysql-u root-p (enter)

Enter the password again after entering.

MySQL Character set problem: (This problem has been kneeling for many days.) Orz

Main Link: http://www.cnblogs.com/whiteyun/archive/2011/05/19/2051097.html

System variables: (Show variables like ' character% ')

Reference Link: http://blog.itpub.net/23382569/viewspace-1985650/

Cause: According to the search results on the web, the (Windows) CMD window uses GBK encoding by default, and the original character set is Latin1, and since then though I

Changed to UTF8 also no way to work, because the code is inconsistent, and there is no transcoding things, so there is no display or appear question mark.

By set names GBK, you can specify the client, Connection,result, and so on as the GBK character set. However, the previously entered Chinese characters are still not displayed.

(It may be because the previous MySQL version is higher, you can re-enter the operation bar), then input Chinese characters can be displayed.

This is really a ... Orz .....

Set character_set_database=latin1;

Set character_set_server=latin1;


Set CHARACTER_SET_CLIENT=GBK;


Set CHARACTER_SET_CONNECTION=GBK;

How to display the MYSQLD server in Computer Management:

Execute mysqld--install under cmd and find that MySQL has been added to the system service.

You can also start the server through the net start mysqld