centos/Ubuntu安装python3.7.0安装mysql5.7/5.6

Python3.7

1. 下载安装所需要的包，不然安装时或者以后使用python时报错

yum install -y libffi-devel zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel zlib gcc make libpcap-devel xz-devel gdbm-devel

2. 下载python3.7.0

wget https://www.python.org/ftp/python/3.7.0/Python-3.7.0.tgz

 可以到我的分享百度网盘中下载

链接：https://pan.baidu.com/s/1lVfP0Op_FHfeGXYT6m-phQ 
提取码：o06q

3. 解压并安装

tar -zxvf Python-3.7.0.tgz
cd Python-3.7.0
./configure
make&&make install

4. 配置环境变量python3 和pip3

ln -s /usr/local/bin/python3 /usr/bin/python3

ln -s /usr/local/bin/pip3 /usr/bin/pip3

5. 测试python3 和pip3

python3    -V

pip3 -V

升级到最新版pip3

pip3 install --upgrade pip

 

Mysql

1. 下载yum repo

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

2. 安装yum repo

rpm -ivh mysql57-community-release-el7-9.noarch.rpm  --nodeps --force

执行完成后会在/etc/yum.repos.d/目录下生成两个repo文件mysql-community.repo mysql-community-source.repo

3. 安装mysql server

cd /etc/yum.repos.d/

yum install mysql-server -y

4. 启动

systemctl start mysqld

5. 获取临时密码

grep 'temporary password' /var/log/mysqld.log

显示 password is generated for root@loaclhost: xxxxx
其中xxxxx是临时密码

 

6. 登录mysql

mysql -uroot -pxxxxx

如果登录成功可以继续往下

7. 修改密码和密码策略

第一次必须先设置比较复杂的密码，等下就会改个简单的
ALTER USER 'root'@'localhost' IDENTIFIED BY 'ABCD@123456'; 


设置密码的验证强度等级
set global validate_password_policy=LOW;

设置密码长度为6
set global validate_password_length=6;

设置简单密码mysql 
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; 

更新操作
flush privileges;

8. 配置默认编码为utf8

vi /etc/my.cnf 

[mysqld] 中添加
character_set_server=utf8 
init_connect='SET NAMES utf8'

9. 重启或者设置开机自启动

systemctl restart mysqld 

systemctl enable mysqld 

 

 

 

 

转载https://blog.csdn.net/wohiusdashi/article/details/89358071

 

 

 

 

本地安装MySQL5.6

mv  mysql-5.6.23 /usr/local/mysql

mkdir -p /data/mysql/var

mkdir -p /data/mysqllog

useradd -s /sbin/nologin mysql

chown -R mysql:mysql /data/mysql

chown -R mysql:mysql /data/mysqllog

进入/usr/local/mysql

 

cmake -DMYSQL_USER=mysql -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DINSTALL_DATADIR=/data/mysql/var -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1

 

make

make  install

chown -R mysql:mysql /usr/local/mysql

上传配置文件至/etc下

设置开机自启动

vi /usr/lib/systemd/system/mysql.service

 

[Unit]

Description=MySQL Server

Documentation=man:mysqld(8)

Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html

After=network.target

After=syslog.target

 

[Install]

WantedBy=multi-user.target

 

[Service]

User=mysql

Group=mysql

ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf

LimitNOFILE = 5000

#Restart=on-failure

#RestartPreventExitStatus=1

#PrivateTmp=false

 

systemctl enable mysql

 

设置环境变量

vi /etc/profile

export MYSQL_HOME=/usr/local/mysql

export PATH=$MYSQL_HOME/bin:$PATH

source /etc/profile

上传my.cnf至/etc下

初始化

chmod +x /usr/local/mysql/scripts/mysql_install_db

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/var &

启动mysql

systemctl start mysql

systemctl status mysql

修改密码

mysql -uroot -p -S /tmp/mysqld.sock

 

登陆报错问题：

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

mysql Segmentation fault (core dumped)

解决：

vim /usr/local/mysql/cmd-line-utils/libedit/terminal.c

把terminal_set方法中的 f[TC_BUFSIZE]; 这一行注释,再把 area = buf;改为 area = NULL;

 

重新执行编译过程

cmake -DMYSQL_USER=mysql -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DINSTALL_DATADIR=/data/mysql/var -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1

 

make

make  install

登陆测试：

mysql -uroot -p

CREATE USER 'root'@'%' IDENTIFIED BY 'djs@12316';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('djs@12316');

 

 

Ubuntu  安装python3.7

切换root用户： sudo su -

安装依赖包：apt-get install -y make build-essential libssl-dev zlib1g-dev libbz2-dev libreadline-dev libsqlite3-dev wget curl llvm libncurses5-dev libncursesw5-dev xz-utils tk-dev libffi-dev liblzma-dev python-openssl

下载python3.7： wget https://www.python.org/ftp/python/3.7.0/Python-3.7.0.tgz

创建目录：mkdir -p /usr/local/lib/python3.7

解压：tar -zxvf Python-3.7.0.tgz

安装到指定目录：./configure --prefix=/usr/local/lib/python3.7

编译安装：make&&make install

删除之前的pip3：rm -rf /usr/bin/pip3

创建软连接：ln -s /usr/local/lib/python3.7/bin/python3.7 /usr/bin/python3.7

创建软连接：ln -s /usr/local/lib/python3.7/bin/pip3 /usr/bin/pip3

测试：python3.7