mysql的安装步骤(rpm的方式)
(1)linux上的centos7安装步骤,需要先卸载mariadb,查看rpm-qa| grep -i mariadb 包名,清除掉rpm -e 包名
rpm包的安装顺序 common > libs > clients >server
rpm -ivh mysql-community-common-5.7.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.30-1.el7.x86_64.rpm
(2)mysql的登陆命令 mysql -uroot -p
# 启动
systemctl start mysqld
# 查看状态
systemctl status mysqld
# 停止
systemctl stop mysqld
# 重启
systemctl restart mysqld
(3) 查看端口号的命令:show global variables like 'port';
(4) mysql修改端口号 vi /etc/my.cnf 添加端口port=13306; 重启/etc/init.d/mysqld restart
(5) mysql查看用户的权限:SELECT Host,User,Select_priv,Grant_priv FROM mysql.user