Background: Install Alfresco in Linux and configure the database to connect to MySQL on other nodes. When the alfresco service is started, the log reports "HOST ***** isnotallowedtoconnecttothisMySQLserver ", this is because your MySQL database does not allow remote login from the account, but only on localhost. Solution: 1. Repair
Background: Install Alfresco in Linux and configure the database to connect to MySQL on other nodes, when the alfresco service is started, the log reports "HOST ***** is not allowed to connect to this MySQL server", because your MySQL database does not allow remote login from the account, it can only be in localhost. Solution: 1. Repair
Background:
Install Alfresco in Linux and configure the database to connect to MySQL on other nodes. When the alfresco service is started, the log reports "HOST ***** is not allowed to connect to this MySQL server ", this is because your MySQL database does not allow remote login from the account, but only on localhost.
Solution:
1. Modify the field value of the user table. On the computer of localhost, log on to mysql, change the "host" field in the "user" table in the "mysql" database, and rename the value from "localhost" to "% ", as shown in:
You can also run the following command to modify the host field value in the user table:
1) log on
Mysql-u root-p
2) enter the mysql database
Mysql> use mysql;
3) update the field value
Mysql> update user set host = '%' where user = 'root ';
Mysql> select host, user from user;
Note: after the table is changed, restart the MYSQL service.
2. You can directly authorize Alfresco to connect to the mysql server from any host.
Grant all privileges on *. * TO 'alfresco '@' % 'identified by 'alfresco' with grant option;
If you want to allow the user Alfresco to connect to the mysql server from a host with the ip address 192.168.67.129, and use Alfresco as the password
Grant all privileges on *. * TO 'alfresco '@ '192. 168.0.105 'identified BY 'alfresco' with grant option;
In fact, the above solution is to set up the MySQL database and be familiar with MySQL. These problems are easy to handle.