1, download the infobright-4.0.7-0-x86_64-ice.rpm, 2, rpm command to install the package, after the installation is complete, infobright home directory:/usr/local/infobright/3, enter the mysql User, run/usr/local/infobright/bin/mysqld -- skip-grant & amp; start 4, mysql-ib go to mysql control 1, download infobright-4.0.7-0-x86_64-ice.rpm, 2, rpm command to install the package, after the installation is complete, the main directory of infobright is/usr/local/infobright/3. enter the mysql User, run/usr/local/infobright/bin/mysqld -- skip-grant & start 4 and mysql-ib to enter the mysql console. 5. stop the database service: go to the main directory/bin and run. /mysqld stop 6, configure the username # mysqladmin-uroot-p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user' root' @ 'localhost' (using password: YES) 'is the solution I have found. (test method 3 first. thank you !): Method 1: Enter the mysql User #/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> 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. configure to allow external connections: go to the mysql console: mysqld-ib-u root-ppass;
- SELECT 'host', 'user' FROM User;
- UPDATE user SET 'host' = '%' WHERE 'user' = 'root' LIMIT 1;
- Flush privileges;