ubuntu安装MySQL
sudo apt-get update #更新源
sudo apt-get install mysql-server #安装
查看mysql 状态
systemctl status mysql
或者, 两个命令都可以
service mysql status
关闭mysql服务
service mysql stop
登陆MySQL
# 以root用户登陆
sudo mysql -u root -p # -u 指定用户名 -p需要输入密码
查看默认数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
注:
mysql数据库里有user表,这个表里放了user、host相关的一些信息
show tables from mysql;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| component |
| db |
...
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
查看用户和主机对应关系
mysql 数据库下的user表
select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | % |
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
+------------------+-----------+
配置MySQL远程登陆
1 修改配置文件,
vim /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉 bind-address = 127.0.0.1
2 保存退出,然后重新进入mysql服务
3 查看当前主机配置信息
select user,host from user;
注:
若当前主机配置为 localhost, 将Host设置为通配符%
update user set host = '%' where user ='root';
4 修改后要刷新一下
flush privileges
5 退出数据库后重启数据库服务
sudo /etc/init.d/mysql restart #重启mysql服务