Mysql

yum install -y mysql-server mysql mysql-devel
service mysqld start #初始化及相关配置
chkconfig --list | grep mysqld #查看mysql服务是不是开机自动启动
chkconfig mysqld on #设置成开机启动
mysqladmin -u root password '123456'  #通过该命令给root账号设置密码为 123456
mysql -u root -p #登录mysql数据库
create database confluence character set UTF8;
grant all on confluence.* to confluence@"%" identified by "confluence";
grant all on confluence.* to confluence@"localhost" identified by "confluence";
FLUSH PRIVILEGES;
quit  #退出
service mysqld stop  #关闭mysql服务
cd /etc/
vi my.cnf
在[mysqld]下面加上character-set-server =utf8    #解决中文显示???的乱码问题
service mysqld start   #启动mysql服务

results matching ""

    No results matching ""