Ubuntu 安装 Mysql server

安装

很简单，两行命令

sudo apt-get update
sudo apt-get install mysql-server

启动

启动命令

sudo /etc/init.d/mysql start

停止命令

sudo /etc/init.d/mysql stop

查看运行状态

sudo /etc/init.d/mysql status

创建用户并授权

1. 进入mysql 客户端

使用 sudo mysql 命令进入客户端

2. 创建用户

## 创建用户
create user test@'%' identified by 'test';

## 授权
grant all privileges on *.* to test@'%';

## 刷新权限
flush privileges;

3. 修改 mysql 访问ip

mysql 安装后默认只能本地访问，要想从其他服务器或者远程客户端访问，需修改参数bind-address。

打开配置文件/etc/mysql/mysql.conf.d/mysqld.cnf，修改bind-address的参数值

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

修改完成后重启 mysql 服务

sudo /etc/init.d/mysql restart

4. 测试远程访问

如下图，远程客户端访问成功

5. 开启binlog

1) 登录MySQL, 查看binlog日志的状态

mysql> show variables like '%log_bin%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin                         | OFF   |
| log_bin_basename                |       |
| log_bin_index                   |       |
| log_bin_trust_function_creators | OFF   |
| log_bin_use_v1_row_events       | OFF   |
| sql_log_bin                     | ON    |
+---------------------------------+-------+
6 rows in set (0.00 sec)

log_bin OFF 说明是关闭状态

2) 开启MySQL binlog日志

server-id               = 1

log_bin = /var/log/mysql/mysql-bin.log

3) 重启MySQL

sudo /etc/init.d/mysql restart

4) 登录MySQL, 查看binlog日志的状态

mysql> show variables like '%log_bin%';
+---------------------------------+--------------------------------+
| Variable_name                   | Value                          |
+---------------------------------+--------------------------------+
| log_bin                         | ON                             |
| log_bin_basename                | /var/log/mysql/mysql-bin       |
| log_bin_index                   | /var/log/mysql/mysql-bin.index |
| log_bin_trust_function_creators | OFF                            |
| log_bin_use_v1_row_events       | OFF                            |
| sql_log_bin                     | ON                             |
+---------------------------------+--------------------------------+
6 rows in set (0.00 sec)

log_bin ON 说明是开启状态