2018年03月_Joey_Hong

12月 11月 03月

转载解决httpd: Could not reliably determine the server's fully qualified domain name

vi /etc/httpd.conf将里面的 #ServerName 127.0.0.1:80 注释去掉即可。

2018-03-31 18:59:19 3419

转载 CentOs7 Mysql开启远程访问

然后设置root用户的远程访问权限在mysql控制台执行:1. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyPassword' WITH GRANT OPTION;2. FLUSH PRIVILEGES;

2018-03-29 15:00:04 2507

转载 Centos7下yum安装PHP,Apache，Mysql

安装php7由于yum源的php版本较低，所以需要找到高版本的rpm源yum -y install epel-release rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm yum install php70w123安装常见扩展yum install php70w-common yum install php70w...

2018-03-29 14:44:43 951

转载 CentOS 7.2 yum方式安装MySQL 5.7

CentOS 7.2 yum方式安装MySQL 5.7CentOS 7之后的版本yum的默认源中使用MariaDB替代原先MySQL，因此安装方式较为以往有一些改变：下载mysql的源wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm 安装yum库yum localinstall -y mysql57-c...

2018-03-29 13:42:59 175

转载 mysql 报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin

解决办法1、修改用户密码mysql> alter user 'root'@'localhost' identified by 'youpassword'; 2、刷新权限mysql> flush privileges;

2018-03-28 22:29:17 1803 1

转载 MySQL添加新用户、为用户创建数据库、为新用户分配权限

登录MySQL[plain] view plain copy mysql -u root -p 添加新用户允许本地 IP 访问 localhost, 127.0.0.1[plain] view plain copy create user 'test'@'localhost' identified by '123456'; 允许外网 IP 访问[plain] view plain copy c...

2018-03-28 17:02:11 180

转载 mac 连接mysql提示 mysqli::real_connect(): (HY000/2002): No such file or directory

mac 连接mysql提示 mysqli::real_connect(): (HY000/2002): No such file or directory1.首先登录MySQL命令行，查看unix socket所在目录。 mysql> STATUS--------------/usr/local/mysql/bin/mysql Ver 14.14 Distrib 5.7.15, for o...

2018-03-28 16:45:52 2557