mysql generic版本安装配置

 

 

下载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