mysql5.7.17二进制包_mysql5.7二进制包安装方法
1.部署
tar xf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.17-linux-glibc2.5-x86_64 /application/mysql-5.7.17
ln -s /application/mysql-5.7.17 /application/mysql
2.授權
chown -R mysql.mysql /application/mysql-5.7.17
3.初始化
/application/mysql-5.7.17/bin/mysqld --initialize --user=mysql --basedir=/application/mysql-5.7.17 --datadir=/application/mysql-5.7.17/data
記錄初始密碼(一定要記錄)
A temporary password is generated for root@localhost: );xf/h%lm6iR
4.拷貝配置文件和啟動文件
cp /application/mysql-5.7.17/support-files/my-default.cnf /etc/my.cnf
cp /application/mysql-5.7.17/support-files/mysql.server /etc/init.d/mysqld
5.修改啟動文件內容
sed 's#/usr/local#/application#g' /application/mysql-5.7.17/bin/mysqld_safe /etc/init.d/mysqld -i
6.啟動
/etc/init.d/mysqld start
7.修改root密碼
mysqladmin -uroot -p password '123456'
8.設置開機自啟動
chkconfig mysqld on
chkconfig --list mysqld
9.啟動數據庫
/etc/init.d/mysqld start
netstat -lntup|grep 3306
注意,因為-DMYSQL_UNIX_ADDR=/application/mysql-5.6.36/tmp/mysql.sock這條參數會導致找不到pid文件,創建參數指定的路徑即可
10.設置環境變量(便于修改)
echo 'PATH=/application/mysql/bin/:$PATH' >>/etc/profile
tail -1 /etc/profile
source /etc/profile
echo $PATH
mysql
11.清理用戶和無用的數據庫(按個人環境清理)
select user,host from mysql.user;
drop user ''@'db01';
drop user ''@'localhost';
drop user 'root'@'db01';
drop user 'root'@'::1';
select user,host from mysql.user;
drop database test;
show databases
最后檢查結果如下
總結
以上是生活随笔為你收集整理的mysql5.7.17二进制包_mysql5.7二进制包安装方法的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: python天气预报官网_python
- 下一篇: java的构造函数格式_来自模板化对象的