流感疫情最新消息/厦门seo起梦网络科技
# 查看有没有安装MySQL：
dpkg -l | grep mysql
# 安装MySQL：
apt install mysql-server
正在读取软件包列表... 完成
正在分析软件包的依赖关系树
正在读取状态信息... 完成
将会同时安装下列软件：
libaio1 libevent-core-2.1-6 libhtml-template-perl mysql-client-5.7
mysql-client-core-5.7 mysql-common mysql-server-5.7 mysql-server-core-5.7
建议安装：
libipc-sharedcache-perl mailx tinyca
下列【新】软件包将被安装：
libaio1 libevent-core-2.1-6 libhtml-template-perl mysql-client-5.7
mysql-client-core-5.7 mysql-common mysql-server mysql-server-5.7
mysql-server-core-5.7
升级了 0 个软件包，新安装了 9 个软件包，要卸载 0 个软件包，有 237 个软件包未被升级。
需要下载 20.5 MB 的归档。
解压缩后会消耗 160 MB 的额外空间。
您希望继续执行吗？ [Y/n] y
安装完成登录
root@ubuntu:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.27-0ubuntu0.18.04.1 (Ubuntu)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
授权设置密码
mysql> grant all on *.* to root@'%' identified by 'root' with grant option;
Query OK, 0 rows affected, 1 warning (0.81 sec)
刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)
退出
mysql> exit
Bye
重新启动
root@ubuntu:~# systemctl restart mysql
远程登录设置
root@ubuntu:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.27-0ubuntu0.18.04.1 (Ubuntu)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
切换数据库
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
设置host属性
mysql> update user set host = '%' where user = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
报错可以忽略，可能已存在通过查询
mysql> select host from user where user='root';
修改配置文件
root@ubuntu:~# sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
找到bind 127.0.0.1 ::1 这一行将它注释掉
root@ubuntu:~# service mysql restart
完成