1,下载infobright-4.0.7-0-x86_64-ice.rpm,
2,rpm 命令安装该包,安装完毕后,infobright主目录为:/usr/local/infobright/
3,进入mysql用户下,执行/usr/local/infobright/bin/mysqld --skip-grant&启动
4,mysql-ib进入mysql控制台。
5,停止数据库服务:进入主目录/bin,执行./mysqld stop
6,配置用户名
# mysqladmin -uroot -p password ’newpassword’
Enter password:
mysqladmin: connect to server at ’localhost’ failed
error: ’Access denied for user ’root’@’localhost’ (using password: YES)’
现在终于被我找到了解决方法,如下(请先测试方法三,谢谢!):
方法一:
进入mysql用户下
# /etc/init.d/mysql-ib stop
# /usr/local/infobright/bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# /usr/local/infobright/bin/mysql-ib -u root mysql
mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# /usr/local/infobright/bin/mysqld-ib -uroot -p
Enter password: <输入新设的密码newpassword>
7,配置允许外部连接:
进入mysql控制台: mysqld-ib -u root -ppass ;
(责任编辑:IT) |