前期准备:
方式一、 https://www.mysql.com/ ,下载安装包
方式二、
下载安装包命令:
mkdir /usr/local/mysql
cd /home
wget http://dev.MySQL.com/get/Downloads/MySQL-5.7/mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz
2.解压并复制
将下载在/home目录下的压缩包进行解压
tar -xvf mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.11-linux-glibc2.5-x86_64/* /usr/local/mysql/
mkdir /usr/local/mysql/data
3.创建mysql用户组和修改权限
groupadd mysql
useradd -g mysql mysql
chown -R mysql.mysql /usr/local/mysql/
4.初始化数据
初始化命令,初始化成功的情况下,会产生一个随机的默认密码,有必要保留一下(未看到也没关系,安装后用命令查找:
cat /root/.mysql_secret )。
[root@localhost mysql] ./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
可能出现会出现的问题:https://blog.csdn.net/weixin_37766721/article/details/106924564
5.mysql的服务脚本放到系统服务中
cp -a ./support-files/mysql.server /etc/init.d/mysqld
6.修改my.cnf文件内容
basedir:安装位置 , datadir:数据存放位置
# These are commonly set, remove the # and set as required.
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
# server_id = .....
socket = /tmp/mysql.sock
character-set-server = utf8
# 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
7.启动mysql
service mysqld start
8.修改密码
之前保留随机密码,直接输入进去修改
mysql -u root mysql
update mysql.user set password=password('新密码') where user='root' and host='localhost';
如未保存,查看我的另一篇:https://blog.csdn.net/weixin_37766721/article/details/106924458
以下步骤,看个人需要
9.创建快捷方式
ln -s /usr/local/mysql/bin/mysql /usr/bin
10.将mysql命令配置到全局变量中
①当前会话有效
直接运行命令 export PATH=$PATH:/usr/local/webserver/mysql/bin
②当前登录用户有效
vi ~/.bash_profile修改文件中PATH一行,将/usr/local/webserver/mysql/bin 加入到PATH= P A T H : PATH: PATH:HOME/bin一行之后
③永久有效 修改/etc/profile文件使其永久性生效,并对所有系统用户生效,在文件末尾加上如下两行代码
PATH=$PATH:/usr/local/webserver/php/bin:/usr/local/webserver/mysql/bin
export PATH
11.Linux设置Mysql开机自启动服务
- 将服务文件拷贝到init.d下,并重命名为mysqld
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
- 赋予可执行权限
chmod +x /etc/init.d/mysqld
- 添加服务
chkconfig --add mysqld
- 显示服务列表
chkconfig --list
注:如果看到mysql的服务,并且3,4,5都是开的话则成功; 如果是关,则 chkconfig --level 345 mysqld on
- 重启电脑
reboot 就可以看到mysql服务开机自启。