安装mysql:
1.sudo apt-get install mysql-server
2.mysql -u root
3.mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "123456";
配置数据库:
CREATE USER 'gerrit'@'localhost' IDENTIFIED BY 'secret'; //secret为密码
CREATE DATABASE reviewdb;
ALTER DATABASE reviewdb charset=latin1;
GRANT ALL ON reviewdb.* TO 'gerrit'@'localhost';
FLUSH PRIVILEGES;
配置gerrit:
type = MYSQL
hostname = localhost
database = reviewdb
username = gerrit
安装python mysqldb库
下载
1.wget http://sourceforge.net/projects/mysql-python/files/mysql-python-test/1.2.3b1/MySQL-python-1.2.3b1.tar.gz
2. 安装 MySQl-python
tar xvzf MySQL-python-1.2.2.tar.gz
cd MySQL-python-1.2.2
vi site.cfg
把 mysql_config = /usr/local/mysql/bin/mysql_config 这一行前的#去掉,并且把mysql_config的路径设置正确。
python setup.py build
sudo python setup.py install
安装结束
注意:终端直接键入命令mysql_config,若出现未找到该命令,则需要安装一下的包
sudo apt-get install libmysqlclient15-dev
然后再按照第2步重新操作。操作完毕后验证如下所示:
3. 测试
运行: python
import MySQLdb
如果没有报错,说明安装好了。
1.sudo apt-get install mysql-server
2.mysql -u root
3.mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "123456";
配置数据库:
CREATE USER 'gerrit'@'localhost' IDENTIFIED BY 'secret'; //secret为密码
CREATE DATABASE reviewdb;
ALTER DATABASE reviewdb charset=latin1;
GRANT ALL ON reviewdb.* TO 'gerrit'@'localhost';
FLUSH PRIVILEGES;
配置gerrit:
type = MYSQL
hostname = localhost
database = reviewdb
username = gerrit
安装python mysqldb库
下载
1.wget http://sourceforge.net/projects/mysql-python/files/mysql-python-test/1.2.3b1/MySQL-python-1.2.3b1.tar.gz
2. 安装 MySQl-python
tar xvzf MySQL-python-1.2.2.tar.gz
cd MySQL-python-1.2.2
vi site.cfg
把 mysql_config = /usr/local/mysql/bin/mysql_config 这一行前的#去掉,并且把mysql_config的路径设置正确。
python setup.py build
sudo python setup.py install
安装结束
注意:终端直接键入命令mysql_config,若出现未找到该命令,则需要安装一下的包
sudo apt-get install libmysqlclient15-dev
然后再按照第2步重新操作。操作完毕后验证如下所示:
3. 测试
运行: python
import MySQLdb
如果没有报错,说明安装好了。