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