检查是否安装mysql
rpm -qa | grep mysql 如果有 卸载mysql rpm -e mysql // 普通删除模式 rpm -e --nodeps mysql // 强力删除模式,如果使用上面命令删除时,提示有依赖的其它文件,则用该命令可以对其进行强力删除
通过yum来进行mysql的安装
yum list | grep mysql yum install -y mysql-server mysql mysql-devel查看刚安装好的mysql-server的版本
rpm -qi mysql-server
启动mysql
service mysqld start service mysqld restart
查看是否开机启动
chkconfig --list | grep mysqld chkconfig mysqld on
设置root密码
mysqladmin -u root password 'root' // 通过该命令给root账号设置密码为 root ##修改root密码 mysqladmin -u root -p123456 password root
use mysql;
UPDATE user SET Password = PASSWORD(‘newpass’) WHERE user = ‘root’;
FLUSH PRIVILEGES;
##修改远程登录授权
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ identified by “123456” WITH GRANT OPTION;
FLUSH PRIVILEGES;
centos7
yum install mariadb mariadb-server systemctl start mariadb ==> 启动mariadb systemctl enable mariadb ==> 开机自启动 mysql_secure_installation ==> 设置 root密码等相关 mysql -uroot -p123456 ==> 测试登录!
mysql rpm 安装方式
http://www.cnblogs.com/pythonal/p/6141516.html