mysql常用操作

编译安装

apt-get install lib32ncursesw5-dev

添加一个可远程登录的超级用户mysqladmin

grant all on *.* to mysqladmin@'%' identified by 'mysqladmin';
FLUSH PRIVILEGES;

重置root密码
先关闭mysqld，可以shutdown或者直接kill
以非grant方式启动mysqld

/usr/sbin/mysqld --defaults-file=/etc/mysql/slave.cnf --basedir=/usr --datadir=/data/mysql --user=mysql --log-error=./mysql.err --socket=/tmp/mysql.sock --port=3306 --skip-grant-tables

修改密码

mysqladmin -S /tmp/fe7.sock -u root flush-privileges password 'newpassword'

为master创建slave帐号

GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'slave_host' IDENTIFIED BY 'slave_password';

在slave上执行

CHANGE MASTER TO MASTER_HOST='master_host', MASTER_PORT=master_port, MASTER_USER='slave_user', MASTER_PASSWORD='slave_password'; MASTER_LOG_FILE='mysqldb.000225', MASTER_LOG_POS=50631514

其中master log的file和pos可以从master上show master status，或者slave的relay-log.info中得到

创建索引

CREATE INDEX id_index USING BTREE ON lookup (id);