Cannot create database on Remote mysql percona server
-
- Posts: 1
- Joined: Thu Feb 04, 2016 1:39 pm
Cannot create database on Remote mysql percona server
I have a 2 server setup. The web server is where I have my Vestacp installed and a Percona version 5.6 mysql database server.
Both are installed on Centos 6.7 64 bit servers. I have added the remote Mysql server in my Vestacp.
v-list-database-hosts
HOST MAX_DB U_DB_BASES SUSPENDED DATE
------ ------ ------ ------ ------
localhost 500 1 no 2016-02-04
10.0.18.83 500 0 no 2016-02-04
On the Percona mysql server I have open 3306 port on iptables and given the below permission in mysql
GRANT USAGE ON *.* TO 'dbadmin'@'%' IDENTIFIED BY 'kmEZLB97769s' ;
GRANT ALL PRIVILEGES ON *.* TO 'dbadmin'@'%'
commit;
cat /usr/local/vesta/conf/mysql.conf
HOST='localhost' USER='root' PASSWORD='e9Bcp897JtwS' CHARSETS='UTF8,LATIN1,WIN1250,WIN1251,WIN1252,WIN1256,WIN1258,KOI8' MAX_DB='500' U_SYS_USERS='admin' U_DB_BASES='1' SUSPENDED='no' TIME='11:07:46' DATE='2016-02-04'
HOST='10.0.18.83' USER='dbadmin' PASSWORD='kmEZLB97769s' CHARSETS='UTF8,LATIN1,WIN1250,WIN1251,WIN1252,WIN1256,WIN1258,KOI8' MAX_DB='500' U_SYS_USERS='' U_DB_BASES='0' SUSPENDED='no' TIME='12:29:20' DATE='2016-02-04'
Now I want to add a database on the Remote Mysql server with the below details
DBname admin_bulkdeal
user admin_bulkdeal
password xD7rxEzMif
Host IP 10.0.18.83
I get Error:Connection to 10.0.18.83 failed. and database creation abort. I can create database in localhost. But I want all the databases to reside on a remote server.
My Webserver can connect to database server through cli command.
mysql -h 10.0.18.83 -u dbadmin -p
and it is successful.
Can anyone help me understand why I am getting the above error.
Both are installed on Centos 6.7 64 bit servers. I have added the remote Mysql server in my Vestacp.
v-list-database-hosts
HOST MAX_DB U_DB_BASES SUSPENDED DATE
------ ------ ------ ------ ------
localhost 500 1 no 2016-02-04
10.0.18.83 500 0 no 2016-02-04
On the Percona mysql server I have open 3306 port on iptables and given the below permission in mysql
GRANT USAGE ON *.* TO 'dbadmin'@'%' IDENTIFIED BY 'kmEZLB97769s' ;
GRANT ALL PRIVILEGES ON *.* TO 'dbadmin'@'%'
commit;
cat /usr/local/vesta/conf/mysql.conf
HOST='localhost' USER='root' PASSWORD='e9Bcp897JtwS' CHARSETS='UTF8,LATIN1,WIN1250,WIN1251,WIN1252,WIN1256,WIN1258,KOI8' MAX_DB='500' U_SYS_USERS='admin' U_DB_BASES='1' SUSPENDED='no' TIME='11:07:46' DATE='2016-02-04'
HOST='10.0.18.83' USER='dbadmin' PASSWORD='kmEZLB97769s' CHARSETS='UTF8,LATIN1,WIN1250,WIN1251,WIN1252,WIN1256,WIN1258,KOI8' MAX_DB='500' U_SYS_USERS='' U_DB_BASES='0' SUSPENDED='no' TIME='12:29:20' DATE='2016-02-04'
Now I want to add a database on the Remote Mysql server with the below details
DBname admin_bulkdeal
user admin_bulkdeal
password xD7rxEzMif
Host IP 10.0.18.83
I get Error:Connection to 10.0.18.83 failed. and database creation abort. I can create database in localhost. But I want all the databases to reside on a remote server.
My Webserver can connect to database server through cli command.
mysql -h 10.0.18.83 -u dbadmin -p
and it is successful.
Can anyone help me understand why I am getting the above error.