- linux mysql
yum -y install mysql-server - 启动mysql服务并设置管理员密码
service mysqld start
/usr/bin/mysqladmin -u root password ‘123456’
登录 mysql -u root -p123456
mysql修改密码(1) mysqladmin -u root -p password “test123”
(2) Enter password: 【输入原来的密码】 - 打开mysql远程访问权限
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘123456’;
flush privileges;
use mysql
delete from user where host like ‘hadoop%’;
delete from user where host like ‘l%’;
delete from user where host like ‘1%’;
service mysqld restart