mysql-generic-5.5_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