mysql 基本使用

yum install mysql-service

yum remove mysql-service(如果要删除感觉,可以考虑删除/var/lib/mysql 重试)

启动服务

service mysqld start

添加用户：

insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values("localhost","pppadmin",password("1234"),'','','');

赋予权限：

grant all privileges on test.* to pppadmin@'%' identified by '1234';

更新密码：

update mysql.user set password=password('d1d87f4f-8') where User="phplamp"

 

刷新权限;

flush privileges;­