下载linux generic版本tar.gz文件,如:mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
解压到目标目录,如: /test/mysql-5.7.18-linux-glibc2.5-x86_64
解压后创建data、log目录
创建my.cnf文件
[mysqld]
basedir=/szmetro/mysql-3306
datadir=/szmetro/mysql-3306/data
socket=/szmetro/mysql-3306/mysql.sock
port = 3306
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
basedir=/szmetro/mysql-3306
datadir=/szmetro/mysql-3306/data
socket=/szmetro/mysql-3306/mysql.sock
port = 3306
log-error=/szmetro/mysql-3306/log/mysql.log
pid-file=/szmetro/mysql-3306/mysql.pid
[mysql]
socket=/szmetro/mysql-3306/mysql.sock
port = 3306
[mysqladmin]
socket=/szmetro/mysql-3306/mysql.sock
port = 3306
1、初始化: ./mysqld --defaults-file=../my.cnf --initialize --user=root --console
2、启动: nohup ./mysqld_safe --defaults-file=../my.cnf --user=root >/dev/null 2>&1 &
3、连接:./mysql --defaults-file=../my.cnf -uroot -p
4、重置密码:
mysql> set password=password('xxxxx@2017');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
5、关闭服务器:
./mysqladmin --defaults-file=../my.cnf shutdown -uroot -pxxxx@2017
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH
GRANT OPTION