Linux under Bitnami One-click installation redmine cannot remotely access MySQL problem

Source: Internet
Author: User
Tags redmine

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.