Use of MySQL

Cmd Next cmd Next mysql Common database commands

cd E:\phpstudy_pro\Extensions\MySQL5.7.26\bin

stay bin File operation

net start mysql;  net stop mysql;

Then input mysql -uroot -p123456  Press enter to enter directly mysql database , Appear to  mysql>  The beginning indicates that the login is successful

1. View all databases show databases;
2. Enter a specified database use user;
3. View all tables in the specified database show tables;
4. Replicated table structure  create table New table name like Original table name ;
5. Copy the data  insert into New table name select * from Original table name ;
6. Delete table drop table Table name ;
7. If you want to quit mysql database , Input exit; enter

mysql Configuration file for

Windows Next MySQL The configuration file is my.ini, It will be in the root directory of the installation directory

Linux Next MySQL The configuration file is my.cnf, It's usually placed in /etc/my.cnf,/etc/mysql/my.cnf
 

Turn on binlog journal , And take ROW The way , Turn on master-slave mode as well as logbin File location of

Modify... In the configuration file

log_bin=ON

binlog_format=ROW

server-id=1000

log-bin=/var/lib/mysql/mysql-bin

Change Password

update user set plugin='mysql_native_password',authentication_string=password('123456') where user='root';

Windows Next MySQL The restart of net stop mysql,net start mysql