Centos7安装mariadb-server

centos7下mysql的替代品–mariadb

centos7下阿里云没有mysql，用mariadb替代，但登录同mysql
http://mirrors.aliyun.com/help/centos //更换服务器阿里云

sudo yum -y install mariadb-server//安装  systemctl start mariadb.service //启动服务  systemctl stop mariadb.service //关闭服务  systemctl restart mariadb.service //重启服务  systemctl enable mariadb.service //开机启动服务(未试过)  mysql -u root -p //登录mysql  (默认密码为空)

设置密码

https://www.cnblogs.com/LvLoveYuForever/p/5585197.html

mysqladmin -u root -p password newpassword

添加用户

https://www.cnblogs.com/LvLoveYuForever/p/5585197.html

修改字符集解决中文乱码

vim /etc/my.cnf //linux/* 在文件中的[mysqld]节点添加以下信息*/character-set-server=utf8default-character-set=utf8//可选择,视情况/* 然后重启服务在登录查看字符集即可 */show variables like '%character%';

centos利用wget和url下载

 wget --no-check-certificate --no-cookies --header "Cookie: oraclelicense=accept-securebackup-cookie" http://download.oracle.com/otn-pub/java/jdk/8u91-b14/jdk-8u91-linux-x64.tar.gz yum -ivh .....rpm