本文共 836 字，大约阅读时间需要 2 分钟。

之前写了几篇mysql多实例或主备安装文章，但由于实验需要，反而要一个快速简单部署的mysql，so mark如下：

--------------------

rm /appl/mysql/data/dbdata

scripts/mysql_install_db --user=root --basedir=/appl/mysql --datadir=/appl/mysql/data/dbdata bin/mysqld_safe --basedir=/appl/mysql --user=root & mysql -uroot

show databases;GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "root";GRANT ALL PRIVILEGES ON *.* TO root@centos1 IDENTIFIED BY "root";FLUSH PRIVILEGES;use mysql;show tables;select host,user,password from user;exit

mysql -uroot -proot (或mysql -hcentos1 -uroot -proot）

use test;create table bigdata (id int, name char(10));insert into bigdata values(1,'a');commit;select * from bigdata;exit

--------- /appl/mysql/my.cnf

[mysqld]server-id = 1port     = 3306socket   = /tmp/mysql.sockdatadir  = /appl/mysql/data/dbdatacharacter_set_server=utf8# skip-grant-tables

转载地址：http://rdili.baihongyu.com/