提示,本次安装mysql使用root用户安装
1)、创建MySQL用户
groupadd mysql
useradd -r -g mysql mysql
2)、上传并解压mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz到 /usr/local下
进入 /usr/local目录下,解压安装包,并重命名
cd /usr/local
tar -zvxf mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.11-linux-glibc2.5-x86_64 mysql
3)、创建数据库存放路径
mkdir /data/mysql
mkdir /data/mysql/tmp
mkdir /data/mysql/data
4)、修改配置文件
vi /etc/my.cnf
[mysqld_safe]
log-error=/data/mysql/log/mysql.log(以下所有路径均根据实际路径填写)
pid-file=/data/mysql/run/mysqld.pid
[mysqldump]
quick
[mysql]
no-auto-rehash
[client]
default-character-set=utf8
socket=/data/mysql/run/mysql.sock
[mysqld]
basedir=/usr/local/mysql
tmpdir=/data/mysql/tmp
datadir=/data/mysql/data
default_authentication_plugin=mysql_native_password
port=3306
user=mysql
lower_case_table_names = 1
default_storage_engine = InnoDB
wait_timeout=31536000
interactive_timeout=31536000
5)、安装MySQL(安装成功后记得记下初始密码)
cd /usr/local/mysql
chown -R mysql:mysql ./
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
6)、启动MySQL
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
service mysqld start
7)、修改默认密码
cd //usr/local/mysql/bin
./mysql -uroot -p (回车输入第5步中的初始密码)
mysql>SET PASSWORD FOR ‘root’@’%’ = PASSWORD(‘new_password’);
mysql>GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘your password’ WITH GRANT OPTION; (授权用户远程登录)