1、安装MySQL
首先执行下面三条命令:
$ sudo apt-get install mysql-server
$ sudo apt-get isntall mysql-client
$ sudo apt-get install libmysqlclient-dev
安装成功后可以通过下面的命令测试是否安装成功:
$ sudo netstat -tap | grep mysql
tcp6 0 0 [::]:mysql [::]:* LISTEN 5994/mysqld
可以通过如下命令进入MySQL服务:
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.21-0ubuntu0.17.10.1 (Ubuntu)
Copyright (c) 2000, 2018, 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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
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
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| engine_cost |
| event |
| func |
| general_log |
| gtid_executed |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| innodb_index_stats |
| innodb_table_stats |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| proxies_priv |
| server_cost |
| servers |
| slave_master_info |
| slave_relay_log_info |
| slave_worker_info |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
31 rows in set (0.00 sec)
mysql> quit
Bye
$
2、配置远程访问
a、编辑文件
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉bind-address = 127.0.0.1
b、修改用户权限
登录MySQL:mysql -u root -p
用户权限:grant all on *.* to root@'%' identified by 'root'; --添加一个用户名是root且密码是root的远程访问用户
刷新:flush privileges;
查看是否添加成功:select user,host,authentication_string from mysql.user; ----在5.7中用户密码是列authentication_string
退出:quit
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.7.21-0ubuntu0.17.10.1 (Ubuntu)
Copyright (c) 2000, 2018, 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';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host,authentication_string from mysql.user;
+------------------+-----------+-------------------------------------------+
| user | host | authentication_string |
+------------------+-----------+-------------------------------------------+
| root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| debian-sys-maint | localhost | *75CFBCAC74DFDA2D9AE2F825F2AC45A015977368 |
| root | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+------------------+-----------+-------------------------------------------+
5 rows in set (0.00 sec)
mysql> quit
Bye
$
c、重启MySQL服务
service mysql restart
现在在Windows下可以使用navicat远程连接Ubuntu下的MySQL服务参考:https://www.linuxidc.com/Linux/2017-06/144805.htm