Vds database issue

[justin2234]

My vds wont let me install my forums with a hostname of the actual website. it works on my other vds but i just made this new vds and it wont let me.
Its only letting me install with "localhost" which i dont want, i want to use the actual ip for the hostname. is there something in apache2 blocking this that i can unblock?

Using: Linux unmanaged 1 core vds

[Vanderburg]

Do you have an actual domain or subdomain pointing to the VDS, or are you referring just to the hostname that is set when it's installed? The hostname set during the OS installation is just your identifier and doesn't actually resolve to anything.

[justin2234]

Do you have an actual domain or subdomain pointing to the VDS, or are you referring just to the hostname that is set when it's installed? The hostname set during the OS installation is just your identifier and doesn't actually resolve to anything.

i bought a domain, connected it with type "A" targeting the vds IP.
but im just installing a forums and a sourcebans and i need the "hostname" which i always use the vds ip and so that always works but for this newly made vds its not allowing me to do it and says it cannot connect to mysql. Yet its making me do it to "localhost" for the hostname which works except the actual ip... which i cant do and is what i need to connect the sourcebans and many other things in my vds phpmyadmin databases.
Im wondering if apache2 has a config that blocks this?

[soja]

Ok so you're having issues setting your mysql server, that is different from the initial tone of your post.

Is the MySQL server you are trying to use local or remote(on another vds, or on NFOs shared webhosting)?

Also, this should have nothing to do with apache.

[justin2234]

Ok so you're having issues setting your mysql server, that is different from the initial tone of your post.

Is the MySQL server you are trying to use local or remote(on another vds, or on NFOs shared webhosting)?

Also, this should have nothing to do with apache.

The vds i have is on nfo. Its not letting me use the vds ip as the hostname for anything it says "mysql cannot connect" yet the user/pass/database name is all correct. Its the hostname which its not letting me use which is frustrating, im not sure how to fix this.

[soja]

Is your database server local(on the same machine as your web server) or remote(on a different VDS)?

[justin2234]

Is your database server local(on the same machine as your web server) or remote(on a different VDS)?

On the same machine, that same vds i installed apache2,mysql,phpmyadmin,php. and i threw the sourcebans and forums files on that vds ftp and i have the databases on there as well.

[justin2234]

Someone said bind a ip address to mysql so it allows access?

[justin2234]

Found the issue...
all i needed to do is go to
/etc/mysql/mysql.conf.d/mysqld.cnf

and remove bind-address = 127.0.0.1 by just adding a #

[soja]

Found the issue...
all i needed to do is go to
/etc/mysql/mysql.conf.d/mysqld.cnf

and remove bind-address = 127.0.0.1 by just adding a #

localhost or 127.0.0.1 was the proper address to use in your configuration. If you don't need to access the mysql server remotely(from game servers and such) you should put the mysql server back to bind on 127.0.0.1. With the configuration change you made you allowed the mysql server to be accessible from the outside world, which is an unnecessary security risk if you don't need external access.

[justin2234]

Found the issue...
all i needed to do is go to
/etc/mysql/mysql.conf.d/mysqld.cnf

and remove bind-address = 127.0.0.1 by just adding a #

localhost or 127.0.0.1 was the proper address to use in your configuration. If you don't need to access the mysql server remotely(from game servers and such) you should put the mysql server back to bind on 127.0.0.1. With the configuration change you made you allowed the mysql server to be accessible from the outside world, which is an unnecessary security risk if you don't need external access.

oh well then....