After opening mysql5.6 for the first time

How do I use it when I open mysql5.6 for the first time? Anonymous | browse 6,963 times recommended for 2016-01-04 12:20:26Best Answer

One, MySQL is through DOS command mode operation, so need to let DOS can find related commands, need to do a configuration, first we need to specify the MySQL service startup files, Use the Mysqld.exe command under the bin package to find this command either through the environment variable configuration, or by adding the following configuration in the My-default.ini file:

[Winmysqladmin]

# Specify the files that the MySQL service starts to start

Server=d:/yan_package/mysql-5.6.23-win32/bin/mysqld.exe

The parameters of the above diagram are explained in the following directions:

Basedir: Setting up the MySQL installation directory

DataDir: Setting the data storage directory for the MySQL database

Port: Port number

Server_id:server-id values are similar to IP addresses: These ID values uniquely identify each server instance in the replication server cluster, and if you set up a master-slave server, each server must have a unique Server-id value and not the same.

You can also set the MySQL server's character set in the configuration file DEFAULT-CHARACTER-SET=GBK

Second, My-default.ini file modified, enter the DOS command to install the MySQL service

Third, start the MySQL service

Four, in the MySQL console under the root user login, the default root user does not have a password, directly press ENTER.

After successful login, you can see which databases are available.

Add:

Stop MySQL service with net stop MySQL

Remove MySQL service with Mysqld-remove

After first opening mysql5.6