After successfully installing Redmine via Bitnami under the CentOS 6.5 system, you want to use the Navicat for MySQL tool to remotely access the MySQL database for backup and restore operations to the database, with the following specific operations:
(1) Open the Navicat for MySQL tool to create a connection to the MySQL server that needs to be connected by responding to the ' Connect ' button in the tool
After entering the relevant connection information, you can see the connection name in the left directory tree, execute the right mouse button on the connection name, and then perform an open connection, in which case the following error is generally reported
When this error occurs, first consider whether MySQL is started, if it is started to consider the MySQL directory under the my.cnf file configuration problem, in the file in the [mysqld] section of the bind-address=127.0.0.1 commented out, and then re-right-click Execute ' Open connection ' action, at which point there may be an error reporting no access, as shown in:
The above error indicates that the database user name set at the time the connection is currently established does not allow access to the MySQL database, so you can enter the MySQL database using the root account (mysql-h 127.0.0.1-u root-p command at the shell prompt), Then at the database prompt, execute the grant all privileges on * * to ' the database account name that requires Telnet connection ' @ '% ' identified by ' password for the remote account name '; and flush privileges; The previous statement (that is, the statement beginning with the grant all privileges) means that the account specified in the statement is allowed to access the MySQL database from any IP;
If you forget the password of the root account of the database, you can modify the password of the root account by modifying the my.cnf file in the MySQL directory, by adding a line skip_grant_tables in the [mysqld] segment of the file and saving the exit, Then restart the MySQL database, after successfully restarting the database, the CD enters the MySQL directory at the shell prompt, and then executes the./bin/mysql, which then enters the MySQL database prompt, and then enters use MySQL to switch the database. After successfully switching the database, perform update user SET Password = Password (' New-password ') where user = ' root ' statement and flush privileges statement, the previous statement is to modify the root account Password, "New-password" in the statement is the new password, after successful execution, quit the database with quit, then delete and save the skip_grant_tables in the My.cnf file, exit, and then restart the MySQL database After successfully modifying the root password, then enter the MySQL database through the root account and then at the database prompt by executing grant all privileges the database account name ' @ '% ' that requires Telnet connection Identified by ' The password of the remote account name '; and the flush privileges statement to set the account specified in the Allow statement to access the MySQL database from any IP
Once the above settings are complete, you can access the MySQL database remotely via navicat for MySQL
Linux under Bitnami One-click installation redmine cannot remotely access MySQL problem