mysql -e "update mysql.user set password=PASSWORD('123.com') where user='root';" //修改密码
mysql -e "flush privileges;" //使修改的密码生效
mysql -uroot -p123.com -e "create database cacti;" //创建数据库cacti
mysql -uroot -p123.com cacti < /var/www/html/cacti/cacti.sql //导入数据
mysql -uroot -p123.com -e "grant all on cacti.* to 'cactiuser'@'localhost' identified by 'cactiuser';" //授权用户连接
转载于:https://blog.51cto.com/linchqd/1316753