Centos7.2 mysql安装
来源:互联网 发布:朗读配音软件 编辑:程序博客网 时间:2024/06/03 10:22
yum install wget
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm;
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm;
sudo yum install mysql-server
$ mysql -u root
登录时有可能报这样的错:ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2),原因是/var/lib/mysql的访问权限问题。
sudo chown -R root:root /var/lib/mysql
root
然后,重启服务:
service mysqld restart
接下来登录重置密码:
mysql -u root
use mysql
select user,host,password from mysql.user;
update user set password='*BF7B173F1C146F576CC267F0BAEF5589A08404FB' where user='root';
//root123456
commit;
FLUSH PRIVILEGES;
退出前一定要创建新用户
create user 'iki'@'%' identified by 'root123456';
grant all privileges on *.* to iki@'%';
flush privileges;
delete from user where host='';//连不上的时候加这句
exit
yum install iptables-services
sudo vim /etc/sysconfig/iptables
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
sudo service iptables restart
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm;
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm;
sudo yum install mysql-server
$ mysql -u root
登录时有可能报这样的错:ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2),原因是/var/lib/mysql的访问权限问题。
sudo chown -R root:root /var/lib/mysql
root
然后,重启服务:
service mysqld restart
接下来登录重置密码:
mysql -u root
use mysql
select user,host,password from mysql.user;
update user set password='*BF7B173F1C146F576CC267F0BAEF5589A08404FB' where user='root';
//root123456
commit;
FLUSH PRIVILEGES;
退出前一定要创建新用户
create user 'iki'@'%' identified by 'root123456';
grant all privileges on *.* to iki@'%';
flush privileges;
delete from user where host='';//连不上的时候加这句
exit
yum install iptables-services
sudo vim /etc/sysconfig/iptables
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
sudo service iptables restart
阅读全文
0 0
- centos7.2安装mysql
- CentOS7.2安装MySQL
- Centos7.2 mysql安装
- CentOS7.2下安装Mysql
- centOS7.2快速安装mysql
- CentOS7.2编译安装Mysql
- CentOS7.2安装MySQL 5.7.10
- centos7编译安装mysql之2
- 腾讯云centos7.2安装mysql
- centos7.2 安装mysql 5.6.26
- centos7.2 PHP7安装mysql 扩展
- 阿里云Centos7.2安装MySQL
- centos7.2安装mysql-5.7.20
- centos7.2用yum安装mysql
- centos7上安装mysql
- CentOS7安装mysql
- centos7 安装mysql
- CentOS7 安装 mysql
- 无
- 1!+2!+3!+4!+...n! 0<n<=20
- 前台登陆验证以及短信验证
- 模板基础知识2——《C++程序设计语言(第四版)》第24章 泛型算法 笔记
- 采用el表达式的fn函数,如何进行替换函数并且拼接其他字符串再进行替换
- Centos7.2 mysql安装
- 使用AudioTrack实现声音播放
- 知识不是原创的,但是文章确实是我一个字一个字敲出来的
- 课程设计
- 感谢 Google 开发者大会合作媒体伙伴
- JAVA 的特点:
- JAVA 的特点:
- 前端开发知识体系汇总
- 十二月 19, 2017 8:45:03 上午 org.apache.catalina.core.StandardContext listenerStart 严重: Exception sending