Mysql Deployment

# Download Binary

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.26-el7-x86_64.tar.gz
    tar zxvf mysql-5.7.26-el7-x86_64.tar.gz
    
# Init Database

mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql 
    mysqld --initialize --basedir=/usr/local/mysql --datadir=/data/mysql --user=pgdata
    
![title](/api/file/getImage?fileId=5d07917bf5c0f5000d0002af)

# Configuration    
    
default config file

mysqld --verbose --help |grep -A 1 'Default options'

configure mysql

```
vi /etc/my.cnf

[mysqld]
basedir=/usr/local/mysql
datadir=/data/mysql
port=20769
user=pgdata
socket=/data/mysql/mysql.sock
# 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]
log-error=/data/mysql/mariadb.log
pid-file=/data/mysql/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

```
    
    
# Start Database

cp -v /usr/local/mysql/support-files/mysql.server  /etc/init.d/
    chkconfig --add mysql.server
    service mysql.server start
    
# post install

change root password

mysqladmin -u root -p  password Mingjueinfo2015_db

connect to server

mysql -u root -p
    
change mysql root username

mysql
    > update user set user='pgdata' where user='root';
    
    service mysql.server restart

enable remote login for root user

GRANT ALL PRIVILEGES ON *.* TO 'pgdata'@'%' IDENTIFIED BY 'Mingjueinfo2015_db' WITH GRANT OPTION;
    FLUSH PRIVILEGES;

ssh -i /home/gpadmin/.ssh/id_rsa -L *:20769:localhost:20769 -Nf root@47.103.86.28

Navigation

Recent Posts

Friend Links