1.先检查cnetos是否安装自带数据库:
rpm -qa | grep mariadb
若有删除mariadb:
yum remove 检查到的包
2.上传perl-Data-Dumper-2.145-3.el7.x86_64到/usr/local下然后进入此目录,安装per-data-dumper包:
rpm -ivh perl-Data-Dumper-2.145-3.el7.x86_64.rpm
3.建立mysql用户和组:
groupadd mysql
useradd -g mysql mysql
4.上传mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz到/usr/local/下,解压并改名
tar -zxvf mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.6.36-linux-glibc2.5-x86_64 mysql
5.把mysql文件夹所有者修改为mysql用户和组
cd /usr/local/mysql
chown -R mysql:mysql ./
6.安装mysql
./scripts/mysql_install_db --user=mysql #安装后在/usr/local/mysql有文件my.cnf为mysql系统配置文件需要修改,修改模板另外给出(my.cnf可以直接上传覆盖)
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld #复制启动程序到linux启动项中
7.在修改一下data目录的所有权:
chown -R mysql:mysql data
8.加执行权:
chmod +x /etc/rc.d/init.d/mysqld
做成自动服务:
chkconfig --add mysqld
9.启动:
service mysqld start
查看是否启动:
service mysqld status
显示:SUCCESS! MySQL running (进程ID)则成功
配置开机启动:
systemctl enable mysqld
systemctl daemon-reload
10.添加环境变量:
vi /etc/profile
加入命令:export PATH="/usr/local/mysql/bin:$PATH"
立即生效:source /etc/profile
11.登录mysql:
mysql -u root
显示这些表示成功:Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4。。。。。。
12.更改mysql中root用户的密码(密码必须是字母大小写和符号组合安装后root是没有初始密码的可以直接登录):
mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD('newpasswd') WHERE user = 'root';
#UPDATE user SET Password = PASSWORD('123456') WHERE user = 'root';
mysql> FLUSH PRIVILEGES;
13.设置远程可以访问:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
14. .sql文件导入数据库:
mysql -u root -p 输入密码进入---
mysql>use database_name #database_name 替换成需要还原的数据库
mysql>source /root/xxxx.sql #选择备份数据对应路径即可完成
rpm -qa | grep mariadb
若有删除mariadb:
yum remove 检查到的包
2.上传perl-Data-Dumper-2.145-3.el7.x86_64到/usr/local下然后进入此目录,安装per-data-dumper包:
rpm -ivh perl-Data-Dumper-2.145-3.el7.x86_64.rpm
3.建立mysql用户和组:
groupadd mysql
useradd -g mysql mysql
4.上传mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz到/usr/local/下,解压并改名
tar -zxvf mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.6.36-linux-glibc2.5-x86_64 mysql
5.把mysql文件夹所有者修改为mysql用户和组
cd /usr/local/mysql
chown -R mysql:mysql ./
6.安装mysql
./scripts/mysql_install_db --user=mysql #安装后在/usr/local/mysql有文件my.cnf为mysql系统配置文件需要修改,修改模板另外给出(my.cnf可以直接上传覆盖)
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld #复制启动程序到linux启动项中
7.在修改一下data目录的所有权:
chown -R mysql:mysql data
8.加执行权:
chmod +x /etc/rc.d/init.d/mysqld
做成自动服务:
chkconfig --add mysqld
9.启动:
service mysqld start
查看是否启动:
service mysqld status
显示:SUCCESS! MySQL running (进程ID)则成功
配置开机启动:
systemctl enable mysqld
systemctl daemon-reload
10.添加环境变量:
vi /etc/profile
加入命令:export PATH="/usr/local/mysql/bin:$PATH"
立即生效:source /etc/profile
11.登录mysql:
mysql -u root
显示这些表示成功:Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4。。。。。。
12.更改mysql中root用户的密码(密码必须是字母大小写和符号组合安装后root是没有初始密码的可以直接登录):
mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD('newpasswd') WHERE user = 'root';
#UPDATE user SET Password = PASSWORD('123456') WHERE user = 'root';
mysql> FLUSH PRIVILEGES;
13.设置远程可以访问:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
14. .sql文件导入数据库:
mysql -u root -p 输入密码进入---
mysql>use database_name #database_name 替换成需要还原的数据库
mysql>source /root/xxxx.sql #选择备份数据对应路径即可完成