一、搭建MySQL数据库与python的联系
[root@foundation50 ~]# yum install mariadb-server -y 安装服务
[root@foundation50 ~]# systemctl start mariadb 开启服务
[root@foundation50 ~]# systemctl status mariadb 查看服务状态
[root@foundation50 ~]# systemctl stop firewalld 关闭防火墙
[root@foundation50 html]# mysql_secure_installation 重置密码
Set root password? [Y/n]
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
[root@foundation50 ~]# mysql -uroot -p 登陆
[root@foundation50 ~]# yum install gcc -y 安装
[root@foundation50 ~]# yum search MySQL-python
[root@foundation50 ~]# yum install MySQL-python.x86_64 -y 安装服务
[root@foundation50 ~]# pip install Mysql-Python 建立连接
在pycharm中导入import MySQLdb (变成灰色) 就成功了
1、搭建网页版来管理数据库:
[root@localhost ~]# yum install php httpd -y ##安装php httpd服务
[root@localhost ~]# yum install php-mysql -y ##安装php-mysql服务
[root@localhost ~]# systemctl start httpd ##开启服务
[root@localhost ~]# systemctl stop firewalld ##关闭防火墙
#####这里需要有phpMyAdmin-3.4.0-all-languages.tar.bz2文件包#####