Linux安装MySQL

发表于 更新于 分类于 ， 阅读次数：

Linux Ubuntu apt-get安装MySQL

apt-get更新到最新

1
sudo apt-get update

安装 mysql-client-core-5.7

1
sudo apt-get install mysql-client-core-5.7

安装 mysql-client-5.7

1
sudo apt-get install mysql-client-5.7

安装 mysql-server-5.7

1
sudo apt-get install mysql-server-5.7

注意：在安装的时候会让你输入一个密码，此密码是mysql数据库root用户的密码，请记住自己输入的密码，此密码和服务器root用户的密码不是同一个。

1
2
3
4
5
6
7
8
9
10
11
12
┌─────────────────────────────────────────┤ Configuring mysql-server-5.7 ├─────────────────────────────────────────┐
│ While not mandatory, it is highly recommended that you set a password for the MySQL administrative "root" user.  │
│                                                                                                                  │
│ If this field is left blank, the password will not be changed.                                                   │
│                                                                                                                  │
│ New password for the MySQL "root" user:                                                                          │
│                                                                                                                  │
│ ________________________________________________________________________________________________________________ │
│                                                                                                                  │
│                                                      <Ok>                                                        │
│                                                                                                                  │
└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘

密码输入完后,按 [shift+enter] 进行确定 !!!

重启服务

1
service mysql restart

查看服务状态

1
service mysql status

服务开启输出的内容

1
2
3
4
5
6
7
8
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2018-12-13 14:36:48 CST; 15s ago
  Process: 26464 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=exited, status=0/SUCCESS)
  Process: 26450 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 26462 (mysqld)
   CGroup: /system.slice/mysql.service
           └─26462 /usr/sbin/mysqld

Linux centOS wget安装MySQL

1
2
3
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
yum -y install mysql-server

默认配置文件路径

配置文件 : /etc/my.cnf
日志文件 : /var/log/mysqld.log
服务启动脚本 : /usr/lib/systemd/system/mysqld.service
socket文件 : /var/run/mysqld/mysqld.pid

安装完成后，密码为随机密码，需要重置密码

启动mysql服务

1
service mysqld restart

重置密码

1
grep "password" /var/log/mysqld.log

显示以下格式日志

1
2019-03-27T11:03:55.199916Z 1 [Note] A temporary password is generated for root@localhost: hRd>NyG/K4ho

hRd>NyG/K4ho 为随机密码

登录MySQL

1
mysql -u root -p

修改密码

1
alter user 'root'@'localhost' identified by '123456';

刷新权限

1
flush privileges;

指令和上面ubuntu差不多 mysql 改成 mysqld

设置用户 root 可以在任意 IP 下被访问

1
2
3
grant all privileges on *.* to root@'%' identified by '123456';

flush privileges;

Ubuntu安装Mysql时没有提示设置密码问题

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
$sudo vim /etc/mysql/debian.cnf

$mysql -u debian-sys-maint -p


use mysql;

update mysql.user set authentication_string=password('123456') where user='root' and Host ='localhost';

update user set plugin="mysql_native_password";

flush privileges;

quit;


$sudo service mysql restart

docker容器化部署数据库Mysql

1
2
3
4
5
6
docker run -p 3306:3306 --name mysql5.7 \
-v /usr/local/docker/mysql/conf:/etc/mysql \
-v /usr/local/docker/mysql/logs:/var/log/mysql \
-v /usr/local/docker/mysql/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7