October 2015

解决pycurl: libcurl link-time ssl backend (nss) is different from compile-time ssl backend (none/other)

[XXX@XXX ~]$ sudo yum -y install gcc gcc-c++ make autoconf automake
There was a problem importing one of the Python modules
required to run yum. The error leading to this problem was:

   pycurl: libcurl link-time ssl backend (nss) is different from compile-time ssl backend (none/other)

Please install a package which provides this module, or
verify that the module is installed correctly.

It's possible that the above module doesn't match the
current version of Python, which is:
2.7.5 (default, Jun 24 2015, 00:41:19) 
[GCC 4.8.3 20140911 (Red Hat 4.8.3-9)]

If you cannot solve this problem yourself, please go to 
the yum faq at:
  http://yum.baseurl.org/wiki/Faq

[XXX@XXX ~]$ sudo yum -y install gcc gcc-c++ make autoconf automake

There was a problem importing one of the Python modules

required to run yum. The error leading to this problem was:

pycurl: libcurl link-time ssl backend (nss) is different from compile-time ssl backend (none/other)

Please install a package which provides this module, or

verify that the module is installed correctly.

It's possible that the above module doesn't match the

current version of Python, which is:

2.7.5 (default, Jun 24 2015, 00:41:19)

[GCC 4.8.3 20140911 (Red Hat 4.8.3-9)]

If you cannot solve this problem yourself, please go to

the yum faq at:

http://yum.baseurl.org/wiki/Faq

解决：

sudo pip uninstall pycurl
echo 'pycurl==7.19.5.1 --global-option="--with-nss"' > requires.py
sudo pip install -r requires.py

sudo pip uninstall pycurl

echo 'pycurl==7.19.5.1 --global-option="--with-nss"' > requires.py

sudo pip install -r requires.py

By sean, 9 years10/27/2015 ago

vim设置set mouse=a后鼠标右健无法复制配置文件中的set mouse=a启动了所有模式, vim接管了鼠标的控制。其中涉及的背景知识是：鼠标事件有两种处理方式，程序处理和 X 处理。如果 X 负责处理，则是左键选择，中间粘贴。要让 vim 中由 X 负责处理，有两个方法： 1. 按住 shift 键，然后选择，此时由 X 处理该选择，copy 选项就 enable 了。如果放掉shift键，则由 vim 处理该选择。 2. 在 .vimrc 中设置 set mouse= （就是说清空），此时vim永远不再干涉鼠标选择，永远把处理权交给 X，这个时候鼠标就处于无模式编辑状态，当然也能用鼠标来切换vim里面的tab窗口了，vim中的编辑光标也不会跟随鼠标了。 ——————————– vim的一些技巧：不按Esc而是按^[或者^c，速度快很多学会几个定位键的区别:0, $, {, }, g, G, w, e, b… o, Read more…

By sean, 9 years10/24/2015 ago

未分类

CentOS 7 安装mysql

2019-07-12 update: 安装mysql5.6

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-server
systemctl start mysqld
#登录重置密码, 设置为root
# mysql > set password for 'root'@'localhost' = password('root');
#设置远程访问
# mysql > use mysql;
# mysql > GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";

#设置utf-8字符集
#修改mysql配置文件 /etc/my.cnf   添加
[client]
default-character-set=utf8
 
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
 
#重启mysql服务后才生效
systemctl restart mysql
#查看字符集
show variables like 'character%';

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpm

yum install mysql-server

systemctl start mysqld

#登录重置密码, 设置为root

# mysql > set password for 'root'@'localhost' = password('root');

#设置远程访问

# mysql > use mysql;

# mysql > GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";

#设置utf-8字符集

#修改mysql配置文件 /etc/my.cnf 添加

[client]

default-character-set=utf8

[mysqld]

character-set-server=utf8

collation-server=utf8_general_ci

#重启mysql服务后才生效

systemctl restart mysql

#查看字符集

show variables like 'character%';

http://www.cnblogs.com/starof/p/4680083.html 一、系统环境 yum update升级以后的系统版本为

[root@yl-web yl]# cat /etc/redhat-release 
CentOS Linux release 7.1.1503 (Core)

1 2	[root@yl-web yl]# cat /etc/redhat-release CentOS Linux release 7.1.1503 (Core)

二、mysql安装一般网上给出的资料都是

#yum install mysql
#yum install mysql-server
#yum install mysql-devel

#yum install mysql

#yum install mysql-server

#yum install mysql-devel

安装mysql和mysql-devel都成功，但是安装mysql-server失败，如下：

[root@yl-web yl]# yum install mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.sina.cn
 * extras: mirrors.sina.cn
 * updates: mirrors.sina.cn
No package mysql-server available.
Error: Nothing to do

[root@yl-web yl]# yum install mysql-server

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

* base: mirrors.sina.cn

* extras: mirrors.sina.cn

* updates: mirrors.sina.cn

No package mysql-server available.

Error: Nothing to do

查资料发现是CentOS 7 版本将MySQL数据库软件从默认的程序列表中移除，用mariadb代替了。有两种解决办法： 1、方法一：安装mariadb MariaDB数据库管理系统是MySQL的一个分支，主要由开源社区在维护，采用GPL授权许可。开发这个分支的原因之一是：甲骨文公司收购了MySQL后，有将MySQL闭源的潜在风险，因此社区采用分支的方式来避开这个风险。MariaDB的目的是完全兼容MySQL，包括API和命令行，使之能轻松成为MySQL的代替品。安装mariadb，大小59 M。

[root@yl-web yl]# yum install mariadb-server mariadb

1	[root@yl-web yl]# yum install mariadb-server mariadb

mariadb数据库的相关命令是： systemctl start mariadb #启动MariaDB systemctl stop mariadb #停止MariaDB systemctl restart mariadb #重启MariaDB systemctl enable mariadb #设置开机启动所以先启动数据库

[root@yl-web yl]# systemctl start mariadb

1	[root@yl-web yl]# systemctl start mariadb

然后就可以正常使用mysql了

[root@yl-web yl]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.41-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]&gt; show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]&gt;

[root@yl-web yl]# mysql -u root -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 3

Server version: 5.5.41-MariaDB MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| test |

+--------------------+

4 rows in set (0.00 sec)

MariaDB [(none)]>

安装mariadb后显示的也是 MariaDB [(none)]> ，可能看起来有点不习惯。下面是第二种方法。 Read more…

By sean, 9 years10/19/2015 ago

M	T	W	T	F	S	S
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

未分类

解决pycurl: libcurl link-time ssl backend (nss) is different from compile-time ssl backend (none/other)

OS

vim及插件使用

未分类

CentOS 7 安装mysql