centos下mysql安装

1.查看是否已经安装,并删除

rpm -qa | grep mysql
rpm -e mysql　　#普通删除模式
rpm -e –nodeps mysql　　#强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除

2.查询mysql包

yum list | grep mysql

3.安装mysql

yum install -y mysql-server mysql mysql-devel

4.查看安装

rpm -qi mysql-server

5.开机启动

chkconfig mysqld on

6.查看状态

chkconfig –list | grep mysql

7.启动、停止、重启

service mysqld start
service mysqld stop
service mysqld restart

8.设置root密码

/usr/bin/mysqladmin -u root password ‘eyaorentest’

9.授权mysql远程登录：

mysql -u root –p
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
FLUSH RIVILEGES;

10.更改mysql端口

[mysqld]
port = 13306