Mysql decompression and authorization, mysql authorization

Mysql decompression and authorization, mysql authorization
Decompress mysql compressed version to a root directory

Note the content configuration of the INI File

Basedir = D: \ mysql-5.6.17-winx64
Datadir = D: \ mysql-5.6.17-winx64
Port = 3306
Server_id = mssql

Default-character-set = utf8

Cmd
Cd mysql bin directory
Mysqld install mysql
Net start mysql

------------------

User zs library zsk password zsp
Mysql-uroot-p
Create database zsk;
Grant all privileges on zsk. * to zs @ localhost identified by zsp;
Flush privileges;
Exit


Mysql-uzs-p
Use zsk;

Source xxx. SQL;

Grant all privileges on which database. What permission user @ logon IP identified by password

Mysql ROOT User grant cannot be authorized

If your operation is correct, it may be a bug. Replace it with version 5.0.37. The latest stable version is available. MySQL Chinese Network: imysql.cn MySQL optimization, training, solutions, Technical Support imysql.cn /? Q = node/148
 
Today, I got a mysql installation package free and decompressed it directly. I don't know how to start it.

Run cmd.
CD to the BIN directory of Mysql
Run
Mysqld
If no error occurs, the server is started.

Then open another cmd.
Or CD to the BIN directory of Mysql
Run
Mysql
In this way, the client can also be used.