sudo yum update
sudo wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
sudo yum install mysql-server
sudo systemctl start mysqld
sudo systemctl status mysqld
При установке MySQL на CentOS 7 создаётся временный пароль root.
Введите команду ниже, чтобы увидеть его
sudo grep ‘password’ /var/log/mysqld.log
sudo mysql_secure_installation
zA9P.hyBykwa
mysql -u root -p
create database cars;
use cars;
create table new (brand varchar(10), model varchar(10), year year, price int);
create table used (brand varchar(10), model varchar(10), year year, price int);
show tables;
describe new;
nano /home/andrey/new.txt
kia cerato 2014 780000
kia RIO 2015 530000
FORD FOCUS 2015 620000
nano /home/andrey/used.txt
kia cerato 2011 460000
hyddai solaris 2012 490000
lada granta 2013 180000
mysql —local-infile=1 -u root -p
use cars;
load data local infile «/home/andrey/new.txt» into table new;
load data local infile «/home/andrey/used.txt» into table used;
select * from new;
select * from used;
insert into new (brand, model, year, price) value (‘daewoo’,’nexta’,’2012′,’120000′);
insert into new (brand, model, year, price) value (‘kia’,’cerato’,’2014′,’780000′);
insert into new (brand, model, year, price) value (‘kia’,’rio’,’2015′,’530000′);
insert into new (brand, model, year, price) value (‘ford’,’focus’,’2015′,’620000′);
delete from new where model is null;
delete from new where price is null;
