apt install mysql-server

apt install mysql-server

sudo mysql_secure_installation utility

xxxxxxxxxx

sudo mysql_secure_installation utility

sudo systemctl start mysql
sudo systemctl enable mysql

xxxxxxxxxx

sudo systemctl start mysql

sudo systemctl enable mysql

/usr/bin/mysql -u root -p
#root是用户名，输入这条命令按回车键后系统会提示你输入密码

mysql -u root -p'password' -h remote.mysqlsqlserver.com -P 59066 -D DatabaseName

xxxxxxxxxx

/usr/bin/mysql -u root -p

#root是用户名，输入这条命令按回车键后系统会提示你输入密码

​

mysql -u root -p'password' -h remote.mysqlsqlserver.com -P 59066 -D DatabaseName

UPDATE mysql.user SET authentication_string = PASSWORD('password') WHERE User = 'root';

xxxxxxxxxx

UPDATE mysql.user SET authentication_string = PASSWORD('password') WHERE User = 'root';

SELECT User, Host, authentication_string FROM mysql.user;

xxxxxxxxxx

SELECT User, Host, authentication_string FROM mysql.user;

 CREATE DATABASE demodb;
 create user demouser@localhost identified by 'demopassword';

xxxxxxxxxx

 CREATE DATABASE demodb;

 create user demouser@localhost identified by 'demopassword';

GRANT ALL PRIVILEGES ON demodb.* to demouser@localhost;
# 如果是对于任意IP都允许 - 用 %
GRANT SELECT,INSERT,UPDATE,DELETE ON guaca.* TO 'guaca'@'%';

SHOW GRANTS FOR 'demouser'@'localhost';

xxxxxxxxxx

GRANT ALL PRIVILEGES ON demodb.* to demouser@localhost;

# 如果是对于任意IP都允许 - 用 %

GRANT SELECT,INSERT,UPDATE,DELETE ON guaca.* TO 'guaca'@'%';

​

SHOW GRANTS FOR 'demouser'@'localhost';

FLUSH PRIVILEGES;

xxxxxxxxxx

FLUSH PRIVILEGES;