MariaDB 安装配置

1、下载安装（http://www.mariadb.org/）

2、创建普通用户 hzrong

CREATE USER 'hzrong'@'%' IDENTIFIED BY '密码';
GRANT ALL PRIVILEGES ON *.* TO 'hzrong'@'%';

3、使用hzrong登陆报错

提示无法登录：ERROR 1045 (28000): Access denied for user 'appadmin'@'localhost' (using password: YES)

参考：http://anonymity.iteye.com/blog/347737

grant select,insert,update,delete on test.* to hzrong@"localhost" identified by "密码";

登陆成功！

4、更改密码

切换到root下

update mysql.user set password=password('新密码') where User="hzrong" and Host="localhost";

flush privileges;

更改密码后一定要flush privileges;下否则无法登陆成功须得重新启动服务才行。