mysql安装部署

mysql安装部署
1、解压安装包
tar -xf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.24-linux-glibc2.12-x86_64 /usr/local/mysql
2、安装
cd /usr/local/mysql
bin/mysqld --initialize --user=root --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
记录下此步骤生成的随机密码，后续登录服务会用到。
3、复制启动文件
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
cp bin/my_print_defaults /usr/bin/
4、修改启动脚本
vi /etc/init.d/mysqld
修改内容：
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port=3306
5、加入环境变量
vi ~/.bash_profile
export PATH=$PATH:/usr/local/mysql/bin
执行source命令刷新环境变量
source ~/.bash_profile
6、修改mysql配置文件
vi /usr/local/mysql/my.cnf
[mysqld]
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock
user=root
port=3306
skip-external-locking
key_buffer_size=512M
max_allowed_packet=16M
table_open_cache=512
sort_buffer_size=4M
net_buffer_length=8k
read_buffer_size=4M
read_rnd_buffer_size=512k
myisam_sort_buffer_size=32M
thread_cache_size=64
query_cache_size=64M
tmp_table_size=64M
lower_case_table_names=1 //表名不区分大小写
max_connections=500
max_connect_errors=100
open_files_limit=65535
log-bin=slave-bin //开启bin-log日志
#binlog_format=mixed
server-id=20
expire_logs_days=10
default_storage_engine=InnoDB
log-slave-updates = true //从库作为其他从库的主库时必须添加此配置

[mysqldump]
quick
max_allowed_packet=16M

[mysqld_safe]
log-error=/usr/local/mysql/data/error.log
pid-file=/usr/local/mysql/data/myse.pid
7、服务的启动和停止
/etc/init.d/mysqld start
/etc/init.d/mysqld stop
8、如果启动失败则删除data文件重新执行
bin/mysqld --initialize --user=root --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
9、登录服务修改默认密码
mysql -uroot -p’xxxxx’ //登录服务，密码使用第二步生成的随机密码。
alter user user() identified by “123456”; //修改登录用户登录密码