cen7布署mysql数据库
cen7之后mysql改名了,改为mariadb
1. 安装mysql 服务器端:
yum install mariadb-server
yum install mariadb-devel
2. 安装mysql客户端:
yum install mariadb
3. 启动mysql服务:
service mariadb start或者/etc/init.d/mariadb start
停止:
service mariadb stop
重启:
service mariadb restart
4. 创建root管理员:
mysqladmin -u root password 123456
5.登陆
mysql -u root -p 123456
6.创建库
create database epm_paas DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
7.如果需要远程访问此数据库,执行如下语句:(修改对应的IP,用户,密码)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;
grant create,drop,select, insert, update, delete on *.* to root@10.162.2.121 identified by '123456';
flush privileges;
grant create,drop,select, insert, update, delete on *.* to root@10.162.2.121 identified by '123456';