mysql下载链接
本次演示版本为 mysql-5.7.28 如下图所示
将下载的压缩包上传至linux虚拟机内
解压当前亚索包 至 、/usr/local/下
tar -zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
将名称改为mysql
mv mysql-5.7.28-linux-glibc2.12-x86_64 mysql
创建数据目录
cd mysql
mkdir data
创建用户组
groupadd mysql
useradd -r -g mysql mysql
赋予权限
chown mysql:mysql -R /usr/local/mysql
修改mysql配置文件
vim /etc/my.cnf
修改去下
[mysqld]
bind-address=0.0.0.0
user=mysql
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/var/lib/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=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
进去mysql的bin目录下
cd /usr/local/mysql/bin
初始化mysql
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --user=mysql --initialize
复制下初始密码
将mysql.server放置到/etc/init.d/mysql目录下
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
启动mysql
service mysql start
解决上述报错
mkdir /var/log/mariadb
touch /var/log/mariadb/mariadb.log
chown -R mysql /var/log/mariadb/
重启mysql
service mysql restart
解决无文件夹的问题 并赋予权限重启mysql
mkdir mysql
chown -R mysql /var/lib/mysql/
service mysql restart
启动成功 登录mysql
./mysql -u root -p
set password=password('XXXX');#设置自己的密码
grant all privileges on *.* to 'root'@'%' identified by 'root'; #赋予远程访问权限
flush privileges;#刷新权限
一个简单的mysql创建已经成功了,如有问题欢迎交流!