mysql权限修改

yum方式安装mysql
yum install mysql-server -y


启动mysql
service mysqld start
设置开机启动
 chkconfig mysqld on
 chkconfig mysqld --list


进入mysql客户端
mysql
    use mysql;
    select user, host, password from user;
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;
    delete from user where host != '%';
    flush privileges;
    quit;


进入mysql客户端
mysql -u root -p
输入密码 123 回车