mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz -》/opt/mysql5
mkdir /opt/mysql5/log
rm -rf /etc/my.cnf
vim /opt/mysql5/my.cnf
[mysqld]
port=3306
datadir=/opt/mysql5/data
lower_case_table_names=1
[mysqld_safe]
log-error=/opt/mysql5/log/mysqld.log
pid-file=/opt/mysql5/mariadb.pid
安装前置软件
yum -y install java pcre-devel zlib-devel perl-Data-Dumper
创建mysql用户并赋权目录
useradd mysql
chown -R mysql:mysql /opt/mysql5
初始化:
/opt/mysql5/scripts/mysql_install_db --user=mysql --basedir=/opt/mysql5 --datadir=/opt/mysql5/data --defaults-file=/opt/mysql5/my.cnf
启动:
/opt/mysql5/bin/mysqld_safe &
修改密码:
/opt/mysql5/bin/mysqladmin -u root password 'root'
登录:
/opt/mysql5/bin/mysql -u root -p
允许ROOT远程登录:
CREATE USER 'root'@'%' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;