We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
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.