Summary of common MySQL commands

Set change mysqlroot password

Enter the MySQL database for the first time.

!

You can add the absolute path of mysql to the environment variable.

You can also set the boot load.

Reload the environment variables to make MySQL take effect

Re-login to mysql -uroot

Add a password to mysql

Re-login to verify,

Change Password

Re-login verification, verification successful

Reset password, modify configuration file, skip authorization

Restart the mysql service and use the root user to authenticate without a password

Go in and modify the password file

update user set password=password('aminglinux') where user='root';

Modify my.conf after exiting

Delete the skip authorization file above

Restart the mysqld service

Re-enter mysql verification

Connect to mysql

Method 1: Use tcpip protocol ip:port, which is suitable for remote ip. This example is for local experiment.

Method 2: Use socket (assuming sock is configured in my.conf). This method is only suitable for use on the local machine.

Method 3: Use the command line, suitable for shell scripts

Common mysql commands

Query library show databases;

Switch library to use mysql;

View the tables in the library show tables;

View the field desc tb_name in the table ;

View the table creation statement show create table tb_name\G;

View the current user select user ();

View the currently used database select databsase();

Create database create database db1;

Create table use db1; create table t1( id int(4), name char(40)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Delete table drop table t1;

View the current database version select version ();

Check the database status show status ;

View each parameter show variables; wildcard show variables like 'max_connect%';

Modify the parameter set global max_connect_errors=1000; you can also modify it in /etc/my.conf

View the queue show processlist; show full processlist;