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;­

原文地址:https://www.cnblogs.com/strikebone/p/3593404.html