MySQL usage

1、 Sign in mysql

sudo mysql -u root -p

Input password

2、 view the database

show databases

3、 Using a database

use xxx

4、 Create database

CREATE DATABSE mydatabase( Database name ) [character set utf8 ( Encoding mode )] ;  #  With  utf8  Encoding set 
 Create database （ Easy to display Chinese ）, Don't specify , The default setting is  latin1  For coding 
SHOW DATABASES;    # Show current database 
USE mydatabase;         # Use the just created  mydatabase  database 
CREATE TABLE users(username char (50) NULL,passwd char(50) NULL); # Create a table 

5、 insert data

INSERT INTO users(username, passwd) VALUES('lilei','1234');
INSERT INTO users(username, passwd) VALUES(' Han Meimei ','1234');

6、 Configure remote access

Modify the configuration file
Configure remote access mysql：vim /etc/mysql/mysql.conf.d/mysqld.cnf
Comment out ： bind-address = 127.0.0.1
vim Comment out the line change instruction under the editor , And save exit .

7、 Create a new user

Generally for safety , We don't use... Directly root user , Instead, choose to create a new user .
In the server , Input mysql -u root -p , go in mysql,
Then type the following command to create the user
GRANT ALL ON . to [email protected]‘ip’ IDENTIFIED BY ‘pwd’;
There's no mention of authority here ,
user It's the user name you want to create
ip Is the access address ,% On behalf of remote access ,localhost It's a local visit , It can also be specific to a certain ip Address , What we are going to use here is %
pwd It's the password you want to create
The user created above is a user with all permissions , It can be understood as second only to root user , It's an administrator .
After creation, you can refresh the permission table
FLUSH PRIVILEGES;
It's OK without refreshing , Because we can restart mysql.
sudo /etc/init.d/mysql restart