首页 > 代码库 > Python mysql

Python mysql

官方文档:http://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/

一、安装mysql

1.配置linux服务器上网

2.配置mysql yum源

http://dev.mysql.com/downloads/repo/yum/

3.安装yum源

rpm -Uvh platform-and-version-specific-package-name.rpm

4.安装mysql

sudo yum install mysql-community-server

5.启动mysql

service mysqld start

6.获取mysql的临时登录密码

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

7.登录mysql

shell> mysql -uroot -p
mysql> ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘Passw0rd!‘;

8.用navicat连接mysql

  注意一定要关闭windows防火墙和centos的防火墙

  systemctl stop firewalld.service

 

Python mysql