rpm -qa | grep mysql
1
注:没有返回信息,说明未安装mysql
rpm -qa|grep -i mariadb
1
rpm -qa|grep mariadb|xargs rpm -e --nodeps
1
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
1
rpm -ivh mysql-community-release-el7-5.noarch.rpm
1
yum repolist all | grep mysql
1
yum install mysql-server
1
检查mysql是否安装成功
rpm -qa | grep mysql
1
systemctl start mysqld.service
1
systemctl restart mysqld.service #重启 systemctl stop mysqld.service #停止 systemctl enable mysqld.service #设置开机启动
mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("这里输入密码") where User='root';
mysql> flush privileges;
1234
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '上一步设置的密码';
1
vi /etc/my.cnf
1
在[mysqlld]节点下添加内容:lower_case_table_names=1
注:不要添加在[mysqld_safe]节点后面,否则无法生效
重启mysql
systemctl restart mysqld
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。