最近由于有一批mysql数据需要使用，平常使用的测试数据库所在的硬盘只剩60G了，不够用，所以找了一台存储比较给力的机器冲重搭建了一个mysql，当然这里没啥技术点，这里只是纯粹记录一下，方便之后遇到类似的问题便于查找。

参考了一篇写的不错的博客，具体在这里。

这里我只把关键的点列出来，假设我想安装的目录为：/disk1/username/mysql_work/

cmake  -DCMAKE_INSTALL_PREFIX=/disk1/username/mysql_work/local/mysql -DMYSQL_DATADIR=/disk1/username/mysql_work/local/mysql/data -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_UNIX_ADDR=/disk1/username/mysql_work/tmp/mysqld.sock -DWITH_INNOBASE_STORAGE_ENGINE=1

/disk1/username/mysql_work/local/mysql/scripts/mysql_install_db  --user=work --basedir=/disk1/username/mysql_work/local/mysql --datadir=/disk1/username/mysql_work/local/mysql/data --no-defaults


/disk1/username/mysql_work/local/mysql/scripts/mysql_install_db --defaults-file=/disk1/username/mysql_work/local/mysql/my.cnf --datadir=/disk1/username/mysql_work/local/mysql/data/ --basedir=/disk1/username/mysql_work/local/mysql/


touch /disk1/username/mysql_work/tmp/mysqld.sock

/disk1/username/mysql_work/local/mysql/bin/mysqld_safe  --defaults-file=/disk1/username/mysql_work/local/mysql/my.cnf &  [注意这里要指定my.cnf否则会使用默认的/etc/my.cnf]


/disk1/username/mysql_work/local/mysql/bin/mysqladmin -u root password 'complexpss123'


create user 'root'@'%' identified by 'complexpss123';

create user 'root'@'***.**.com' identified by 'complexpss123';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'complexpss123';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'***.**.com' IDENTIFIED BY 'complexpss123';

FLUSH  PRIVILEGES;