Linux系统下安装Mysql全过程(mysql.tar.gz)_Mysql

检查是否已经安装了mysql

rpm -qa|grep mysql

卸载mysql

rpm -e --nodeps 程序名

上传文件

mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz

解压文件，并将解压后的文件重命名，移动到/usr/local/mysql

tar -zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local/mysql
cd /usr/local/mysql

添加一个mysql 用户组

groupadd mysql

添加一个用户

useradd -r -g mysql mysql

创建文件夹用来存放数据
/usr/local/mysql/data

mkdir /usr/local/mysql/data

进入mysql包中，给这个包授权给
mysql/usr/local/mysql

 chown -r mysql:mysql ./
 chown -r mysql:mysql data

进入mysql文件名 basedir 为mysql 的路径， datadir 为mysql的 data 包，里面存放着mysql自己的包

yum install -y libaio
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

进入support-file 文件夹

cd support-files/

复制文件

cp /usr/local/mysql/support-files/mysql.server  /etc/init.d/mysqld

修改basedir= 自己的路径修改datadir= 自己的路径

vim /etc/init.d/mysqld

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

启动mysql

bin/mysqld_safe --user=mysql &
//或者
service mysqld start

加入开机启动项目

chkconfig --add mysqld
//查看开机启动項
chkconfig --list

重启mysql

/etc/init.d/mysqld restart

./mysql -uroot -p 临时密码

发生错误

执行：

ln -s /usr/local/mysql/bin/mysql /usr/bin

修改密码

set password= password('root');
//或者
alter user 'root'@'localhost' identified by 'root'; 
//刷新权限
flush privileges;
//授权新用户
grant all privileges on *.* to 'root1'@'%' identified by 'root' with grant option;

.配置全局环境变量

vi /etc/profile
//加入
path=/data/mysql/bin:/data/mysql/lib:$path
export path
//配置文件立即生效
source /etc/profile

解决数据库乱码问题
将my.cnf拷贝到/etc/下

# for advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[client]

# pipe
# # socket=0.0
port=3306
default-character-set=utf8
[mysql]
port=3306
default-character-set=utf8
#
[mysqld]
#
# remove leading # and set to the amount of ram for the most important data
# cache in mysql. start at 70% of total ram for dedicated server, else 10%.
# innodb_buffer_pool_size = 128m
#
# remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# remove leading # to set options mainly useful for reporting servers.
# the server defaults are faster for transactions and fast selects.
# adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128m
# sort_buffer_size = 2m
# read_rnd_buffer_size = 2m
datadir=/usr/local/mysql/data
#socket=/var/lib/mysql/mysql.sock
server_id=1
expire_logs_days=3
# disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
port=3306
character-set-server=utf8

log-error=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
pid-file=/usr/local/mysql/data/localhost.localdomain.pid